General discussion


SQL Server Changed to new domain

By michaeldanielwinn ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by shawn In reply to SQL Server Changed to new ...

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.


Collapse -

by michaeldanielwinn In reply to SQL Server Changed to new ...

This question was closed by the author

Related Discussions

Related Forums