SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Rename Instance


Rename Instance

Author
Message
Mike Levan
Mike Levan
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7511 Visits: 1893
recently i installed sql server 2005 enterprise on my machine and in the wizard when asked for instance name i gave " REVDEV" but after completion if installtion i see that it was named as " REVDEV\REVDEV".

Now how do i rename it to REVDEV.

I used sp_dropserver and sp_addserver it did work, when query
select @servername it gives me REVDEV\REVDEV

sp_helpserver gives REVDEV

When i try connecting to REVDEV it will not but if i connect using REVDEV\REVDEV it conenctd good.

where am i doing wrong?
David Benoit
David Benoit
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18786 Visits: 3650
Mike,

You appear to have installed this as a named instance. I believe you will have to uninstall / reinstall in order to get the default named instance that you are looking for.

Typically when you install if you want the instance to be the same name as the server / computer that it runs on you would not provide a name and it will be the default name of the instance.

I will say though that having the named instance really won't affect anything except that you have to type a few extra characters to connect, etc. Smile

Hope this helps.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
maechismo_8514
maechismo_8514
SSCrazy Eights
SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)

Group: General Forum Members
Points: 9798 Visits: 2228
Mike Levan (3/11/2009)

select @servername it gives me REVDEV\REVDEV



Your "computername"/"instancename"
Schadenfreude-Mei
Schadenfreude-Mei
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7697 Visits: 1336
Mike Levan (3/11/2009)
recently i installed sql server 2005 enterprise on my machine and in the wizard when asked for instance name i gave " REVDEV" but after completion if installtion i see that it was named as " REVDEV\REVDEV".

Now how do i rename it to REVDEV.

I used sp_dropserver and sp_addserver it did work, when query
select @servername it gives me REVDEV\REVDEV

sp_helpserver gives REVDEV

When i try connecting to REVDEV it will not but if i connect using REVDEV\REVDEV it conenctd good.

where am i doing wrong?


Let me guess... Your local machines is called 'REVDEV'?

You installed a named instance rather then leaving it to install default instance.

Not much you can do but install a new one and migrate.

Silly billy Wink

Adam Zacks

-------------------------------------------

Be Nice, Or Leave
MANU-J.
MANU-J.
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17614 Visits: 8766
What entry do you see in sys.servers for this server instance?

MJ
Roust_m
Roust_m
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8368 Visits: 1990
You can not rename a named instance. If you rename your computer, then you can change the first part of the name to match the new name of the computer.
E.g.: your current computer name is REVDEV, you instance name is REVDEV\REVDEV

you change you computer name to REVTEST, you can now use sp_dropserver/sp_addserver to change your instance name to REVTEST\REVDEV

In your situation reinstall and reattach the databases is the way to go.



Steve Jones
Steve Jones
SSC Guru
SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)

Group: Administrators
Points: 329054 Visits: 20109
Roust_m is correct. Named instances cannot be renamed.

detach dbs, uninstall, reinstall, attach dbs.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search