Can't Connect w/ SQL Management Studio After Domain Change

Posted by Sam on Server Fault See other posts from Server Fault or by Sam
Published on 2012-04-09T15:13:39Z Indexed on 2012/04/09 17:37 UTC
Read the original article Hit count: 328

Our old Small Business Server 2003 (acting as our domain controller) was on the fritz, so we replaced it with a new Windows Server 2008 box and set the server up as our new domain controller. In hindsight, it may have been a mistake, but we set up the new server as a replacement and tried to keep as much the same as possible, including the DOMAIN name. The problem was, that even though the domain name was the same, the guest computers somehow still realized it was not the exact same domain. We had to unjoin and rejoin the domain and port over everyone's documents and settings.

This morning, when I attempted to connect to my local SQL Server Instance, it was saying that my login failed. When I tried to use the SQL Management Studio, it throws the error "Package 'Microsoft SQL Management Studio Package' failed to load" on startup, then exits without giving me a chance to change the login. I am using Mixed Authentication and have an administrative account as a backup.

Ideas? If there is a more appropriate stack, please let me know where to put it.

© Server Fault or respective owner

Related posts about sql-server

Related posts about active-directory