6 Replies Latest reply on Jan 5, 2018 8:52 AM by Shaodun Lin

    Could not access the items in the database from client computers

    Timothy Jung

      Hello, I am setting up epdm 2014 on a windows server 2016. Everything seems to work fine on the server machine but I cannot sign in to a vault from client computers.

      LOG:

      Error running query in SpDbOdbc

      State=08001

      Msg=[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

      Server: MYSERVER\SWPDM

      Database: DB_MYCADv2

       

      Here is a registry information of a client computer.

      Computer\HKEY_LOCAL_MACHINE\SOFTWARE\SolidWorks\Applications\PDMWorks Enterprise\Databases\MYCAD v2

      Name       Type           Data

      DbServer  REG_SZ    MYSERVER\SWPDM

      ServerLoc REG_SZ    MYSERVER

       

      After reading some forum articles saying this is a DNS issue, I typed PING MYSERVER on the command prompt window and did receive a signal back. So I believe  MYSERVER is properly redirected to a server machine's address?

       

      Is this the correct way to test the DNS? Is there any other issues that could possibly cause this problem?