SQL -  Change SQLServer Instance name

Silvertre
Silvertre used Ask the Experts™
on
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 ?

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

Commented:
I also installed sql2005, how can I define whitch one is set to  (Local)?
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.

 
... 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

Commented:
Good ideal but :(

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial