Multiple Instance SQL 2005

How do i conver a Single instance SQL Server 2005 to Multiple instance?TBoon wrote:
> How do i conver a Single instance SQL Server 2005 to Multiple instance?
>
>
You don't convert a single instance into multiple - you install a new
instance on the same machine, giving you the original instance and the
new instance (thus, you now have multiple instances running on that
machine).|||My SQL is currently installed on Default Instance, not Named Instance.
How do i convert to Named Instance?
"Jeffrey Williams" <jeff.williams3188@.verizon.net> wrote in message
news:OTj9W9G5HHA.748@.TK2MSFTNGP04.phx.gbl...
> TBoon wrote:
>> How do i conver a Single instance SQL Server 2005 to Multiple instance?
>>
> You don't convert a single instance into multiple - you install a new
> instance on the same machine, giving you the original instance and the new
> instance (thus, you now have multiple instances running on that machine).|||> How do i convert to Named Instance?
You can't. Again, you would have to install a named instance and then move the databases that you
want from the default to the newly installed named instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"TBoon" <allblacks15@.hotmail.com> wrote in message news:%23jbxelI5HHA.1204@.TK2MSFTNGP03.phx.gbl...
> My SQL is currently installed on Default Instance, not Named Instance.
> How do i convert to Named Instance?
> "Jeffrey Williams" <jeff.williams3188@.verizon.net> wrote in message
> news:OTj9W9G5HHA.748@.TK2MSFTNGP04.phx.gbl...
>> TBoon wrote:
>> How do i conver a Single instance SQL Server 2005 to Multiple instance?
>>
>> You don't convert a single instance into multiple - you install a new instance on the same
>> machine, giving you the original instance and the new instance (thus, you now have multiple
>> instances running on that machine).
>|||Only one default instance of SQL Server 2005 is allowed on a system. All
other instances need to be installed as named instances.
TBoon wrote:
> My SQL is currently installed on Default Instance, not Named Instance.
> How do i convert to Named Instance?
> "Jeffrey Williams" <jeff.williams3188@.verizon.net> wrote in message
> news:OTj9W9G5HHA.748@.TK2MSFTNGP04.phx.gbl...
>> TBoon wrote:
>> How do i conver a Single instance SQL Server 2005 to Multiple instance?
>>
>> You don't convert a single instance into multiple - you install a new
>> instance on the same machine, giving you the original instance and the new
>> instance (thus, you now have multiple instances running on that machine).
>