how to connect application to sql server 2008 through remote

Question

Is there any way to connect to the database which is at remote server using asp.net? string.I checked for TCP/IP ports at remote desktop.They are also enabled I have tried specifying IP address and SQL server name in the connection string but it shows following error. (provider: TCP Provider error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond.)

nishigandha bidkar · Answer

i have follwed all the steps. But error is still there. can you please specifiy me connection string in c#

Nilesh Patil · Answer

Hi Refer following link it may help you https://blogs.msdn.microsoft.com/walzenbach/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008/

Nilesh Patil · Answer

This is code how to create connection string. using System.Data.SqlClient; SqlConnection conn = new SqlConnection(); conn.ConnectionString = Data Source=ServerName; + Initial Catalog=DataBaseName; + User id=UserName; + Password=Secret;; conn.Open(); assign your pc server name and database name instead of ServerName and Database Name. If you agree then please accept my solution