[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

rename SQL instance ?

can you ( and how do you ) rename a SQL 2008 instance name ?
0
NAMEWITHELD12
Asked:
NAMEWITHELD12
  • 3
  • 2
4 Solutions
 
arnoldCommented:
Sp_dropserver current_servername
Sp_addserver newservername

This deals with a name change of the sever following a name change.

Instance changes, you mean you want to change server\instance1 to server\instance2?
0
 
NAMEWITHELD12Author Commented:
yeah , is there any way to do it in the GUI, I am trying to walk someone thru it over the phone

it will not effect any DBs ?

thanks!
0
 
arnoldCommented:
No, it is a TSQL. A non destructive process only taking effect after the sql service restarts.

Is this a clustered instance?

If I might, what is the reason for the change?
What is the expectation after the change?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
NAMEWITHELD12Author Commented:
the reason is that I made a mistake on the naming of the instance ,


not clustered

I expect the DBs on the instance not to be affected in any way

thanks
0
 
arnoldCommented:
The example changes the name of the server, do not think you can change the second component.

Your best bet is to rerun the installer and add a new instance, then backup/restore the DBs

You have server\instanse and now you want to correct server\instance

This type of change can be done but is risky, deals with going through the registry .......
0
 
David ToddSenior DBACommented:
Hi,

If a new install then I suggest an uninstall/reinstall.

That way you wont be left wondering down the track if your registry hack has missed something.

I strongly recommend that you test any suggestions before applying to production. If you correction goes wrong you could be left with a horrible mess.

HTH
  David
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now