sql server new users: Hello all,

Our small business is going to need SQL Server for a couple more people and we do want to try to be ligitimate, so I have a few
questions about licensing.

We have SQL Server 2000 Standard w/ 5 CAL's.

Does this mean we can install Server and Client Tools on 1 server and Client Tools Only on 5 clients? Can I install Client Tools
Only on an infinite number of clients, but only have 5 users connected at a time?

If I need to install on a laptop that will be traveling/disconnected, I'm assuming that I will need to install Server and Client
Tools on the laptop, in which case we will need to purchase another copy of SQL Server Standard or Personal (w/o CAL's), correct?

How do I check which Licensing Mode (Per Seat/Per Processor) our installation is set to? Can the Licensing Mode be changed after
installation?

Thanks for any help anyone can provide,

Conan Kelly

Hi, first of all please do NOT multipost in all groups of SQL Server.


Does this mean we can install Server and Client Tools on 1 server and
Client Tools Only on 5 clients? Can I install Client Tools
Only on an infinite number of clients, but only have 5 users connected
at a time?

No this is just a legal issue. If you are using and have entered 5
licences in the license manager, you can use 5 clients legally. if you
are using more than 5 you will get an error message in the event log
stating that you reached your capacity of licences, but SQL Server will
work.



If I need to install on a laptop that will be traveling/disconnected,
I'm assuming that I will need to install Server and Client
Tools on the laptop, in which case we will need to purchase another
copy of SQL Server Standard or Personal (w/o CAL's), correct?

Only if you want to have the "full" featured product. if you just want
to store and manipulate the data, you can use the free MSDE database.
If you want to use the "server" version of SQL Server you have to buy
another server licence to install it.


How do I check which Licensing Mode (Per Seat/Per Processor) our
installation is set to? Can the Licensing Mode be changed after
installation?

The licensing mode can be viewed via:


SELECT SERVERPROPERTY('LicenseType') AS [LicenseType]
SELECT SERVERPROPERTY('NumLicenses') AS [NumLicenses]



The only supported way to change it, is to uninstall and reinstall:

http://www.google.com/url?sa=3DD&q=3Dhttp://groups.google.de/group/microsof=
t=2Epublic.sqlserver.setup/browse_frm/thread/338e4a18bb0fae5/e43d2478c92ece=
13%3Fq%3D%2522change%2Blicensing%2522%2B%2522sqlserver%2522%26rnum%3D2%26hl=
%3Dde%23e43d2478c92ece13


There is a undocumented way of changing it, but unless this isn=B4t
supported
this shouldn=B4t be your first choice:


http://www.google.com/url?sa=3DD&q=3Dhttp://www.google.com/url%3Fsa%3DD%26q=
%3Dhttp://www.tkdinesh.com/faq/ans/license.html


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Please do NOT multipost, asnwered in newusers.

Hi, first of all please do NOT multipost in all groups of SQL Server.


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Please do NOT multipost, asnwered in newusers.

Hi, first of all please do NOT multipost in all groups of SQL Server.


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

[quoted text, click to view]


I'm not trying to be rude, but I'm curious why it is such a no-no to multipost.

I multipost like that so I will have a better chance of getting my questions answered. Not everyone can monitor all groups all the
time.

Just my thoughts on the matter.

Sorry for the trouble.

[quoted text, click to view]

Client Access Licences are either per user or per device, not per
connection. You need to licence each user or device regardless of how many
will connect simultaneously to your server.

Use:
SELECT SERVERPROPERTY('LicenseType')
to check the licensing mode. Officially the licensing mode can only be set
at installation although there is an unofficial hack to do it after install.

For all licensing questions, please consult a Microsoft representative or
your software vendor of see the following pages:
http://www.microsoft.com/sql/howtobuy/default.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--