Problem

This guide was written to assist with resetting the Microsoft SQL password for SOLIDWORKS PDM or SOLIDWORKS Electrical. This guide can be applied to any products that use Microsoft SQL Server(including Express editions).

Solution Step 1: SQL Server Management Studio

1. Install Microsoft SQL Server Management Studio (SSMS) from the Microsoft website.
2. Stop the SQL service and restart the service in single-user mode. The easiest way to do this is in an administrator command prompt. This prevents other users from logging in and prevents your password from being changed.
3. PDM Pro commands: 
   net stop mssqlserver
   ENTER
   net start mssqlserver /m”Microsoft SQL Server Management Studio”
   ENTER
4. PDM Standard commands:
   net stop mssql$swpdm
   ENTER
   net start mssql$swpdm /m”Microsoft SQL Server Management Studio”
   ENTER
5. Electrical commands:
   net stop mssql$TEW_SQLEXPRESS
   ENTER
   net start mssql$TEW_SQLEXPRESS /m”Microsoft SQL Server Management Studio”
   ENTER

6. Launch SSMS as admin and log in with Windows authentication (be sure to be logged in to Windows with an Administrator account). 

   

7. In the Object Explorer, right-click the Database instance and click Properties

   

8. Click on Security and make sure that "SQL Server and Windows Authentication mode" is selected, and click "OK"

   

9. In the Object Explorer, expand Security > Logins and then right-click on the user to change the password with "Properties" 

   

10. Change the password and confirm the change. Note: tew is for Electrical and sa is for PDM.

    

11. Exit Microsoft SQL Server Management Studio
12. Restart the SQL service in the admin Command Prompt window(multi-user mode). 
13. PDM Pro commands: 
    net stop mssqlserver
    ENTER
    net start mssqlserver
    ENTER
14. PDM Standard commands:
    net stop mssql$swpdm
    ENTER
    net start mssql$swpdm
    ENTER

15. Electrical commands:
    net stop mssql$TEW_SQLEXPRESS
    ENTER
    net start mssql$TEW_SQLEXPRESS
    ENTER

    

16. Test the login by launching SSMS, using SQL login, and typing in the new password and username sa (PDM) or tew(Electrical).

Updating Credentials in PDM

1. On the server, launch the PDM Archive Server Configuration application and click Tools > Default Settings, then click Change for SQL Login

2. Launch the Database Server Configuration and type in the new password in the login window.

Updating Credentials in Electrical

1. On the client computer with SOLIDWORKS Electrical, launch Electrical as admin.
2. For the connection errors, click "OK" on each error to continue

3. Click the Main Menu icon in the upper left and click Application Settings. 
4. Switch to the Databases tab, then update the password field, and click "Apply", then "OK".

Electrical will error until the application is restarted. Upon relaunching, it should automatically connect and show the Projects Manager window.

Notes

• PDM uses sa for the username, and Electrical uses tew
• PDM Standard and Electrical both use SQL Express named instances, for example: localhost\swpdm and localhost\TEW_SQLEXPRESS
• There is no default password for PDM, as that is not pre-populated on the initial installation.
• The default Electrical SQL password for user tew is: SQLpwd4ew.
• For Electrical users, once the password is reset, update the credentials in both the Installation Manager(modification) and in the Electrical Application Settings on the client computers.

For additional support, existing customers can submit a ticket or new customers can contact Hawk Ridge Systems.