In Management Studio, if I go 'Security' --> 'Logins' --> 'New Login' --> something simple like username='test' and password='test', I am still unable to use this login - why? Is there something really obvious that I am missing?

If I create 'X.UDL' in windows explorer and use 'Microsoft OLD DB Provider for SQL Server', the only way I can get a list of databases is by using 'Windows NT Integrated Security' - none of my logins work.


Check if Mixed Authentication Mode (SQL Server and Windows) enabled for your SQL Server instance. Use SQL Server configuration Manager or right click on server name in Management studio -> Properties -> Security

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.