activate standard sql server from evaluation

Hi guys,
Got a sql server2012 running enterprise evaluation edition.  It’s a free version.
I got license for standard version of 2012 sql

hi i tried to activate through the sql server management studio. entered key and got this error below in pic.. can i ignore that error and go ahead ?
IMG_5639.jpg
or do i need to uninstall enterprise evaluation version.  and install standard version from scratch ? ?
Mr.XAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior Database AdministratorCommented:
Hi,

Evaluation Edition is effectively Enterprise Edition. I don't believe that you can do an Edition Upgrade (downgrade actually) from Eval to Standard, so that suggests you need a clean install. You could install Standard as a named instance alongside Eval if that helps you migrate the configuration.

HTH
  David
Mr.XAuthor Commented:
Hi,
I just got the serial number of standard sql server

From where I can download the sql server standard version. any links ???
And what are the steps I should do before uninstalling the evaluation n installing the standard version n adding the same instance  to it. ?
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Few things to clarify..
1. Snapshot posted above is just a warning and not an error message, so the installer will still allow you to proceed further.
2. When we want to convert Evaluation to Standard edition, we need to use Standard Edition installer and do the steps whatever you have did now. Ideally you should get the Standard Edition download link via VLSC or from your vendor as a DVD when you purchase the Standard edition license.
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> I don't believe that you can do an Edition Upgrade (downgrade actually) from Eval to Standar

David, its actually wrong.. You can upgrade from Evaluation to Standard edition without any issues provided Enterprise edition features aren't used in the Evaluation edition databases.
Mr.XAuthor Commented:
Hi raja,
First I have enterprise evaluation. Is this higher than standard or lower than standard ?
And how do I find whether the evaluation not using any enterprise features ?
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> First I have enterprise evaluation. Is this higher than standard or lower than standard ?

To clarify, Evaluation is an edition which has all Enterprise edition features available but Evaluation is lesser than Enterprise in the upgrade path..
So, you can upgrade from Evaluation to Standard or Enterprise editions and I've did it several times without any issues.

>> And how do I find whether the evaluation not using any enterprise features ?

You can use the sys.dm_db_persisted_sku_features dmv as mentioned in the below link to find out whether you are using any of the Enterprise edition features across any databases.
https://gbyte.co/blog/finding-databases-use-Enterprise-features-sql-server

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mr.XAuthor Commented:
hi raja,
I created a new query. copied the coding to it.when I execute there are few syntax errors coming .

if my database name is "a1_b1"  .   what are the places I need to modify the coding below ?

IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL

2.  DROP TABLE ##enterprise_features

3.

4.CREATE TABLE ##enterprise_features

5.  (

6.     dbname       SYSNAME,

7.     feature_name VARCHAR(100),

8.     feature_id   INT

9.  )

10.

11.EXEC sp_msforeachdb

12.N' USE [?]

13.IF (SELECT COUNT(*) FROM sys.dm_db_persisted_sku_features) >0

14.BEGIN

15.   INSERT INTO ##enterprise_features

16.    SELECT dbname=DB_NAME(),feature_name,feature_id

17.    FROM sys.dm_db_persisted_sku_features

18.END '

19.SELECT *

20.FROM   ##enterprise_features
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Try changing Line#6 to
dbname       VARCHAR(100),

Open in new window

Mr.XAuthor Commented:
hi, I tried changing line 6.
still few error.
plz have a look at the image.
sql.PNG
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Got it.. error is that you have copied with line numbers..
posting the script from the above link without numbers here which should work fine..
IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL
DROP TABLE ##enterprise_features
     
CREATE TABLE ##enterprise_features
(
    dbname       SYSNAME,
    feature_name VARCHAR(100),
    feature_id   INT
)
     
EXEC sp_msforeachdb
N' USE [?] 
IF (SELECT COUNT(*) FROM sys.dm_db_persisted_sku_features) >0 
BEGIN 
INSERT INTO ##enterprise_features 
SELECT dbname=DB_NAME(),feature_name,feature_id 
FROM sys.dm_db_persisted_sku_features 
END '
SELECT *
FROM   ##enterprise_features 

Open in new window

Mr.XAuthor Commented:
hi,
thanks for it.
i ran it without numbers. it came as ""o"" rows affected in the message field. the result shows nothing.
 does it mean none of the database uses features from enterprise. ?
so can i ignore the warning message and go ahead in the original question ? ?
please have a look at the both the image below
sql-result.PNGsql.PNG
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes, that's correct..
you don't have any enterprise edition features and hence you can upgrade from Evaluation to Standard edition after ignoring the error provided that you are using Standard edition installer..
Mr.XAuthor Commented:
Hm ok. Originally I just used the sql server installation centre from the evaluation version to do the edition upgrade, that's where I got the warning message - which is in my original question.

Probably I will look for the standard installation media and will to upgrade from there and will let you know how it goes.  Thanks for your effort.
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Probably I will look for the standard installation media and will to upgrade from there

Using Standard Installation media should definitely help out..
Mr.XAuthor Commented:
hi, i cant find any place to download standard version of 2012sql iso file. any sites or links you know to download ??
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
May I know where you have purchased the Standard License keys, once you purchase SQL Server 2012 Standard License keys, you should have either received a VLSC account with link to download SQL Server 2012 Standard edition ISO or a physical media containing the installer..
Usually, the license keys would be embedded inside the installer and hence you need to get the installer from the vendor you have purchased your license keys.
Mr.XAuthor Commented:
hi raja, sorry about the delay.
i got the sql standard version. and its updated. all looks good.

how do i verify, its in standard edition and its using the license key i entered and wont expire like the evalulation edition(180days free)
Mr.XAuthor Commented:
is there any command to find the expiration of the sql server. just to make sure the key is validated and wont expire ?
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Just execute
SELECT @@VERSION

Open in new window

and if it returns Standard, that means no Expiry date..
Mr.XAuthor Commented:
version.PNG
it just returned with server 2012- 11.0.2100.60
is this the standard version number ? ?
Mr.XAuthor Commented:
ok. thank you raja.
with this command i confirmed its running standard version.

thanks for your help.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),

SERVERPROPERTY ('edition')
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
If you expand the result set received from the query I shared, it would have all the 3 information you have received in the query you have shared above..
Anyhow, glad you found it out..
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.