Solved

SQL -  Change SQLServer Instance name

Posted on 2006-10-19
5
359 Views
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 ?
OR
transfert SERVLW01\SERVLW02 to SERVLW01 and delete SERVLW01\SERVLW02 ?

0
Comment
Question by:Silvertre
  • 2
  • 2
5 Comments
 
LVL 15

Expert Comment

by:MNelson831
ID: 17769485
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
 

Author Comment

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

Expert Comment

by:nmcdermaid
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.

 
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 250 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.
0
 

Author Comment

by:Silvertre
ID: 17773866
Good ideal but :(
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

856 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