Follow

How To Use SQL Server Management Studio (SSMS) To Reset Your SQL Password

Rayne Britt

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

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.

Process

  1. Install the 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 administrator command prompt. This prevents other users from logging in and preventing your password change.

    PDM Pro commands:
    net stop mssqlserver
    ENTER
    net start mssqlserver /m”Microsoft SQL Server Management Studio”
    ENTER

    PDM Standard commands:
    net stop mssql$swpdm
    ENTER
    net start mssql$swpdm /m”Microsoft SQL Server Management Studio”
    ENTER

    Electrical commands:
    net stop mssql$TEW_SQLEXPRESS
    ENTER
    net start mssql$TEW_SQLEXPRESS /m”Microsoft SQL Server Management Studio”
    ENTER

    1_restart_single_user_mode.png

  3. Launch SSMS as admin and login with Windows authentication(be sure to be logged in to Windows with an Administrator account).
    2_smss_login.png

  4. In the Object Explorer, right click the Database instance and click Properties.
    3_mixed_mode_auth.png

  5. Click on Security and make sure that SQL Server and Windows Authentication mode is selected. Then click OK.
    4_mixed_mode_auth.png

  6. In the Object Explorer expand Security>Logins and then right click on the user to change the password.
    5_user_properties.png

  7. Change the password and confirm the change. Remember, tew is for Electrical and sa is for PDM.
    6_changepw.png

  8. Exit the SQL Management Studio.

  9. Restart the SQL service in the admin Command Prompt window(multi-user mode).
    PDM Pro commands:
    net stop mssqlserver
    ENTER
    net start mssqlserver
    ENTER

    PDM Standard commands:
    net stop mssql$swpdm
    ENTER
    net start mssql$swpdm
    ENTER

    Electrical commands:
    net stop mssql$TEW_SQLEXPRESS
    ENTER
    net start mssql$TEW_SQLEXPRESS
    ENTER7_restart_normal_mode.png

  10. Test the login by launching the SMSS and use SQL login and typing in the new password and user name sa (PDM) or tew(Electrical).


Updating Credentials in the Application

For PDM

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

11_archive_server_config_pw.png

Then launch the Database Server Configuration and type in the new password in the login window.

12_pdm_db_config.png


For Electrical
On the client computer with SOLIDWORKS Electrical, launch Electrical as admin. You will see a few connection errors like the following. Click OK to each error.

8_update_swe.png

9_update_swe.png

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

10_update_swe.png

It will error until the application is restarted. Upon re-launching it should automatically connect and show the Projects Manager window.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments