Date parsed: 22/10/2007 22:34:34
Date: Mon, 22 Oct 2007 20:34:34 +0200

2005 doesn't ask for licensing and there's no app to specify number of licenses. Licensing for 2005
is built on honesty.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Ekrem Önsoy" <ekrem@btegitim.com> wrote in message
news:4DA9D007-1934-4C87-B6C6-7C7906BDF899@microsoft.com...
> It might have been installed using an MSDN media. When you installed SQL Server using this media,
> license is not required.
>
> Frankly, I have not seen a version which needs a license.
>
> --
> Ekrem Önsoy
>
>
>
> "Morten Ross" <MortenRoss@discussions.microsoft.com> wrote in message
> news:03757703-915A-4042-8586-5E042DDD2238@microsoft.com...
>> Hi,
>>
>> Thanks for the script. However, on a standard installed MSSQL 2005, the
>> following is returned:
>>
>> Type of license: DISABLED
>> Number of Licenses: Not Defined
>>
>> How is this addressed?
>>
>> Regards
>> Morten Ross
>>
>> "Ekrem Önsoy" wrote:
>>
>>> Hello Morten,
>>>
>>> You can use the following script (by Sugesh<sugeshkr@gmail.com>):
>>> -------------------------------------------------
>>> declare @collation sql_variant
>>> declare @Edition sql_variant
>>> declare @InstanceName sql_variant
>>> declare @authmode sql_variant
>>> declare @lictype sql_variant
>>> declare @numlics sql_variant
>>> declare @pversion sql_variant
>>> declare @plevel sql_variant
>>> declare @Servername sql_variant
>>> DECLARE @sqlser varchar(20)
>>> DECLARE @agentser varchar(20)
>>> DECLARE @browser varchar(20)
>>>
>>> select @collation=serverproperty('Collation')
>>> select @Edition=serverproperty('Edition')
>>> select @InstanceName=isnull(serverproperty('InstanceName'),'Default')
>>> select @authmode=case serverproperty('IsIntegratedSecurityOnly')
>>> when 1 then 'Windows Mode'
>>> Else 'Mixed Mode' end
>>> select @lictype=serverproperty('LicenseType')
>>> select @numlics=isnull(serverproperty('NumLicenses'),'Not Defnied')
>>> select @pversion=serverproperty('ProductVersion')
>>> select @plevel=serverproperty('ProductLevel')
>>> select @Servername=serverproperty('ServerName')
>>>
>>> EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
>>> @key='SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
>>> @value_name='objectname',
>>> @value=@sqlser OUTPUT
>>>
>>> EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
>>> @key='SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT',
>>> @value_name='objectname',
>>> @value=@agentser OUTPUT
>>>
>>> EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
>>> @key='SYSTEM\CurrentControlSet\Services\SQLBrowser',
>>> @value_name='objectname',
>>> @value=@browser OUTPUT
>>>
>>> PRINT 'Name of Server
>>> :'+convert(varchar(30),@Servername)
>>> PRINT 'Name of Server Collation :'+convert(varchar(30),@collation)
>>> PRINT 'Name of Server Editiom :'+convert(varchar(30),@Edition)
>>> PRINT 'Name of Server Instance
>>> :'+convert(varchar(30),@InstanceName)
>>> PRINT 'Authentication Mode :'+convert(varchar(30),@authmode)
>>> PRINT 'Type of License :'+convert(varchar(30),@lictype)
>>> PRINT 'Number of Licenses :'+convert(varchar(30),@numlics)
>>> PRINT 'Product Version :'+convert(varchar(30),@pversion)
>>> PRINT 'Product Level :'+convert(varchar(30),@plevel)
>>> PRINT 'Account Starting SQL Server Service:'+convert(varchar(30),@sqlser)
>>> PRINT 'Account Starting SQL Server Service:'+convert(varchar(30),@agentser)
>>> PRINT 'Account Starting SQL Server Service:'+convert(varchar(30),@browser)
>>>
>>> -----------------------------------------------------------
>>>
>>> --
>>> Ekrem Önsoy
>>>
>>>
>>>
>>> "Morten Ross" <MortenRoss@discussions.microsoft.com> wrote in message
>>> news:E76F18F0-6882-4DFB-8D8F-C5C473C13E72@microsoft.com...
>>> > Hi,
>>> >
>>> > Tracking license in MSSQL 2005 has become very difficult. How do we find
>>> > the
>>> > licence mode and amount of processors licensed?
>>> >
>>> > Regards
>>> > Morten Ross
>>>
>