Rename named instance to default instance?

Is it possible to change a named instance of Sql Server 2005 to the default
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
--
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall