Adding a member server to AD

[wcuz]

I've got a production Windows 2000 stand-alone server running SQL server 2000 with multiple local user accounts. The server's been running in a Netware environment and I've migrated to wins2k3 so now I need to add the server to a Windows server 2003 AD environment as a member server. The users that currently maintain local accounts on the win2k server have been moved to the wins2k3 domain. Can I just join the win2k server to the wins2k3 domain and delete the local accounts? Do I need to do anything special with the local account settings?

Thanks for any help....

 

[markdmac]

Before deleting those accounts you will want to join the server to the domain as a member server. This won't mess up any local security rights that have been assigned in SQL, but you will need to edit those settings to add in the domain accoutns that match the local ones to ensure the same users will have rights to the same databases.

Leave the local accounts intact for a little while, you can simply disable them rather thna delete them for now. When you are certain all database functionality is there, then delete the local IDs.



I hope you find this post helpful.

Regards,

Mark