Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: 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,

    Jeff

  2. #2
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Changing Windows Domain

    Originally 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.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •