SQL -  Change SQLServer Instance name

Posted on 2006-10-19
Medium Priority
Last Modified: 2008-02-01
How can we manage instance.

I also installed sql2005, how can I define whitch one is set to  (Local)?

I have two SQLServer 2000 instances :SERVLW01 (server name) and SERVLW01\SERVLW02 (second instance)
Can I delete/disable SERVLW01 and replace it by SERVLW01\SERVLW02 ?
transfert SERVLW01\SERVLW02 to SERVLW01 and delete SERVLW01\SERVLW02 ?

Question by:Silvertre
  • 2
  • 2
LVL 15

Expert Comment

ID: 17769485
I don't think the instance name can be changed without uninstalling/reinstaliing.  Have a look here:


Author Comment

ID: 17769515
I also installed sql2005, how can I define whitch one is set to  (Local)?
LVL 30

Expert Comment

ID: 17770884
Try this:

1. In the service manager or using the service applet, stop the service for SERVLW01
2. Go to server network utility, select SERVLW01\SERVLW02 and tell it to use port 1433 (you may need to point SERVLW01 at a different port first)
3. Cross your fingers and try connecting to SERVLW01
4. See if it connects.

LVL 30

Accepted Solution

nmcdermaid earned 750 total points
ID: 17770889
... you may have to use a different tool to redirect SERVLW01\SERVLW02 to port 1433 if it is SQL2005, try the surface area manager.

Author Comment

ID: 17773866
Good ideal but :(

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

607 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