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

Announcements

No record found.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans