0

I have a program called VHI(Visual Health Information - Network Version) that is a server/client model. I have installed the server portion and has a database. SQL Server Name\instance = "EDSERV03\VHI_PCKITS" with database called "pckits". The client application is also installed on the server and it opens and works fine. Now I install the application on a client computer and it stuck on Verifying database version... with an error code in the log:

    OLE DB Error Record dump for hr = 0x80004005

Error Location line = 120, file = 'sqldb.cpp'

Source:"Microsoft OLE DB Provider for SQL Server"
Description:"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Help File:"(null)"
Help Context:   0
GUID:{0C733A8B-2A1C-11CE-ADE5-00AA0044773D}

Looking into Wireshark Wireshark connection failed with STATUS_BAD_NETWORK_NAME

It looks like it is trying to connect to a network share \\EDSERV03\VHI_PCKITS which is the SQL instance. So, I tried creating a network share of that share name to the pckits.mdf data folder and ran the connection again. Wireshark image after creating a share path

It looks like it may work if I could somehow put the share path directly on the sql instance to use named piping? However I could not find how to do that and if that's even possible. This company is no longer in business and I'm running out of ideas.

  • The "SQL Server does not exist or access is denied" error is unrelated to the presence or absence of a \\EDSERV03\VHI_PCKITS share. From the client computer, make sure you can resolve EDSERV03 to an IP address. Make sure the SQL instance is configured to accept TCP connections. Make sure any firewall between the client and the server is allowing UDP 1434 and whatever TCP port the VHI_PCKITS instance is using. – Doug Deden Jan 10 at 20:25
  • 1
    The wireshark information threw me for a spin. After enabling port 1434 and enabling TCP protocols, restaring the service like you said it worked. Thank you. – Taylor Jan 10 at 20:43
  • That's great news. I'll write it up as an answer. – Doug Deden Jan 10 at 20:45
0

The "SQL Server does not exist or access is denied" error is unrelated to the presence or absence of a \\EDSERV03\VHI_PCKITS share.

Assuming your issue is the "does not exist" half of the error message, check the following things:

  • From the client computer, make sure you can resolve EDSERV03 to an IP address.
  • Make sure the SQL instance is configured to accept TCP connections.
  • Make sure any firewall between the client and the server is allowing UDP 1434 (so the client can find out what port the named instance is using, via the SQL Browser service) and whatever TCP port the VHI_PCKITS instance is using.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.