Is it possible through GUI or SQL Commands to reconfigure a Named 2005
Instance as the default instance?

In the current project i am on, i am upgrading a 2000 instance, so i
am installing 2005 next to it as a named instance, will test my apps
against the 2005 named instance, then when i am done, will uninstall
the 2000 instance and the 2005 named instance then reinstall 2005 as
the default instance. I was wondering if there is an easier way so
that I don't have to uninstall 2005 and can just reconfigure it as the
default instance.

Thanks in advance

I'm afraid not, reinstall would be the way to go. Is there a reason why you can't keep this as a
default instance?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


<awtesta@gmail.com> wrote in message news:1192638708.326392.72030@i38g2000prf.googlegro ups.com...
> Is it possible through GUI or SQL Commands to reconfigure a Named 2005
> Instance as the default instance?
>
> In the current project i am on, i am upgrading a 2000 instance, so i
> am installing 2005 next to it as a named instance, will test my apps
> against the 2005 named instance, then when i am done, will uninstall
> the 2000 instance and the 2005 named instance then reinstall 2005 as
> the default instance. I was wondering if there is an easier way so
> that I don't have to uninstall 2005 and can just reconfigure it as the
> default instance.
>
> Thanks in advance
>

.... I should have said:
Is there a reason why you can't keep this as a named instance?


--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote in message
news:28148598-6060-49F3-B401-D93591698C68@microsoft.com...
> I'm afraid not, reinstall would be the way to go. Is there a reason why you can't keep this as a
> default instance?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> <awtesta@gmail.com> wrote in message news:1192638708.326392.72030@i38g2000prf.googlegro ups.com...
>> Is it possible through GUI or SQL Commands to reconfigure a Named 2005
>> Instance as the default instance?
>>
>> In the current project i am on, i am upgrading a 2000 instance, so i
>> am installing 2005 next to it as a named instance, will test my apps
>> against the 2005 named instance, then when i am done, will uninstall
>> the 2000 instance and the 2005 named instance then reinstall 2005 as
>> the default instance. I was wondering if there is an easier way so
>> that I don't have to uninstall 2005 and can just reconfigure it as the
>> default instance.
>>
>> Thanks in advance
>>
>