Microsoft SQL Server
By default when a new database is created within Microsoft SQL the recovery model option is set to full. If you’re capturing daily backups, a full recovery model can cause issues with the transaction log affecting performance. We’ve previously looked at how to change the…
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…
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…
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…
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…
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…
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…
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…
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…