I have an application that is used on 2 computers:
appComputer (220.127.116.110) & devComputer (18.104.22.1681).
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 (22.214.171.1241) and the instance name (Demo)