I have an application that is used on 2 computers:
appComputer (22.214.171.1240) & devComputer (126.96.36.1991).
I use a file named AppSettings.xml to set the connection string.
The app computer only has 1 database instance so I used the IP address:
and it works great.
On the DevComputer I use the computer name and the instance name:
This works as long as I am running the application on the DevComputer.
I have to be able to run the application from a different server pointing back to where the DB is located.
So how do I change the connection string to use the IP address (188.8.131.521) and the instance name (Demo)