SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL 2008 R2 Express -SP2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gangadhara.ms
Aged Yak Warrior

India
541 Posts

Posted - 01/31/2014 :  15:04:40  Show Profile  Visit gangadhara.ms's Homepage  Reply with Quote
Hi,
I have installed with SQL server 2008 R2 Data center edition with SP2.When i checked its also installed SQL server express 2008 R2 but with the SP1 only.Now i need to update sql server express with Sp2 but i am not able to target the SQL express 2008 R2 for SP2 Update.

It says "The version of SQL Server instance SQLEXPRESS does not match the version expected by the SQL Server update. The installed SQL Server product version is 10.1.2531.0, and the expected SQL Server version is 10.50.1600.1."

The current version of SQL server express is :

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

Thanks,
Gangadhara

tkizer
Almighty SQL Goddess

USA
35952 Posts

Posted - 01/31/2014 :  17:28:09  Show Profile  Visit tkizer's Homepage  Reply with Quote
That is SQL Server 2008 and not SQL Server 2008 R2. R2 is a different version. You'll need to get the service pack for just SQL Server 2008.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

gangadhara.ms
Aged Yak Warrior

India
541 Posts

Posted - 01/31/2014 :  18:16:15  Show Profile  Visit gangadhara.ms's Homepage  Reply with Quote
Thanks Tara to make this out,is perfectly alright with SQL server 2008 SP1.You saved my time.

Thanks,
Gangadhara MS
SQL Developer and DBA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000