I have a problem with the database.
I have SQL Server Developer installed on my local computer. When I open SQL Server Management Studio and register with Windows Authentication, there is no problem. I created a new database there and added a new user. The new user is the owner of the database.
When I disconnect from a Windows session and try to log in with a newly created user in SQL Server authentication mode, I get the message "cannot connect to (local)"
Please, help!
source
share