0

I have a VB6 application with an SQL Server 2008 database. It works fine on my developer workstation, of course, but when I deployed it in a freshly installed operating system (a virtual machine), an error occurs saying:

enter image description here

Additional info:

I tried to deploy it in another computer (not fresh install and not a VM) and it works fine.

Here is my connection string:

Provider=SQLOLEDB.1;Server=GS3-LNUBLA\LESTERDB;Database=UPPC;User Id=sa;Password=p@ssw0rd;

Does it mean I have to install something before my application to work? If there is, what could it be?

Lester Nubla
  • 145

1 Answers1

1

Does it mean I have to install something before my application to work?

OBVIOUSLY not - the error is quite clear. If you would miss a driver for sql server, it would not be able to try to reach it.

Start checking the basics first, one by one.

  • Can the server be reached? (ping)
  • Is the proper port open to reach the instance (LESTERDB is an instance name)

I suspect either crappy configuration on the vm side (as another normal server works) or a firewall or routing issue. Server does not exist can mean machine not reachable, traffic blocked, wrong protocol configuration. Access denied obviously means exactlyx that.

TomTom
  • 52,109
  • 7
  • 59
  • 142