To verify that a PDM Client computer or Archive server can communicate with the SQL (Database) Server, a SOLIDWORKS PDM ODBC test can be performed.
ODBC (Open Database Connectivity) is accessed from the Windows Administrative Tools:
The testing is defined from the System DSN tab, by clicking on Add and selecting SQL Server
Any Name can be added for the Data Source and optionally a Description can be added. The SQL (Database Server) can be selected from a pull-down or entered manually.
Choose, ‘With SQL Server authentication using a login ID and password entered by the user’ as the Authenticity type and enter your SQL Login ID and password. The default Login ID is sa.
Choose the Database, for which you want to test the connection.
The following screen, can be left with the default options. Click on Finish to create the ODBC Data Source.
You will be presented, with the Configuration of the ODBC Data Source being created. Click on Test Data Source, to test the connection.
You will then be presented with a summary of the test results.
Learn more about SOLIDWORKS PDM
Take a SOLIDWORKS PDM training course delivered by a certified expert either in a local Canadian city, or live online