Thursday, July 12, 2012 4:43 PM
I am running SQL Server 2008 R2.
I've set up a new user in the Security\Logins folder, and have mapped this user to the database I want the user to have access to. I also set this database as the Default database, and gave the new user db_datareader and db_datawriter roles.
When I try to 'Connect...' to 'localhost' using SQL Server authentication using this newly created Login, I always get "Login failed for user 'NewUser'".
How can I determine the issue or further troubleshoot? Thanks very much.
Thursday, July 12, 2012 4:47 PM
Is the SQL Server running in "Mixed Mode" authentification to allow SQL login and not only Windows logins?
- Marked As Answer by ps0118mj Thursday, July 12, 2012 6:13 PM
Thursday, July 12, 2012 4:49 PMYes I'm pretty sure it is, but how can I verify?
Thursday, July 12, 2012 6:15 PM
That was it, I only had Windows logins enabled.
For anyone else's reference, in SQL Server Management Studio, right-click on the server, select 'Properties', then the 'Security' item, and ensure that 'SQL Server and Windows Authentication mode' is selected.