Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to connect to database after domain migration Expand / Collapse
Author
Message
Posted Monday, June 3, 2013 5:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:53 AM
Points: 1,187, Visits: 1,537
Hi

We just migrated our windows 2003 server to a new domain. We created a new service account and set the sql services to start under the new domain account (through configuration). SQL server and all services are running just fine. If I am on the server itself, I can connect using Windows authentication from SSMS, but if I am on my client machine (both my user and machine were already on the new domain), I can only connect via SSMS using a sql login (sa).

I get an "cannot generte SSPI context" error. Googling that has not given me any useful clues.

Can anyone please help?

Many thanks

Bex
Post #1459183
Posted Tuesday, June 4, 2013 6:07 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 1,635, Visits: 5,592
Generally that error means that something is not set up right in your new domain. For instance, the only occasions I can recall seeing it are when the DNS server on the client machine was set incorrectly--Active Directory uses DNS to find the servers on the domain, and if the DNS server it's configured to use returns the wrong values, it will cause errors like this. No idea if that's the specific problem in your case, but it's definitely worth checking.
Post #1459693
Posted Tuesday, June 4, 2013 12:57 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:53 AM
Points: 1,187, Visits: 1,537
Thank you. Our network guy has been out, but back tomorrow, so I'll ask him to check.

Appreciated!

Bex
Post #1459910
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse