set named instance to default - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

set named instance to default

Author

Topic

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-02-25 : 06:19:26

Is it possible to change a named instance to the default instance?

I googled and one site said this would work:
sp_dropserver nameofinstance
sp_addserver machinename,'local'

But other sites said it would not.
Anyone know for sure?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-25 : 06:43:23

According to Books Online, those two procedure are for adding and removing linked and remote servers, not the local server.

E 12°55'05.63"
N 56°04'39.26"

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-02-25 : 07:01:28

quote:
Originally posted by darkdusky

Is it possible to change a named instance to the default instance?

I googled and one site said this would work:
sp_dropserver nameofinstance
sp_addserver machinename,'local'

But other sites said it would not.
Anyone know for sure?

It is not possible to change the named instance to default ....
You have to reinstall...

Regards,
Ahmad Osama

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-25 : 07:40:22

quote:
Originally posted by darkdusky

Is it possible to change a named instance to the default instance?

I googled and one site said this would work:
sp_dropserver nameofinstance
sp_addserver machinename,'local'

But other sites said it would not.
Anyone know for sure?

Those stored proc are needed when Server name is changed and needs to reflect the name in SQL Server.

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-02-25 : 11:01:15

Or we'll re-install - I found one site which showed a combination of:
sp_dropserver nameofinstance
sp_addserver machinename,'local'

and some registry hacks.

But I'll use safer method

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-02-25 : 14:02:24

quote:
Originally posted by darkdusky

Or we'll re-install - I found one site which showed a combination of:
sp_dropserver nameofinstance
sp_addserver machinename,'local'

and some registry hacks.

But I'll use safer method

can u post the url for the website....I wud like to try this out

Regards,
Ahmad Osama

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-02-26 : 07:57:25

Not sure if this is just to change rename instance or also to make default:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/544c4eaf43ddfaf3/e9065e05718e984e

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources