Re: Licensing

From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
Date: Thu, 31 Aug 2006 07:10:22 -0500

Hi,

Are you using developer edition. Then the licence type shuld be disabled.

Run the below command and see:-

SELECT SERVERPROPERTY ('LicenseType'), SERVERPROPERTY ('NumLicenses'),
SERVERPROPERTY ('Edition')

Thanks
Hari
SQL Server MVP

"leffe" <learv@xxxxxxxxxx> wrote in message
news:ewCN8WMzGHA.4576@xxxxxxxxxxxxxxxxxxxxxxx

Hi what does it mean when "licensingtype = disabled" and how does it occur

References:
- Licensing
  - From: leffe

Prev by Date: Re: SQL Server 2005 IIS Reports folder not installed on Win XP Pro
Next by Date: SQL Server 2005 Cluster Install
Previous by thread: Licensing
Next by thread: SQL Server 2005 Cluster Install
Index(es):
- Date
- Thread

Relevant Pages

Re: MS Desktop Engine 2000
... On your command line what exactly did you have for instancename? ... > SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY, ... >> unpatched MSDE install. ... I can't able to apply any patch for MS Desktop engine ...
(microsoft.public.sqlserver.security)
Re: SQL Server 20005 Licensing
... CAST(SERVERPROPERTY('productversion') AS varchar) AS productversion, ... CAST(SERVERPROPERTY ('productlevel') AS varchar) AS productlevel, ... Upgrading and Uninstalling the Trial Software ... The 180-day trial version of SQL Server 2005 Enterprise Edition can be ...
(microsoft.public.sqlserver.setup)
Re: SQL 2005 SP
... I don't have a case-sensitive server handy to test this on, but perhaps the property names are case-sensitive in a case-sensitive instance. ... You might try specifying the proper case names documented in the Books Online: ... SERVERPROPERTY, ... How to chekc which SP I've installed on my SQL Server 2005..? ...
(microsoft.public.sqlserver.security)
Re: SQL 2005 SP
... Are you getting NULLs? ... SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY as ... How to chekc which SP I've installed on my SQL Server 2005..? ... Tried the following query: ...
(microsoft.public.sqlserver.security)