SOLIDWORKS PDM 2020 requires that your installation of Microsoft SQL is at or newer than 2014 SP3. If you have previously installed the SQL server using the Installation media set that shipped with your SOLIDWORKS PDM, you may need to upgrade to 2014 SP3. This document will guide through the process of upgrading SQL. This process addresses the message below that appears during the database upgrade.
Ensure that you have run a full back up of your PDM environment. Also note that the end of life for Microsoft SQL 2014 SP3, is SOLIDWORKS Products version 2021 SP5.
If you have not started your PDM 2020 upgrade, and have not yet received the message above, check to see what version of SQL you currently have.
Open SQL Management Studio > Log into your SQL instance that host your vault database > Click on New query and type: Select @@version > Click on Execute.
If you have a version 12.X that is older than 12.0.6024.0, please download the SP3 upgrade. A download link is provided below for your convenience. Note that if you have a version that is newer than 12.0.6024.0, you do not need to follow these steps. You can proceed with your SOLIDWORKS PDM 202X upgrade and will not need to upgrade your SQL.
The upgrade process is super simple. Essentially, next, next, next. However, here are the steps with our commentary:
You may need to perform a restart of the server machine after the upgrade completes. You can now run the same select @@version to verify the upgrade.
Should look like this:
Once you have completed the SQL Service pack upgrade, you can now proceed with upgrading SOLIDWORKS PDM to version 202X.
About Francisco Guzman
Francisco Guzman is the PDM Technical Support Lead at GoEngineer, and is pursuing his degree in mechanical engineering at the University of Utah. In addition to providing guidance and support to SOLIDWORKS and SOLIDWORKS PDM customers, Francisco also provides support for DriveWorks design automation. He won the world-wide DriveWorks reseller CPD contest as the best DriveWorks AE for 2015. For fun, he designs, 3D-Prints, builds and races custom first-person-view (FPV) racing drone frames.
Get the latest articles delivered daily to your inbox, unsubscribe at any time.