Check your database IP address. Unless you have some type of internal network between your offices the IP address is most likely your culpruit. In addition make sure the db name on the remote server is correct also. Keidrick Pettaway http://kpettaway.com
-----Original Message----- From: "Nazrul ASP.Net Developer" <[email protected]> Date: Thu, 21 May 2009 00:53:23 To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting<[email protected]> Cc: <[email protected]> Subject: [DotNetDevelopment] web.config problem in asp.net 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?
