I have 2 cloud servers with Win Server 2008 R2 OS on both, one is having MSSQL 2005 database and other server is serving ASP.Net application. Please help me to connect both the servers. I want to access database from my ASP.Net application. Both servers are having unique public IP addresses..... Thanks in advance
additional content copied from comment below
I have a ASP.Net application which needs MSSQL 2005 database. If I put ASP application and database on same computer it works fine. But now I want to shift my database server on another computer what should I write in connection string??
I tried to directly write IP address of the computer on which my database is. But if do it in LAN it works fine. And if the database computer is in another network (internet) and I try to enter the IP of that computer it shows error of cannot find server.