Groups | Blog | Home
all groups > sql server clients > november 2003 >

sql server clients : SQL Licensing


Brett Taft
11/26/2003 2:24:45 PM
I need help verifying how many access licenses I have on
my SQL server. Nothing shows up in the normal licesneing
area in windows 2000.
When I purchased the server it was with the understanding
that I bought a per processor licesense so that I would
deal with issue with access
licenses. I'm seeing an even in the event viewer that
makes me think that after 5 or so connections it is
kicking my clients out of the SQL Server

this is the error mesage I'm receiving
No license was available for user "domain\user" using
product SMBServer 5.0
the source is the licensing service
event id =201

Allan Mitchell
11/28/2003 8:21:41 AM
What are the results of

SELECT @@version ?
SELECT SERVERPROPERTY('LicenseType')
SELECT SERVERPROPERTY('NumLicenses')


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]

AddThis Social Bookmark Button