What is the default username and password of my SQL Server Express?

Question

It installed automatically with Visual Studio 2010 Ultimate. I didn't create any users for the server or ANYTHING.

I'm using:

string connectionString = @"Server=.\SQLEXPRESS;Database=SportsStore;Trusted_Connection=yes;";

I get error that authentication failed. So the server is being found, but my credentials are wrong. What would the default login and password be?

Edit: Still not working! :(

Here's my connection string:

string connectionString = @"Server=.\SQLEXPRESS;Database=SportsStore;Integrated Security=SSPI;";

And the error message:

Cannot open database "SportsStore" requested by the login. The login failed. Login failed for user 'ToshibaLaptop\Sergio'.

Darin Dimitrov · Answer 1 · 2010-08-07T14:29:53.403

5

If you are using SQL Server authentication you could try the username sa and blank password but I am not sure whether this is by default. Integrated Windows authentication should work, so you should be able to connect with your Windows account:

string conn = "Data Source=.\SQLExpress;Initial Catalog=mydb;Integrated Security=SSPI;";

edited Aug 07 '10 at 14:29

answered Aug 07 '10 at 14:24

Darin Dimitrov

1,023,142
271
3,287
2,928

The server installer asked me for a password, I'm using sa as user (login) and the password given and I can connect me to the server. – William Ardila Nov 23 '17 at 06:03

score 3 · Accepted Answer · answered Aug 07 '10 at 14:24

3

You probably should not connect using Sql Server Authentication.

Log in as an Administrator on the box, connect using Integrated Windows Authentication, and you should be a system admin.

answered Aug 07 '10 at 14:24

Dave Markle

95,573
20
147
170

1

@Sergio Tapia: use the `Integrated Security` flag. See Darin Dimitrov's answer. – BoltClock Aug 07 '10 at 14:30
Is there someway to get a connection string from a Linq-to-sql file? If I use that it justworks, but doing manually nothing works. – Sergio Tapia Aug 07 '10 at 14:41
1

Linq to SQL should put the connection string in your app.config or web.config. Copy it from there. – Dave Markle Aug 07 '10 at 15:19

score 1 · Answer 3 · answered Aug 07 '10 at 15:49

The error message indicates that SQL Server can't open the database. I think you're successfully authenticating, but having a problem connecting to the database. Is the database available?

You can do a test by changing the database to master in your connection string. If that succeeds, then you're problem is related to the database. I understand that you may get other errors, but the test is to confirm that you can login to SQL Server.

score 1 · Answer 4 · answered Oct 03 '17 at 06:45

For me SQL Server (SQLEXPRESS) service was disabled so it was throwing the error. After enabling the service SSMS is working fine

Goto Run command and type services.msc and click on OK button
Services window will open. Check the status of SQL Server (SQLEXPRESS) service
If the service is not running, then start the service

Now try logging in again in the SSMS.

score 0 · Answer 5 · answered Aug 07 '10 at 14:25

0

In SQL 2008 if you use the defaults there won't be a SQL Server user only Windows Authentication will be enabled - and it will only work for the user that installed the application would have access via their Active Directory authentication.

answered Aug 07 '10 at 14:25

u07ch

13,324
5
42
48

What is the default username and password of my SQL Server Express?

5 Answers5