web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Upgrade SQL 2005 EXPRE...
Small and medium business | Business Central, N...
Answered

Upgrade SQL 2005 EXPRESS TO SQL EXPRESS 2014

(0) ShareShare
ReportReport
Posted on by seminolebs 80

I would really like to know how to upgrade SQL Server 2005 Express to SQL Server 2014 Express and install Management Studio if possible.

I have never been successful downloading and managing to upgrade the 2005 database to the 2014 structure. Can some one guide me

I have the same question (0)
  • ToddB Profile Picture
    ToddB Microsoft Employee on at

    Hi Seminolebs,

    NOTE: Before performing any upgrade, etc. to SQL, it is recommended to make a backup of all databases as needed.

    In testing, I installed SQL Server 2014 without issue using the below steps:

    1. Clicked Download on the SQL Server 2014 Express page.

    Download Microsoft® SQL Server® 2014 Express from Official Microsoft Download Center

    2. Selected 'ExpressAdv 32BIT\SQLEXPRADV_x86+ENU.exe':

    pastedimage1620221983365v3.png

    3. Selected Upgrade:

    pastedimage1620221681097v2.png

    4. Selected the instance to upgrade:

    pastedimage1620222141102v4.png

    5. Upgrade installed without issue:

    pastedimage1620222782573v5.png

    Once SQL Server was upgraded, I validated I was able to log into Store Operations Manager and POS.


  • seminolebs Profile Picture
    seminolebs 80 on at

    When I follow the steps to upgrade a 2005 instance MSSQLEXPRESS to 2014, I get the following rule check error:

    User database compatibility level equal or less than 90 check generated warning

  • ToddB Profile Picture
    ToddB Microsoft Employee on at

    Hi seminolebs,

    Are you able to bypass the warning?

    What is the Compatibility Level if you look at the Properties of the database?

    pastedimage1622570289927v1.png



    View or Change the Compatibility Level of a Database - SQL Server | Microsoft Docs

    SQL Server 2014 does not support Compatability Level 90:

    ALTER DATABASE Compatibility Level (Transact-SQL) - SQL Server | Microsoft Docs

    pastedimage1622570895466v2.png

  • mcons Profile Picture
    mcons 390 on at

    If that doesn't work, you could also try installing SQL 2008, restore to that, then use 2008 manager to do a backup and then install sql 2014 and that should restore.   

  • Verified answer
    POS Business Solutions Profile Picture
    POS Business Solutions 92 on at

    Try to use old backup and updated

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,371 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,806 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,371

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans