Please solve this issue:
Database is in our server.
Name of the server is naz-server
To connect with the databse from that server I write the code in
web.config as
<add name="NazDesignConnectionString" connectionString="Data
Source=naz-server;Initial Catalog=NazDesign;User
ID=sa;Password=naz123"
providerName="System.Data.SqlClient" />
If I upload the website to our server then the above code will work.
Because the databse and website is in the same server.
Now, If the databsase is located in our server and website is
somewhere Delhi.
Though the database and website are in diffrent server, how to write
the code in web.config. I try to write code in web.config as
<add name="NazDesignConnectionString" connectionString="Data
Source=192.168.5.8;Initial Catalog=NazDesign;User
ID=sa;Password=naz123"
providerName="System.Data.SqlClient" />
192.168.5.8--- is something like our server IP. But the code is not
working. Any one can help?
