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


Rename Instance


Rename Instance

Author
Message
Mike Levan
Mike Levan
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3315 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
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7802 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
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

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

select @servername it gives me REVDEV\REVDEV



Your "computername"/"instancename"
Schadenfreude-Mei
Schadenfreude-Mei
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3611 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.
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

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

MJ
Roust_m
Roust_m
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3526 Visits: 1981
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 (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: Administrators
Points: 143394 Visits: 19424
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