September 6, 2005 at 12:53 pm
Our network team is upgrading NT domain controller to 2003. Our sql servers are also part of that domain. My question is…should we worry about anything related to sql server, users…etc. We’ve setup “SA’ account and have nothing to do with windows authentication or mix mode. Any feed back would be greatly appreciated. Thanks
September 7, 2005 at 2:19 am
Change Domain accounts to Local accounts for the SQL services before the DC upgrade.
You will have to change the SQL Server from a NT domain member server to a Workgroup member before the DC upgrade, and Join the new domain after the DC upgrade.
All NT user and group accounts will then be invalid in SQL Server and will have to be re-created after joining the new domain. So much for the suggested Integrated Authentication, SQL Authentication does not require this step.
Change the SQL service accounts back to Domain accounts.
You will have to re-create the SQL Mail Outlook profile, if you use SQL Mail.
Andy
September 7, 2005 at 9:50 am
Thanks for your reply. I just wanted to inform you that all our SQL servers are runs on windows 2003 enterprise but connected to old NT domain. Network group decided to upgrade NT DC to Windows 2003.
September 7, 2005 at 9:51 am
PS: do I need to change the SA account as well ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply