I am doing some tests here with SQL Server. Using the management studio I can connect to the server using my Windows user. Using that, I want to create a user and access a database.
I went to the security folder, added a login, selected the SQL authentication, set the user and password.
After that I added a user in the database using the login I just created (I gave the same name to both).
When I try to open a new connection, I select SQL Authentication and input the user and password, but I get an error that I can connect:
Cannot connect to localhost.
Login failed for user 'qwe'. (.Net SqlClient Data Provider)
Am I missing something?
View Complete Post