I think U Your DataBase Service provider does not permit for Remote connection. There for if website and Sql server is on the same server they get connected and in case of different location the setting not working.
Happy Programming Naveen Kumar www.codeguruindia.com On Fri, May 22, 2009 at 2:57 PM, <[email protected]> wrote: > 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? > >
