Rename default instance, 2000

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Mubeen Mohammed-203067 SSC Eights! Points: 877 More actions · Answer 1

If you have running only default instance on the Server you can use the below query

USE Master

GO

sp_dropserver current_server_name

GO

sp_addserver new_server_name, local

GO

And makesure that this is not cluster environment.

After doing these, you need to re-start the services then only the New Server Name comes into effect.

Thanks-Mubeen

Ivelisse Maldonado Old Hand Points: 372 More actions · Answer 2

Old Hand

Points: 372

September 23, 2006 at 6:38 pm

Thank you, for the information.