Monday, March 26, 2012

Named instances..anything different than default ?

We have always used default instances of SQL Server and wanted to start
considering multiple named instances on one physical host. Anything to watch
out for other than just the name change which goes as
Hostname\NamedInstance1 ?
ThanksHassam
Each instance on the server consumes memory , just be aware.
"Hassan" <hassan@.hotmail.com> wrote in message
news:u1rPioitHHA.4688@.TK2MSFTNGP05.phx.gbl...
> We have always used default instances of SQL Server and wanted to start
> considering multiple named instances on one physical host. Anything to
> watch out for other than just the name change which goes as
> Hostname\NamedInstance1 ?
> Thanks
>|||Hello,
As well as each installed named instance require seperate SQL Server
licenses.
Thanks
Hari
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2sfZ8itHHA.1212@.TK2MSFTNGP05.phx.gbl...
> Hassam
> Each instance on the server consumes memory , just be aware.
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:u1rPioitHHA.4688@.TK2MSFTNGP05.phx.gbl...
>> We have always used default instances of SQL Server and wanted to start
>> considering multiple named instances on one physical host. Anything to
>> watch out for other than just the name change which goes as
>> Hostname\NamedInstance1 ?
>> Thanks
>|||> As well as each installed named instance require seperate SQL Server
> licenses.
I believe licensing varies by both SQL Server version and edition. Separate
licenses are needed in some cases but not others.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uS1F4hjtHHA.4572@.TK2MSFTNGP02.phx.gbl...
> Hello,
> As well as each installed named instance require seperate SQL Server
> licenses.
> Thanks
> Hari
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:u2sfZ8itHHA.1212@.TK2MSFTNGP05.phx.gbl...
>> Hassam
>> Each instance on the server consumes memory , just be aware.
>> "Hassan" <hassan@.hotmail.com> wrote in message
>> news:u1rPioitHHA.4688@.TK2MSFTNGP05.phx.gbl...
>> We have always used default instances of SQL Server and wanted to start
>> considering multiple named instances on one physical host. Anything to
>> watch out for other than just the name change which goes as
>> Hostname\NamedInstance1 ?
>> Thanks
>>
>|||For SQL 2005 you don't need licenses for separate instances. You do
need one license for the machine though.
Dan Guzman wrote:
>> As well as each installed named instance require seperate SQL Server
>> licenses.
> I believe licensing varies by both SQL Server version and edition.
> Separate licenses are needed in some cases but not others.
>|||Is that true ? That would be cool.
"Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
news:O7EZ59ntHHA.1728@.TK2MSFTNGP06.phx.gbl...
> For SQL 2005 you don't need licenses for separate instances. You do need
> one license for the machine though.
>
> Dan Guzman wrote:
>> As well as each installed named instance require seperate SQL Server
>> licenses.
>> I believe licensing varies by both SQL Server version and edition.
>> Separate licenses are needed in some cases but not others.|||Check the readme and licensing info that comes with SQL 2005. I also
checked with our MS rep about it.
Hassan wrote:
> Is that true ? That would be cool.
> "Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
> news:O7EZ59ntHHA.1728@.TK2MSFTNGP06.phx.gbl...
>> For SQL 2005 you don't need licenses for separate instances. You do need
>> one license for the machine though.
>>
>> Dan Guzman wrote:
>> As well as each installed named instance require seperate SQL Server
>> licenses.
>> I believe licensing varies by both SQL Server version and edition.
>> Separate licenses are needed in some cases but not others.
>

No comments:

Post a Comment