October 9, 2008 at 2:43 am
Microsoft provides 3 licensing models for us :
Processor License, Server plus Device CALs, Server plus User CALs
How can I know which licensing model is my server using ? any SQL statement can get this information ? Or go to the Control Panel ?
Please tell me if you know, thanks.
October 9, 2008 at 6:22 am
if you are looking to find out your SQL license then use Select @@Version, this will let you know what version of SQL you are using and also the Windows version and its bulid
🙂
October 9, 2008 at 9:37 am
Never had too much success with it but search BOL for "SERVERPROPERTY", there are loads of values that you can interrogate...
this shows the value you are after
SELECT CONVERT(CHAR(20),SERVERPROPERTY('licensetype'))
HTH
October 9, 2008 at 8:05 pm
Thanks.
But my SQL Server returns : 'Disabled'.
What does it mean ?
Do I need to correct it ?
How do I correct it ?
October 10, 2008 at 4:19 am
Are you running on the local machine or are you connected to a remote server, which SQL did you use mate @@version or the second one recommanded by allen 🙂
October 10, 2008 at 4:51 am
If you are running on SS2K5 you are going to get always "DISABLED" on your query. That's by design.
We keep track of licensing in an Excel document.
Additional info here... http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 10, 2008 at 5:01 am
Sounds like the media you (or the person at your Co., if its before your time...) used to install the server was on a Select license. check this out http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=295301
You may have to find the paper license...
Sorry
J
October 10, 2008 at 12:57 pm
I see DISABLED on our SQL 2008 server too (installed from SQL 2008 Standard ISO with Key pre-filled)
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
I will assume our licenses are CPU-based, not CAL
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply