CODEWITHSUNDEEP
databasesql-server-2008
Andy
Andy

Reputation: 503

Cannot connect to "local" (SQL Server 2008)

I have some database problems.

I have SQL Server Developer installed on my local machine. When I open SQL Server Management Studio and log in with windows authentication there is no problem. I have created a new database there and added a new user. The new user is owner of the database.

When I disconnect from my windows session and try to log in with the newly created user in SQL Server authentication mode I get the 'cannot connect to (local)'

Please help!

Upvotes: 3

Views: 9795

Answers (1)

KristoferA
KristoferA

Reputation: 12397

Have you enabled SQL Server authentication? (During installation and/or afterwards)

If not, connect using windows authentication, right-click on the server instance, go to properties and change auth mode...

alt text

Upvotes: 7

Related Questions