Changing Windows Domain

I have a SQL server that is in an old NT4 domain. We need to move it to a Windows 2000 domain. We tried changing the domain of the server but now the SQL services will not start. We set the sql service to use an account in the new domain and still get an access denied error when trying to start the service.

Any ideas?

Thanks,

JeffOriginally posted by jpoling
I have a SQL server that is in an old NT4 domain. We need to move it to a Windows 2000 domain. We tried changing the domain of the server but now the SQL services will not start. We set the sql service to use an account in the new domain and still get an access denied error when trying to start the service.

Any ideas?

Thanks,

Jeff

Did you change both the MSSQLServer and SQLServerAgent user ids?
Are you sure the former accounts were domain accounts and not local accounts?
Did you change the accounts in the EM?
Or did you do it in the Service Manager on the Control Panel?
Did the server name change as well?
Did the sever create an account in the new Domain?

Just throwing some of the more obvious places to look.|||I think I solved the problem. We changed the account the sql service runs as through control panel | services and not through EM. When we went back and changed it through EM first, it worked.

Thanks for the suggestions!

Jeff