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=D&q=http://groups.google.de/group/microsoft.public.sqlserver.setup/browse_frm/thread/338e4a18bb0fae5/e43d2478c92ece13%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´t
supported
this shouldn´t be your first choice:


http://www.google.com/url?sa=D&q=http://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
---

Show quote Hide quote 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

SQL 2000 on W2k fragmentation
TSQL help to delete
Performance: Primary Key = int/nvarchar/guid/...
Working with a SAN for 2-4 TB database
waittype=WRITELOG
How do I get my local data in the database on the Internet?
Switching off logging on varbinary column
Multiple jobs on one schedule
annoying SQL Server error message
finding out the last login