SQL 2008 R2 Express -SP2 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL 2008 R2 Express -SP2

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2014-01-31 : 15:04:40

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

38200 Posts

Posted - 2014-01-31 : 17:28:09

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/

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2014-01-31 : 18:16:15

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources