Solved

SQL -  Change SQLServer Instance name

Posted on 2006-10-19
5
360 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to join on ID, with prefix? 15 69
SQL replication over high latency link 10 67
Merging spreadsheets 8 65
simple bash script needed to unpack tar.gz 4 24
This article describes some very basic things about SQL Server filegroups.
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
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…

679 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