Microsoft SQL

How to Avoid Locking Out the Microsoft SQL sa Account

Starting with Microsoft SQL 2005, the Password Policy and Password Lockout settings from the Windows Operating System (found by going to Control Panel > Administrative Tools > Local Security Policy > Account Policies) are automatically inherited by the sa account in SQL. This could lead…

Read More...

Removing Old SQL Database Backups

To ensure the safety of your SOLIDWORKS PDM data, it’s essential to have a maintenance plan in place to perform regular (preferably nightly) backups of the vault database and the ConisioMasterDB database.  A Maintenance Plan that will automatically backup the databases can be set up…

Read More...

Uninstalled Microsoft SQL Server but components have been left behind?

Uninstall microsoft sql server

In some cases, when you uninstall Microsoft SQL Server, some components may be left behind. This could prevent the proper re-installation of Microsoft SQL Server, or interfere with its normal operation. As an example, a SOLIDWORKS PDM Administrator may encounter connection issues, when attempting to…

Read More...

Installing SQL Management Studio for SOLIDWORKS PDM Standard

The backbone of the SOLIDWORKS PDM Standard vault is the database in Microsoft SQL Server Express.The SQL Express server databases can be managed and maintained using the SQL Management Studio.  This program is not installed automatically when installing SOLIDWORKS PDM Standard server components, however it…

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...

SOLIDWORKS PDM Professional Replicate Database is new for 2017

Starting with the 2017 release of SOLIDWORKS PDM Professional, administrators can now take advantage of the “AlwaysOn Availability Groups” or AOAG in Microsoft SQL Enterprise edition.  This will allow for replication of the vault database to multiple locations. Previously, replication in PDM was available for Archives…

Read More...

Checking for Index Fragmentation in SOLIDWORKS EPDM

This article was originally intended to introduce the Reorder and Reorganize tasks in SQL. These tasks will be discussed in other articles, but while researching for this article my mindset on the aforementioned tasks, has shifted somewhat. First let’s look at how to check for fragmentation. Check…

Read More...

SOLIDWORKS EPDM SQL Maintenance Task Shrink Database

The Shrink Database task reduces the size of SQL Server database data and log files. This task can cause index fragmentation and is not recommended by SOLIDWORKS. SOLIDWORKS does note that “on large databases or environments with hundreds of users, shrinking the SOLIDWORKS® Enterprise PDM…

Read More...

Want to become a SOLIDWORKS Expert?

Take a LIVE Online Training Course from Javelin