Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rename Instance Expand / Collapse
Author
Message
Posted Wednesday, March 11, 2009 9:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, April 3, 2010 2:42 PM
Points: 1,023, Visits: 1,893
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?
Post #673374
Posted Wednesday, March 11, 2009 9:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:19 PM
Points: 2,107, Visits: 3,582
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. :)

Hope this helps.


David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #673381
Posted Wednesday, March 11, 2009 9:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
Mike Levan (3/11/2009)

select @servername it gives me REVDEV\REVDEV



Your "computername"/"instancename"


Post #673400
Posted Wednesday, March 11, 2009 9:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
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 ;)


Adam Zacks

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

Be Nice, Or Leave
Post #673419
Posted Tuesday, March 17, 2009 2:40 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
What entry do you see in sys.servers for this server instance?

MJ
Post #677893
Posted Tuesday, March 17, 2009 5:37 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, September 14, 2014 8:29 PM
Points: 989, Visits: 1,650
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.



Post #678015
Posted Tuesday, March 17, 2009 5:47 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:38 AM
Points: 33,267, Visits: 15,436
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
Post #678019
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse