sql server default username and password

Question

sql server default username and password

kornflakes20

Old Hand

Points: 357
More actions
May 6, 2008 at 9:25 pm

#190018

hello guys!
i am new here at sqlservercentral.com and this is my first post 🙂
i have some questions that is boggling my mind :w00t:
first is that... im new visual studio.net 2005 and i just want to ask if what is the default username and password of sql server 2005.
second is... how can i also access sql server 2005 express to another pc?
and the third one is... if for example i successfully created my own app in c# / vb.net, is it possible to bundle sql server 2005 express in the installation?
thanks for reading my post guys! 😀

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 1

1. There is no default user/password per se. By default, BUILTIN\Administrators is granted sysadmin role, so any local administrator will be able to log in.

2. Make sure that SQL Server is configured to listen on TCP/IP for a start (use SQL Server Configuration Manager)

3. You should be able to, other companies had. I haven't done it myself, so don't know the specifics, but presumably you would call a silent installation of SQL Express from your install program. After it is installed, run whatever CREATE scripts are required.

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

kornflakes20 Old Hand Points: 357 More actions · Answer 2

Thanks for the reply... 🙂

I develop a Classic ASP site that has an ad management system and i want to migrate my ad management system database (MySQL Database) to SQL Server 2005 Express.

First of... i cannot login to the SQL Server in Classic ASP (i dont know how to connect using connectionstring of SQL Server 2005 Express) unlike ACCESS/MySQL has username/password on it.

Second is... the SQL Server 2005 will not be deployed in the webserver rather... it will be deployed in our database server (another pc).

The SQL server 2005 is installed by default in Visual Studio 2005 which is located in our database server. how can i add user that can access my machine that will my webserver?

thanks for reading my post! 🙂

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 3

First, forget about Access. SQL Server is a server, like a mail server (Exchange) and so there isn't "a user" or a default.

It doesn't matter if SQL is on the same pc or another, you connect the same. With Express you need to be sure that remote connections are enabled, but the connection is the same. Use TCP, 1433 should be the default, but if you use Express and might end up with multiple instances, be sure that you pick a port that's unused and document that.

The local administrator on the SQL Server machine is an administrator in SQL Server by default. That's called a sysadmin in SQL Server. Connect with that account and then you can add a "login" that you can use to connect. If you want to expect some Windows group, like Power Users, and use NT authentication, then you can connect with SQL Server specifying a trusted connection. If you want to use a name/password, you must create a login (with password), and then create a user in the database where you will store your data.

varsha.sinyal SSC Enthusiast Points: 100 More actions · Answer 4

Hello

Friends

new to sqlservercentral

i want to connect my web application to sql express come with vs 2005 but don't know the user name and password then what is the procedure to know the user id n pwd .

also let me knw what will be exact connection string for it!

thanks in advance

steveb. SSC-Forever Points: 46733 More actions · Answer 5

varsha.sinyal (7/7/2008)
Hello
Friends
new to sqlservercentral
i want to connect my web application to sql express come with vs 2005 but don't know the user name and password then what is the procedure to know the user id n pwd .
also let me knw what will be exact connection string for it!
thanks in advance

Your user name and password will be whatever you set it to under Logins. Either use Windows Authentication or SQL Authentication it is up to you..

kornflakes20 Old Hand Points: 357 More actions · Answer 6

first of all, i finally found the solution for this problem.

first is download Microsoft SQL Management Studio Express here. install and run Management Studio Express. Log in using windows authentication.

you can add users there and use this connectionstring in any programming language. mine is classic asp / vb

Driver={SQL Native Client};Server=COMPUTERNAME\SQLEXPRESS;Database=databasename;Uid=username;Pwd=password;

if you are using vs.net 2005, you can simply use windows authentication. there is a video on this in http://msdn.microsoft.com/.

if you are using SQL express... dont forget to add \SQLEXPRESS before the COMPUTERNAME (eg. COMPUTERNAME\SQLEXPRESS)

goodluck!

varsha.sinyal SSC Enthusiast Points: 100 More actions · Answer 7

hi

thanks for your help

i have installed management studio

and use the foll connection string

"data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|abc.mdf;User Instance=true"

and my problem is solved

thanks onec again

amit2820 Valued Member Points: 63 More actions · Answer 8

Hello All,

What is the connection string if we are using JAVA Language and i'm using windows Authentication and my database name is temp............?

Thanks

Amit Trivedi

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Please post new questions in a new thread. Thank you.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass