Networks

Ask something
Discussion Locked

SQL Server Changed to new domain

0 helpful
2 replies

by michaeldanielwinn

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
OK, here's a little back ground, I changed our SQL server (running on windows 2000 advanced server) to a new domain. The PDC is running Windows 2003 Server Enterprise edition (the old PDC was Windows NT 4.0). Now I am having difficulty with the SQLServer Client. Iwas ablr to change the logon under the services for the MSSQL Server to the new domain\user but the SQLServer agent would not recognise the new domain, and I am basically getting a permissions error when I try to set the SQLServer agent to automatically restart on power up. It can't creat a new key in the registry. Do I need to delete the Server registration and re-register the server, and if so, will that affect the existing databases, or is there someplace else I need to change the domain name from the old to the new?

2 replies

by shawn

First, what security mode are you working in - Windows Authentication or Mixed Mode? If you're using Windows Authentication, verify that your domain user account is either a member of the local admins group on the SQL server (the local Admins group is given login rights to SQL automatically - if you're a domain admin, check to make sure that Domain Admins has been added to the local Administrators group), or add your domain account as a SQL login.

Hope this helps.

Cheers,
Shawn

This discussion is closed to new replies.