March 11, 2009 at 9:21 am
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?
March 11, 2009 at 9:26 am
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“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 11, 2009 at 9:41 am
Mike Levan (3/11/2009)
select @servername it gives me REVDEV\REVDEV
Your "computername"/"instancename"
March 11, 2009 at 9:56 am
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
March 17, 2009 at 2:40 pm
What entry do you see in sys.servers for this server instance?
MJ
March 17, 2009 at 5:37 pm
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.
March 17, 2009 at 5:47 pm
Roust_m is correct. Named instances cannot be renamed.
detach dbs, uninstall, reinstall, attach dbs.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply