How to kill an SQL connection to force a SOLIDWORKS PDM Client Logout

Article by Joe Medeiros, CSWE updated January 24, 2017

Article

Currently there is no functionality to force a SOLIDWORKS PDM logout, but the connection between the client and SQL can be temporarily killed. You should only kill SOLIDWORKS PDM if a user cannot be logged out normally.

If you need to prevent access to a vault, you can block a login, refer to my article on how to Block a PDM Login for more information.

To kill SOLIDWORKS PDM / SQL connection, you need to access the SQL Management Studio, then right-click on the SQL server, and select Activity Monitor.

SQL Activity Monitor

SQL Activity Monitor

Click on the Process tab and look for the process EdmServer.exe that is associated with the user you want to disconnect.

PDM Server Processes

PDM Server Processes

Right-click on the process and choose Kill Process from the shortcut menu.

Kill SOLIDWORKS PDM Option

Kill Process Option

If the user now attempts to navigate within the vault they will receive the following message.

SOLIDWORKS PDM Message

SOLIDWORKS PDM Message

Further attempts to access the vault will result in a blank Vault View.

Blank PDM View

Blank PDM View

Before the user can access the vault again, they will need to first log out. If login is currently blocked, they will then receive the message below, when they try to log in.

Blocked login message

Blocked login message

Related Links

Want to do more with SOLIDWORKS PDM?

Our Certified SOLIDWORKS PDM Experts can help you to:

Posts related to 'How to kill an SQL connection to force a SOLIDWORKS PDM Client Logout'

Joe Medeiros, CSWE

Joe Medeiros is a SOLIDWORKS and PDM Certified Expert. He has been helping SOLIDWORKS users with training, mentoring and implementations since 1998. He combines industry experience with a thorough understanding of SOLIDWORKS products to assist customers in being successful. He shares his experience and expertise through blogs; one of which has been incorporated into the SOLIDWORKS Essentials training manual.