Solved

rename SQL instance ?

Posted on 2014-01-28
6
388 Views
Last Modified: 2014-02-03
can you ( and how do you ) rename a SQL 2008 instance name ?
0
Comment
Question by:NAMEWITHELD12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 79

Accepted Solution

by:
arnold earned 375 total points
ID: 39816718
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
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39816741
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
 
LVL 79

Assisted Solution

by:arnold
arnold earned 375 total points
ID: 39816768
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39817425
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
 
LVL 79

Assisted Solution

by:arnold
arnold earned 375 total points
ID: 39817500
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
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 125 total points
ID: 39819429
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question