Monday, March 12, 2012

Move SQL 2000 server from workgroup to a domain

I have been asked to move a system running MS SQL 2000 Server from a workgroup to a domain. The SQL server is running in SQL Authentication and the services are running as local system.

Will SQL Server break after the move?

Any advice will help. I thought I remember this being the case, but possibly only with Windows Authentication.

As always it's best to test before you try something like this on a Production server, but you should not have any problems. If SQL Server is running under Local System, that should not impact anything because Local System will still be there after you join the domain. As far as any SQL authentication accounts, they should not be impacted either because they are local accounts to SQL whether or not the server is in a Workgroup or a Domain.

With that said, test, test, and test

|||Nope, it will not break. This is transparent to SQL Server. The only thing that matters is the service account. Other accounts can be configured to use domain accounts once the move has been completed|||

Thanks for the advice. I thought it would be ok, but I just wanted to get some additional thoughts on the matter.

Cheers.

|||I have this project in plan that going to migrate SQL Login authentication into Windows authentication with AD integrate. But I worried about those application user ID, Task Scheduler, DTS package that created by using SQL account. So does it will affect those user ID login once integrate into AD windows authentication.

Any idea where can find the proper sulotion on the net?

No comments:

Post a Comment