SOLIDWORKS PDM Professional SQL Server Changes for 2022

Article by GoEngineer on Mar 01, 2021

SQL 2014 SP3 End of Life

SOLIDWORKS 2021 SP5 will be the last release of PDM Professional / Manage that will support the use of SQL Standard 2014.

Don't Forget! Download a Copy >> SQL Licensing Changes Effective in 2022

Important: This will only affect PDM Professional, not PDM Standard. PDM Standard uses a free SQL Express that does not require any paid licensing. However, the installed version of SQL Express will still need to be upgraded.

SOLIDWORKS PDM Professional SQL Changes 2022 Breakdown

Many customers, if they have upgraded to SOLIDWORKS 2020 / 2021, will have noticed that they needed to upgrade the SQL Server to 2014 SP3. When upgrading to SOLIDWORKS 2022, you will need to upgrade your SQL Server to 2016 or 2019.

SQL Server Licensing changes

For customers who purchased PDM Professional or SOLIDWORKS Manage prior to October 2019, a SQL Server Core license was included with the purchase. The included license is good up through SQL Server 2014 SP3. SOLIDWORKS PDM / Manage licenses purchased after October 2019 will have SQL licenses listed on the bill of sale as their own line item.

When upgrading to SOLIDWORKS PDM / Manage 2022, customers will need to provide their own SQL Server licensing.

SQL Server Licensing Requirements

  • SERVER + CAL Model
    • 1 SERVER license required per SQL Database Server
    • Replicated archive servers do not require a SQL Server license
    • Test servers may be covered by SQL Server Developer Edition
    • 1 CAL is required per PDM User
      • SQL CAL licenses are per named user
      • To ensure Microsoft compliance, customers will need 1 CAL per user or device that is connecting to PDM
  • CORE Model
    • SQL core licensing is based on the number of CPU Cores on the Database Server
    • Individual users do not require CALs
    • For Microsoft compliance, the customer will need to have enough licenses to cover the total logical processors on the server.

Where to obtain SQL Server Licensing

Contact your existing Microsoft Partner, if you do not have one, here is our recommendation

Go Engineer can provide both Server + CAL and Core licensing on request, with or without Software Assurance as needed, however, we recommend purchasing through your Microsoft Partner.

Software Assurance

SQL Licensing can be purchased with an optional Software Assurance. This is a Microsoft subscription service that provides technical support and access to future releases. This is sold in 2-year increments.

This is not required for PDM, however, as new versions get released it will provide access to the necessary versions of SQL Server.

GoEngineer Application Mentoring Sessions

Summary

  • SOLIDWORKS 2021 SP5 will be the last version supporting SQL Server 2014 SP3
  • SQL Server licensing as of October 2019 is no longer included with any PDM Professional licensing
  • Customers will need to purchase SQL Server licensing either from Microsoft or GoEngineer to upgrade to 2022.
  • Can be either SERVER + CAL or Core model of licensing

If you have any questions, please reach out to GoEngineer Technical Support or your local account representative.

Expand Your SOLIDWORKS PDM Skillset

Using PDM Templates Inside SOLIDWORKS

Sharing Your SOLIDWORKS PDM Vault Without Sharing Licenses

Enabling the SOLIDWORKS PDM Administrator Tool Shortcut

How to move Files to a New Workflow in SOLIDWORKS PDM

Locking a SOLIDWORKS PDM Quick Tip

About GoEngineer

GoEngineer delivers software, technology and expertise that enable companies to unlock design innovation and deliver better products faster. With more than 35 years' experience and tens of thousands of customers in high tech, medical, machine design, energy and other industries, GoEngineer provides best-in-class design solutions from SOLIDWORKS CAD, Stratasys 3D printing, Creaform & Artec 3D scanning, CAMWorks, PLM, Altair, and more

View all posts by GoEngineer

Subscribe

Get the latest articles delivered daily to your inbox, unsubscribe at any time.