[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Is Microsoft SQL Server 2008 R2 Evaluation a standard or enterprise version

Posted on 2011-10-14
Medium Priority
Last Modified: 2012-05-12
Can anyone tell if the evaluation is a SQL standard or enterprise?  Does it have 180 days trial period
Question by:tommym121
LVL 18

Accepted Solution

LesterClayton earned 1000 total points
ID: 36970841
Evaluation software from Microsoft generally has "the best" features built in - and it is true for SQL Server 2008 R2 Evaluation.  It is enterprise.  All features will work for 180 days (6 months) and then they will cease to work thereafter.

You can unfortunately not license the product to make it a purchased Standard or Enterprise version - you will need to install a new SQL Server and migrate the databases from the evaluation one.  Do not let it expire if you wish to do this.

Assisted Solution

ee_reach earned 1000 total points
ID: 36970904
According to the wikipedia article, the eval version has the features of the Enterprise edition.

However, I have also heard that it is possible to access a trial version even of the datacenter version (which is built on the enterprise edition).  

Also, various versions may be available via MSDN beyond what is available to the general public.  

If it is already installed, your best bet is to try one of the approaches described in this document in order to see exactly what is installed.   http://support.microsoft.com/kb/321185

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question