AnsweredAssumed Answered

Could not access the items in the database from client computers

Question asked by Timothy Jung on Jan 3, 2018
Latest reply on Jan 5, 2018 by Shaodun Lin

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?

Outcomes