Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server default username and password Expand / Collapse
Author
Message
Posted Tuesday, May 6, 2008 9:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2008 8:01 PM
Points: 3, Visits: 7
hello guys!

i am new here at sqlservercentral.com and this is my first post :)

i have some questions that is boggling my mind

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! :D
Post #496039
Posted Tuesday, May 6, 2008 10:16 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 1:18 PM
Points: 2,664, Visits: 830
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
Post #496053
Posted Friday, May 9, 2008 8:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2008 8:01 PM
Points: 3, Visits: 7
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! :)




Post #497952
Posted Friday, May 9, 2008 9:02 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:53 PM
Points: 31,177, Visits: 15,623
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.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #497969
Posted Monday, July 7, 2008 12:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2008 10:38 AM
Points: 2, Visits: 1
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
Post #529560
Posted Tuesday, July 8, 2008 4:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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..
Post #529888
Posted Tuesday, July 8, 2008 7:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2008 8:01 PM
Points: 3, Visits: 7
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!
Post #530011
Posted Thursday, July 10, 2008 10:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2008 10:38 AM
Points: 2, Visits: 1
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

Post #531792
Posted Thursday, January 27, 2011 10:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 7:56 PM
Points: 1, Visits: 44
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
Post #1055079
Posted Friday, January 28, 2011 2:37 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:08 PM
Points: 40,177, Visits: 36,580
Please post new questions in a new thread. Thank you.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1055168
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse