Summary
Learn how to update SQL credentials in SOLIDWORKS PDM Database Server after password changes. Quick and easy guide.
The SOLIDWORKS PDM Database Server service periodically polls SOLIDWORKS PDM databases for updates such as automatic notifications, local view refresh, card list updates, replication schedule updates, and index server changes. If your Microsoft SQL (sa) credentials have changed, then they need updated in the Database Server Configuration.
Navigate to Windows Start > SOLIDWORKS PDM, and launch Database Server Configuration
Open PDM Administration
In the SOLIDWORKS PDM Database Server dialog, update the SQL-Server Connection credentials and then click OK to close the dialog.
Update SQL Credentials
Restart the SOLIDWORKS PDM Database server in the Windows Services app. Navigate to Windows Start > Window Administrative Tools, and then launch Services.
Open Services
In the windows Services app, right-click SOLIDWORKS Database Server and select Restart.
Restart Database Server Service
The Microsoft SQL credentials have now been updated in SOLIDWORKS PDM Archive Server.
If you want to learn the difference between automatically clearing and refreshing the cache during login or logout in PDM, this blog post is just for you.
