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.