Cannot connect to "local" (SQL Server 2008)

Question

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!

Answer 1

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...