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
LVL 1
jdhackettAsked:
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.

 
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 & Architect, EE Solution GuideCommented:
>> 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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 & Architect, EE Solution GuideCommented:
>> 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

Experts Exchange Solution brought to you by ConnectWise

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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.