Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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