News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) How to Upgrade a Lower...

Microsoft Dynamics RMS (Archived)

How to Upgrade a Lower Version Instance TO a Higher Version in SQL 2008 R2 Express?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

How can I update currently installed MSSQLSERVER Express-edition Version 9.4.5292

to

SQLEXPRESS Instance Express-edition Version 10.51.2500.0?

so I can restore a previous RMS SO backup done in 10-51-2500.

Basically my RMS SO install is inoperable under 9.4.5292

See attached discovery report.

Please help; Thank you.

<Sam>

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to Upgrade a Lower Version Instance TO a Higher Version in SQL 2008 R2 Express?

The only way the update worked for me is to first and foremost UNINSTALL SQL Server 2008 R2 from Windows Control Panel.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to Upgrade a Lower Version Instance TO a Higher Version in SQL 2008 R2 Express?

You will need to download the SQL 2008 R2 express installer.

www.microsoft.com/.../details.aspx

Then see this Microsoft website for explicit instructions:

msdn.microsoft.com/.../ms144267(v=sql.105).aspx

You basically run the setup.exe file and choose the upgrade option. Then select the instance name for your sql 2005 installation.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,321 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans