SQL Server 2000 Cals

If someone could please help.

We have a server running Win 2000 Server with SQL 2000 Server.

1) How can I tell which of the 20 network users have SQL 2000 Cals

2) How can I tell wether a Win 2000 Server client has a Device or User Cal.

Thanks



Answer this question

SQL Server 2000 Cals

  • NagaB

    For Question 1:

    Actually, the Cals do not fix on SQL Server 2000 clients. each client computer or other device that used to connection to SQL Server 2000 should has a CAL

    For question 2:

    You can use sp_who2 to check, and get the result from hostname column.



  • SQL Server 2000 Cals