activate standard sql server from evaluation

Mr.X
Mr.X used Ask the Experts™
on
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 ? ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David ToddSenior Database Administrator

Commented:
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

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
>> 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.

Author

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 ?
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> 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

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Try changing Line#6 to
dbname       VARCHAR(100),

Open in new window

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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..

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
>> Probably I will look for the standard installation media and will to upgrade from there

Using Standard Installation media should definitely help out..

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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.

Author

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)

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Just execute
SELECT @@VERSION

Open in new window

and if it returns Standard, that means no Expiry date..

Author

Commented:
version.PNG
it just returned with server 2012- 11.0.2100.60
is this the standard version number ? ?

Author

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 Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial