I am trying to connect one of our clients "as is" programs to a remote database instead of a local one, they think that they have coded it to work that way, but for some reason the program crashes when trying to connect to a remote database. I don't have the source code so I can't really dig much deeper than that and the company does not provide any upgrades or custom modifications. I can successfully connect to the database through SqlDbx and HeidiSQL so I know that the server is set up correctly.
This is why I need to find a way to spoof a remote connection on port 1433 to appear like a local database connection to the program. I thought about editing the hosts file, but it will most likely crash other programs if I bind localhost to another IP than 127.0.0.1.
Any ideas?
UPDATE:
I've tried solving it other ways like suggested, but I've tried everything I can think of.
- It's the same versions of all the programs
- TCP/IP works instead of Named pipes on localhost and works with sqlviewers like SqlDbx and HeidiSQL
- Authentication works with sqlviewers
- The configuration is only the fields needed for the database connection string
The only thing that I can see is left is that there is something restricting it from inside the code which I have no control over.