Wednesday, March 7, 2012

Is is possible to change the "name" of an instance

theHi,
Have a named instance of SQL Server, but have discovered that the application for which the SQL Server was installed will not work with a named instance. So, is there a way to change the instance to become a default one, or will it require a full instance
to create the default instance ?
Thanks
Best bet is to install a default instance, then detach your databases on the
named instance and attach them to the default instance.
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BD6F0DF8-457F-47D6-B39D-F75420357363@.microsoft.com...
> theHi,
> Have a named instance of SQL Server, but have discovered that the
> application for which the SQL Server was installed will not work with a
> named instance. So, is there a way to change the instance to become a
> default one, or will it require a full instance to create the default
> instance ?
> Thanks
|||Thanks for that Richard. Pretty much what I figured.
We are actually using an alias to get round the problem, as only a couple of machines need to attach directly to the database.
"Richard Waymire [MSFT]" wrote:

> Best bet is to install a default instance, then detach your databases on the
> named instance and attach them to the default instance.
> --
> Richard Waymire, MCSE, MCDBA
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Al" <Al@.discussions.microsoft.com> wrote in message
> news:BD6F0DF8-457F-47D6-B39D-F75420357363@.microsoft.com...
>
>

No comments:

Post a Comment