Newbie Question. Please help.
I need to change the computer name on the sql server 2000.
What steps are involved after the computer name change.
Thanks a bunch.If you use a domain account that has restricted login ability, you will need to add that account to the new computername to be able to login in AD.
You will need to run sp_dropserver and sp_addserver (look in BOL for syntax)
If you created jobs while the PC was named the old name you will need to update the originating server name in sysjobs to your new PC name.
HTH
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment