{"id":26492,"date":"2020-05-18T11:00:00","date_gmt":"2020-05-18T15:00:00","guid":{"rendered":"https:\/\/blogs.solidworks.com\/tech\/?p=26492"},"modified":"2020-05-04T09:14:47","modified_gmt":"2020-05-04T13:14:47","slug":"top-8-troubleshooting-steps-for-pdm-connectivity-issues","status":"publish","type":"post","link":"https:\/\/blogs.solidworks.com\/tech\/2020\/05\/top-8-troubleshooting-steps-for-pdm-connectivity-issues.html","title":{"rendered":"Top 8 Troubleshooting Steps for PDM Connectivity Issues"},"content":{"rendered":"

Using SolidWorks PDM is a great tool to control your revisions and versions, manage your files, etc. However, when it doesn\u2019t work it can become very frustrating. Don\u2019t worry, most issues are usually IT related, which can easily be resolved by following these troubleshooting steps. The most common and generic error when working with PDM is \u201cCannot access the item in the database\u201d or \u201cCould not find the Server\u201d. Have you experienced this before? Here are our top 8 troubleshooting steps to resolve these issues.<\/p>\n

\"PDM<\/p>\n

Firstly, about the error \u2013 we need to get as much information about the cause of the error. These messages only tell us what the error is, not what caused it. To determine the cause of the error, you\u2019ll need to open up you PDM Administration Tool, the under Local Settings double click on Log File. This will give you a chronological list of errors and warnings, once you find the log at the time you got the error, double click on the entry to get full details.
\nThe description of the PDM Client Log will show you a similar message to \u201cSQL Server does not exist or access denied.\u201d This is the cause of the error and we need to address this.<\/p>\n

\"Top<\/p>\n

As PDM is a client server setup, the error could be from your client or from the server. The first question you should ask yourself \u2013 is this happening to everyone or just me? If it\u2019s just you, then it\u2019s a client-side issue, if it\u2019s happening to everyone then it\u2019s a server-side issue. We cover both sides in this blog.
\nPlease note, it is assumed you are at least a little experienced with IT troubleshooting processes and have some administration permissions, otherwise, as always, we highly recommend you contact your reseller for support.<\/p>\n

Troubleshooting For PDM Client<\/h3>\n

There are several reasons why this error message can occur. Below are some basic troubleshooting steps that can be performed on PDM client-side to establish connection with SQL Server.<\/p>\n

1. Check if the SQL Server Name and Database shown in the log description are correct.<\/strong><\/h4>\n

The Server Name and SQL Database information can be found in the error log shown in the image above as well as from the PDM Administration tool. Open PDM Administration tool, right click on the vault and click properties. Consult your IT Team to check if the information about the server is correct.<\/p>\n

\"Top<\/p>\n

If the server details shown here are correct, then contact your reseller so they can have a look if the registries of the Vault are correct. You may need Windows Admin log in for your VAR to be able to access and check registries.<\/p>\n

2.\u00a0 Check if the client machine can communicate with SQL Server Machine<\/strong><\/h4>\n

Perform a \u201cPing\u201d test to the server machine from your client machine. First ping the server machine by server-name and then use the Server IP address to test. The ping test is a simple DOS command that tests network connectivity, it does not test ports. To access ping test, click Windows Start and type \u201cCommand Prompt\u201d, you should right click and open as Administrator. Once open, you\u2019ll need to type \u201cping SERVERNAME\u201d and press enter, where you put in your Server Name or Server IP Address. Here are a few scenarios:<\/p>\n

A. Ping test successful for either of the two but unsuccessful for another<\/span><\/h4>\n

If you can successfully ping the server using server name but no luck with IP address or vice versa, then this shows that this is a DNS Host Name issue.<\/p>\n

To resolve this, use Host file to map the IP Address and the Server Machine name and this will fix the DNS issue and the SQL Server should now be recognised.<\/p>\n

B. Ping test unsuccessful for both.<\/span><\/h4>\n

If this is the case, then Client machine is not communicating to the Server Machine. Check the network connection and make sure that both machines are on the same Domain Network. If not, you will need some support from your IT to fix the network connection issue.<\/p>\n

C. Ping test successful for both<\/span><\/h4>\n

If the ping test returns successful for both, then it is important to test if the ports the client machine communicates to the SQL Server are open. More details about ports are in the next step.<\/p>\n

3. Check if the ports used for SQL are open<\/strong><\/h4>\n

If SQL is installed and configured to use default ports, then we need to make sure that Ports – TCP 1433 and UDP 1434 are open. To test this, perform a \u201cTelnet\u201d Test.<\/p>\n

Remember to turn on the \u201ctelnet\u201d client on the client machine for telnet test to work, in Control Panel -> Programs and Features -> Turn Windows features on or off.<\/p>\n

To use Telnet to test a port, open Command Prompt again, this time you want to type – telnet <IP ADDRESS OF SERVER PC> <PORT>. If you get a blank screen with a blinking cursor then it worked, if you receive an error message then the port is not open.<\/p>\n

A. Telnet test Unsuccessful<\/span><\/h4>\n

If the Telnet test returns unsuccessful while the ping tests are successful, this means that the ports are blocked. The ports need to be opened. Contact your IT to make sure they have opened the ports that are being used for SQL.<\/p>\n

B. Telnet Test Successful<\/span><\/h4>\n

If Telnet test returns successful, then the ports are open, and the communication should work fine.<\/p>\n

If you still receive an error message while accessing the vault, then it is worth ensuring your client machine is using a static TCP port to communicate to the SQL Server \u2013 see next step.<\/p>\n

4. Force Client Machine to use Static TCP Port for SQL Database communication<\/strong><\/h4>\n

To enable a client to use a static port to communicate to SQL Database, an ODBC Test needs to be performed. The easiest way to find the tool is to click Windows Start and type ODBC, you\u2019ll get the 32 and 64 bit version, use the 64 Bit version. When configuring an ODBC Test, it is advisable to use SQL \u201csa\u201d (System Administration user) log in so please make sure that you have the password easily accessible. If not, please ask your IT\/Admin to help you.<\/p>\n

While configuring the test, make sure to click Client Configuration. In the dialogue box, alias name and server name will be automatically populated. There is no need to change them. Just uncheck \u201cDynamically Determine Port\u201d and use the port number that is being used by SQL Server. If it\u2019s a default, then it will be 1433.<\/p>\n

\"Top<\/p>\n

Once you get a successful result from this test then you should not have any issues communicating to the SQL Server. Remember to restart your PDM Client.<\/p>\n

ODBC Test establishes an ODBC connection alias which will then be used by the client when communicating with the SQL server instance. In most of the cases where the SQL has a named instance (i.e. when the name of the SQL instance hosting the vault database is different than the default name) ODBC Test is required.
\nWhen all the above steps are performed and there is still an error message when communicating with SQL Server, then this requires a troubleshooting at the server level.<\/p>\n

Troubleshooting on Server Machine<\/h3>\n

On the server, following are the few basic things that can be checked:<\/p>\n

1.Make sure SQL Server Services are running<\/strong><\/h4>\n

The list of these services can be checked from the task manager<\/p>\n

\"\"<\/p>\n

2.Firewall Settings<\/strong><\/h4>\n

As the firewall should be on for protection, please check that all the ports were added to the firewall exception list. Make sure the firewall exceptions are added for both incoming and outgoing. If PDM is configured using default ports, then following is the list of ports that need to be opened:
\ni. SNL (SolidNetwork License Manager) Ports for PDM Licensing to work properly
\na. TCP 25734 & 25735
\nii. Archive Server Ports
\na. TCP \u2013 3030
\nb. UDP \u2013 3030
\niii. Database Server (SQL Server) Ports
\na. TCP \u2013 1433
\nb. UDP \u2013 1434<\/p>\n

3.Force SQL to use Static TCP Port<\/strong><\/h4>\n

Open SQL Server Configuration Manager. If you don\u2019t have this tool installed, then press \u201cWindows Key + r\u201d and run \u201ccompmgmt.msc\u201d to access the SQL Server Configurations.
\nUse the following steps to make sure SQL Services are communicating through port 1433 for all IP Addresses.<\/p>\n

\"PDM<\/p>\n

<\/h4>\n

4.Make sure SQL System Admin (sa) Log in Credentials are correct<\/strong><\/h4>\n

There could be couple of scenarios:
\nA. PDM is configured to use correct \u201csa\u201d credentials
\nB. Not sure if PDM Vault is configured with correct \u201csa\u201d log in credentials or if \u201csa\u201d login credentials have been changed recently<\/p>\n

CASE A<\/strong>: If PDM is configured using correct \u201csa\u201d credentials, then make sure that vault is using the \u201cdefault\u201d SQL Login. This setting can be done within the Archive Server Configuration tool. Access the properties \u2013 Right Click Vault -> Properties -> Navigate to Login tab. Check the box for \u201cUse default SQL Login\u201d<\/p>\n

\"\"<\/p>\n

CASE B<\/strong>: If unsure that PDM was setup using correct \u201csa\u201d credentials or if \u201csa\u201d credentials have been changed then you can update PDM to use the correct SQL Password. Follow the steps mentioned above to navigate to the Login tab of the Vault Properties dialogue box and simply uncheck the dialogue box to enter the correct password.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

This will not test the password; it will just use this password whenever it needs to. So, if it is wrong you will get the error, however, once you fix up the correct password PDM will begin to work as normal.<\/p>\n

Hopefully, you\u2019ve successfully troubleshooted your PDM connectivity issues and are back on track using PDM to help with your SolidWorks designs. It\u2019s always extra satisfying to resolve your own issues.<\/p>\n

However, if you have tried all of these troubleshooting steps and solutions and you\u2019re still having these issues, that\u2019s what your reseller support is for. We have some highly experienced PDM application engineers on hand ready to get you back up and running asap.<\/p>\n

 <\/p>\n

Written by<\/p>\n

Arpit Saxena, Applications Engineer Team Leader at CADspace, a SOLIDWORKS Value Added Reseller in Australia.<\/p>\n","protected":false},"excerpt":{"rendered":"

Using SolidWorks PDM is a great tool to control your revisions and versions, manage your files, etc. However, when it doesn\u2019t work it can become very frustrating. Don\u2019t worry, most issues are usually IT related, which can easily be resolved<\/p>\n... Continued<\/a>","protected":false},"author":523,"featured_media":26565,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7,25,35,38],"tags":[356,2712,1006,39,60,62,40],"class_list":["post-26492","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-collaboration","category-solidworks-enterprise-pdm","category-tips-tricks","category-webtech","tag-how-to","tag-solidworks-australia","tag-solidworks-pdm","tag-tech-blog","tag-tech-tip","tag-technical-tips","tag-tips-tricks-3","avhec_catgroup-all"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/26492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/users\/523"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/comments?post=26492"}],"version-history":[{"count":2,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/26492\/revisions"}],"predecessor-version":[{"id":26589,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/26492\/revisions\/26589"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media\/26565"}],"wp:attachment":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media?parent=26492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/categories?post=26492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/tags?post=26492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}