Hello all. I am running two instances (SQL Server-2000 and SQL Server-2005) on my workstation and I have domain admin rights in active directory. Yesterday I had to change my password in active directory. I have a cluster in which I can no longer connect to the virtual server with my credentials. I've deleted and readded myself in the primary servers logins, gave myself system admin rights and made myself owner of all of the databases. With the EM in 2000 I can connect as "sa" (Thank GOD) but not with my user name in active directory. The error that I get when I try and connect the database engine with my user name in 2005 is:
Cannot connect to DOCVS1
Login failed for user 'null'. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452).
With 2005 I can't even connect using the "sa" account with SQL authentication. Can someone help me resolve this? Thanks, Jordan.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.