SQL Server expert Adam Machanic highlights the differences to consider when weighing the move to SQL Server 2005 Enterprise and Standard Edtions. This topic provides steps for installing Microsoft SQL Server 2005 Enterprise Edition on the database servers. If you are using Microsoft SQL Server 2000 Enterprise. Sep 14, 2007 Use the following tables to determine which features are supported by the various editions of Microsoft SQL Server 2005. Or SQL Server Enterprise Edition. View full Microsoft SQL Server 2005 Enterprise Edition specs on CNET.

Rick Steves Paris Ebook more. 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: • 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. 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. 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. HKEY_LOCAL_MACHINE SOFTWARE Microsoft Microsoft SQL Server 90 MSSQLLicenseInfo MSSQL9.00' But i couldn't find the ' MSSQLLicenseInfo' in my registry. Microsoft Winfs Beta 1-winbeta [nextddl Info] there. So i guess my MS SQL Server is not licensed right? Best Regards Shijin Prasad, MCITP, MCTS, B-tech IT Manager Shijin Prasad.