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?
