New Instance

I'd like to install a named instance of SQL server, if this is just for
testing in the dev lab do I still need to have a license for it?
In the prod version I have one instance with several databases can I give
another DBA rights to view and admin only one database of that list. How do
I restrict the other DBA from viewing other databases?
ThanksHi
This seems to be something I am never 100% sure about, so it would be better
to clarify it with you software provider. I think the answer depends on how
you have licenced your current copy and what version it is:
For Server + User Cal licencing
http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. Installation-Server Software. You may install and use one copy of the
Server Software on a single Server. SQL Server Enterprise Edition. If
you have acquired the Enterprise Edition of the Server Software, you may
install any number of instances of the Server Software on
that Server. An "instance" shall mean a running copy of the Server Software.
Client Software. You may install the Client Software (SQL
Server Personal Edition) on any internal Device.
Server + Device cals seems to be similar to User Cal
http://www.microsoft.com/sql/howtobuy/servercal.asp
For processor licencing http://www.microsoft.com/sql/howtobuy/processor.asp:
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. License Structure. The Server Software is licensed on an individual
processor basis. You need one Server Software license for each of
your Server's processors. As an exception to that rule, if you have made a
processor inaccessible to all operating system copies on
which the Server Software is set up to run, you do not need a Server
Software license for that processor. Examples of processors that
you have made inaccessible to operating system copies are processors that
you have isolated by partitioning or other similar method.
You do not need more than one Server Software license for any processor.
b. Server Software. You may install and run any number of copies of the
Server Software on a single Server. You may use the
Management Tools, Books-Online, and Development Tools components of
Microsoft SQL Server (collectively "Tools") solely for
internal use in conjunction with your Server Software.
This would imply you can have multiple instances.
HTH
John
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> I'd like to install a named instance of SQL server, if this is just for
> testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I give
> another DBA rights to view and admin only one database of that list. How
> do
> I restrict the other DBA from viewing other databases?
> Thanks|||Niles wrote:
> I'd like to install a named instance of SQL server, if this is just
> for testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I
> give another DBA rights to view and admin only one database of that
> list. How do I restrict the other DBA from viewing other databases?
> Thanks
They can still "see" the other database names, but you can assign them
access to only the database they are supposed to maintain.
--
David Gugick
Imceda Software
www.imceda.com|||Per Server Licensing, you need additional Server License.
Per CPU, no additional licensing is required as long as you are properly
licenses for each CPU in the machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ONsggru4EHA.1300@.TK2MSFTNGP14.phx.gbl...
> Hi
> This seems to be something I am never 100% sure about, so it would be
better
> to clarify it with you software provider. I think the answer depends on
how
> you have licenced your current copy and what version it is:
> For Server + User Cal licencing
> http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. Installation-Server Software. You may install and use one copy of the
> Server Software on a single Server. SQL Server Enterprise Edition. If
> you have acquired the Enterprise Edition of the Server Software, you may
> install any number of instances of the Server Software on
> that Server. An "instance" shall mean a running copy of the Server
Software.
> Client Software. You may install the Client Software (SQL
> Server Personal Edition) on any internal Device.
> Server + Device cals seems to be similar to User Cal
> http://www.microsoft.com/sql/howtobuy/servercal.asp
> For processor licencing
http://www.microsoft.com/sql/howtobuy/processor.asp:
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. License Structure. The Server Software is licensed on an individual
> processor basis. You need one Server Software license for each of
> your Server's processors. As an exception to that rule, if you have made a
> processor inaccessible to all operating system copies on
> which the Server Software is set up to run, you do not need a Server
> Software license for that processor. Examples of processors that
> you have made inaccessible to operating system copies are processors that
> you have isolated by partitioning or other similar method.
> You do not need more than one Server Software license for any processor.
> b. Server Software. You may install and run any number of copies of the
> Server Software on a single Server. You may use the
> Management Tools, Books-Online, and Development Tools components of
> Microsoft SQL Server (collectively "Tools") solely for
> internal use in conjunction with your Server Software.
> This would imply you can have multiple instances.
> HTH
> John
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> > I'd like to install a named instance of SQL server, if this is just for
> > testing in the dev lab do I still need to have a license for it?
> >
> > In the prod version I have one instance with several databases can I
give
> > another DBA rights to view and admin only one database of that list.
How
> > do
> > I restrict the other DBA from viewing other databases?
> >
> > Thanks
>|||I haven't tested this yet but If I put a database under a named instance can
I then give them access to that instance only?
Thanks
"David Gugick" wrote:
> Niles wrote:
> > I'd like to install a named instance of SQL server, if this is just
> > for testing in the dev lab do I still need to have a license for it?
> >
> > In the prod version I have one instance with several databases can I
> > give another DBA rights to view and admin only one database of that
> > list. How do I restrict the other DBA from viewing other databases?
> >
> > Thanks
> They can still "see" the other database names, but you can assign them
> access to only the database they are supposed to maintain.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>