SQL - Change SQLServer Instance name

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 ?
OR
transfert SERVLW01\SERVLW02 to SERVLW01 and delete SERVLW01\SERVLW02 ?

SilvertreAsked:
Who is Participating?
 
nmcdermaidConnect With a Mentor Commented:
... you may have to use a different tool to redirect SERVLW01\SERVLW02 to port 1433 if it is SQL2005, try the surface area manager.
0
 
MNelson831Commented:
I don't think the instance name can be changed without uninstalling/reinstaliing.  Have a look here:

http://www.dbforums.com/archive/index.php/t-628708.html
0
 
SilvertreAuthor Commented:
I also installed sql2005, how can I define whitch one is set to  (Local)?
0
 
nmcdermaidCommented:
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.

 
0
 
SilvertreAuthor Commented:
Good ideal but :(
0
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.

All Courses

From novice to tech pro — start learning today.