Microsoft SQL Server

SOLIDWORKS PDM 2020 SQL Server Requirements

SOLIDWORKS PDM 2020 SQL Server Requirements

Starting with SOLIDWORKS PDM 2020, the SQL Server running the vault database will need to be upgraded to at least SQL Server 2014 SP3. This applies to both SOLIDWORKS PDM Professional (running SQL Standard) and SOLIDWORKS PDM Standard (running SQL Express). You can check which…

Read More...

Installing SQL Server Express and the Management Studio

SQL Server Express

The SQL Server Management Studio (SSMS) is an integral component for administrating SOLIDWORKS PDM, as it allows us to maintain and capture backups of the database.  When installing a new instance of SQL Express for PDM Standard via the installation manager, the management studio is…

Read More...

Installing Microsoft SQL Server 2014 Standard for SOLIDWORKS PDM Professional

Installing Microsoft SQL Server

In this article we will look at installing Microsoft SQL Server 2014 Standard, which ships with the SOLIDWORKS installation media disks (not the downloadable installation file set). SQL Server 2014 Standard must be installed before SOLIDWORKS PDM Professional can be installed. SQL Server 2014 should…

Read More...

SOLIDWORKS PDM Standard & Professional Backup Process

SOLIDWORKS PDM Backup Process

SOLIDWORKS PDM provides a secure environment for users to store files, and safely keeps archived copies of these files on a central server, preventing most potential causes of data loss on local user’s computers. However, it is essential that copies of the PDM Archives and…

Read More...

SOLIDWORKS PDM SQL Server Statistics and Query Plans

SOLIDWORKS PDM SQL Server Statistics is information about what is stored in SQL Tables. This information is then used to generate optimized query plans. Great, but what does that have to do with SOLIDWORKS PDM? To understand that, we first need to understand what a…

Read More...

Problems when changing SOLIDWORKS Electrical Application Settings from Local to Server Setup

As a SOLIDWORKS Electrical Technical Support Expert I come across a lot of cases when electrical users change their SOLIDWORKS Electrical Application Settings from the Local Setup to the Server Setup and vice versa. For a Local Setup the electrical projects are saved on the local machine…

Read More...

Setting SOLIDWORKS PDM Microsoft SQL Server to use a Static Port

Microsoft SQL Server Static Port

For users to be able to log into SOLIDWORKS PDM they must be able to connect to the Microsoft SQL Server that is hosting the database. By default Microsoft SQL Server Standard will communicate on port number 1433, so generally all that might be needed…

Read More...

What does changing a SOLIDWORKS PDM ‘sa’ password affect?

SOLIDWORKS PDM sa password

If the SOLIDWORKS PDM sa password is lost or forgotten it can be reset using these steps.  Whenever there is a change to the account password, there is a few places within the vault settings where it needs to be updated: Archive Server Settings On…

Read More...

New SOLIDWORKS PDM Professional 2017 Licenses

With the release of SOLIDWORKS PDM Professional 2017, Dassault Systèmes has introduced two new license models. SOLIDWORKS PDM Professional Add-on Licenses The first of these, is SOLIDWORKS PDM Professional Add-on Licenses. This license type is ideal for companies who already have Microsoft SQL Server, including…

Read More...