• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1136
  • Last Modified:

SQL 2008 R2 Edition Upgrade didn't work

Hi
I had the RTM version, and decided to upgrade it. Downloaded SQL2008 R2 Standard edition, which has the product key built in.
Ran the edition upgrade from the DVD, and said it ran successfully. But it didn't! When I check the version, it is still RTM.
I rebooted the server, still the same.
Anyone got another idea I could try?
Thanks
0
jdhackett
Asked:
jdhackett
  • 4
  • 4
  • 2
  • +1
1 Solution
 
arnoldCommented:
During the upgrade, did you select the existing instance versus creating a new one?
0
 
Anthony PerkinsCommented:
>>Ran the edition upgrade from the DVD, and said it ran successfully. But it didn't! When I check the version, it is still RTM.<<
What upgrade?  
Where did you download the SQL Server 2008 R2 Standard from?
Why did you expect the Product Level would change?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> Ran the edition upgrade from the DVD, and said it ran successfully. But it didn't! When I check the version, it is still RTM.

Run this script in SSMS:

SELECT SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

As per your statement, upgrade was successful and hence the edition should state as 'Standard Edition' now else it would show your earlier one..

And the productlevel would be still RTM since you haven't applied any Service packs. Value will change from RTM to SP1 or SP2 when you apply those ( Since SQL Server 2008 R2 doesn't have any Service Packs available, it will show RTM only)
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jdhackettAuthor Commented:
@Arnold - it only gave me a choice of one instance.

@rregan18 - the results are
RTM      Standard Edition (64-bit)

But wouldn't this have returned the same results before the upgrade? What would be different if it was still the eval version?
0
 
arnoldCommented:
What are the version numbers ?  This is how you'll see the difference.
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
select @@version

Is it 10.50.1600.x (SQL 2008 R2) versus the older version which was 10.0.1600.Y (SQL 2008)?
0
 
jdhackettAuthor Commented:
Version is 10.50.1600.1.
But it would have been that version anyway?
0
 
arnoldCommented:
NO, 10.5.1600.1 is the sql server 2008 R2 version.
The sql server 2008 version is 10.0.1600 note the second number in the major version number.
SQL 2008 10.0 original 10.50 R2
0
 
jdhackettAuthor Commented:
Anyway, how do I know that this isn't the eval version of 10.50.1600.1?
0
 
arnoldCommented:
An express version says that it is an express version when you run select @@version
What do you mean eval, are you talking about a version that is the 6-120 trial version?
I'm do not think it will be distinguishable based on the version, It would likely be referenced in the properties of the database server within Sql Server Management Studio, but since I have not check whether there is such an indicator before, can't say for sure.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> Anyway, how do I know that this isn't the eval version of 10.50.1600.1?

Result of the query which you have posted earlier..
>> RTM      Standard Edition (64-bit)

Confirms that you have Standard edition now and not Evaluation edition.
Hope it clarifies.
0
 
Anthony PerkinsCommented:
And if you are still having difficulty deciding what you really have than use something like this (it may make it a tad clearer):
SELECT	CASE SERVERPROPERTY('Edition')
		WHEN 'Enterprise Evaluation Edition' THEN 'I have the Evaluation Edition'
		ELSE 'I no longer have the Evualuation edition, instead I have the: ' + CAST(SERVERPROPERTY('Edition') AS varchar(50))
	END,
	SERVERPROPERTY('ProductLevel')

Open in new window

0
 
jdhackettAuthor Commented:
Thanks guys. I got a bit confused, mistakenly thinking RTM indicated it was still on the eval version.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now