• Ms Sql Server 2005 Express Edition
• Microsoft Sql Server 2005 Express
• Ms Sql Server Editions Comparison

Hi, I'm working as an IT Manager. In our office, we are using MS SQL Server 2005 Enterprise Edition.

This was installed before i join our company. So i don't have any idea about the License. When i checked with our vendor they told we have purchased a MS SQL Server 2008 Enterprise License, i know with this license we could install MS SQL 2005 Enterprise. But I'm not sure whether the previous IT used this License. I need help from some expertise regarding this matter that how i can check this in my SQL Server. From one the forum from Google they asked me to do the following:.

Ms Sql Server 2005 Express Edition

SELECT SERVERPROPERTY('LicenseType'). SELECT SERVERPROPERTY('Edition') And my results are:. DISABLED. ENTERPRISE EDITION So let me know what does the above mean? If 'Disabled' means it's not licensed then is there any way to make to my SQL Server 2005 to make my SQL licensed by getting my license details from our vendor to get Product Key from Microsoft. Please help me.

Best Regards Shijin Prasad, MCITP, MCTS, B-tech IT Manager Shijin Prasad. Regarding licensing information, SELECT SERVERPROPERTY('LicenseType') always return DISABLED, I tried on one of our licensed installation of SQL server 2005 and received DISABLED too. Starting with SQL Server 2005, licensing information is not stored in registry during the setup neither you need to enter product key during the setup. Licensing is tracked merely tracked using a paper trail.or email you received when you purchase SQL server from microsoft store etc.but not with the product itself. More info refer to You may want to contact your local microsoft licensing office You canll 1-800-426-9400, Monday through Friday, 6:00 A.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from them. Worldwide customers can use the to find contact information in their locations.

13 related questions.

Microsoft Sql Server 2005 Express

Regarding licensing information, SELECT SERVERPROPERTY('LicenseType') always return DISABLED, I tried on one of our licensed installation of SQL server 2005 and received DISABLED too. Starting with SQL Server 2005, licensing information is not stored in registry during the setup neither you need to enter product key during the setup. Licensing is tracked merely tracked using a paper trail.or email you received when you purchase SQL server from microsoft store etc.but not with the product itself. More info refer to You may want to contact your local microsoft licensing office You canll 1-800-426-9400, Monday through Friday, 6:00 A.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from them. Worldwide customers can use the to find contact information in their locations. Dear Chirag, As per your mail, i checked this link ' ' as follows: 'SQL 2005 still queries the registry for licensing information, add the following key and values and ServerProperty(‘LicenseType’) will return license information.

Ms Sql Server Editions Comparison

Note: Licensing has always been server wide and not SQL instance specific. This setting would apply to all instances of SQL Server on the server. HKEYLOCALMACHINE SOFTWARE Microsoft Microsoft SQL Server 90 MSSQLLicenseInfo MSSQL9.00' But i couldn't find the ' MSSQLLicenseInfo' in my registry. So i guess my MS SQL Server is not licensed right? Best Regards Shijin Prasad, MCITP, MCTS, B-tech IT Manager Shijin Prasad. SQL Server does not add this key anymore. You can add it yourself if you'd like.

I ran a similar test on a SQL Server 2012 box by adding the following key: HKEYLOCALMACHINE SOFTWARE Microsoft Microsoft SQL Server 110 MSSQLLicenseInfo MSSQL11.0 with Mode, DWord, 2 and ConcurrentLimit, DWord, 4 I then restarted the SQL Server service and ran the query: SELECT ServerProperty ( 'LicenseType' ) as LicenseType, ServerProperty ( 'NumLicenses' ) as ProcessorCount returns: Server Name LicenseType ProcessorCount InstanceName PERPROCESSOR 4 Chris.

Published: November 7, 2005 The following system requirements cover SQL Server 2005 Enterprise Edition on 32-bit and x64 platforms, as well as Itanium-based systems. Enterprise Edition System Requirements 32-bit x64 Itanium Processor 600-megahertz (MHz) Pentium III-compatible or faster processor; 1-gigahertz (GHz) or faster processor recommended 1-GHz AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support processor or faster 1-GHz Itanium or faster processor Operating System Microsoft Windows 2000 Server with Service Pack (SP) 4 or later; Windows Server 2003 Standard Edition, Enterprise Edition, or Datacenter Edition with SP 1 or later.