Setting ip address to connect to database in config files

Problem: Database server is changed and we need to access database server from application server. It need to set url of database server in connection string. When we set API address of server in connection string connection does not establish however we can explore database server directory from application server

Here is the connection string


<ConnectionString value="Jet OLEDB:Database Password=pwd;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\92.52.101.201\Simplicity_Avon\Simplicity.mdb;Persist Security Info=False;" providerName="System.Data.OleDB" />

We need to understand what user does IIS manager use to access the Simplicity.MDB file.
Is it iisapps_user@simplicity-ebs.com?

Host provider suggest that we change the IP address in the config form the public to the private ip address Primary IP (public) : 92.52.101.201 to NAT IP (private) : 172.24.16.201.


it still does not work


IIS Manager uses iisapp_user

So the problem was iisapi_user. Both system should have same user. and password. Application software has local iisapp_user while database server user was in domain. When create local user on database system with same password it works