• Are these logins Windows logins or SQL logins?

    When your login fails, what do you see in the error log? There should be the same error message as you get when you log in, but there is a state number which gives further information why the login fails. (There are blog posts out there explaining these state numbers, but where I sit right now, I don't have a URL.)

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]