How To Connect Web Form With Sql Server Running On An Other Computer In Asp.net

i am creating an asp.net web application. i am using SQL server 2014 for database. i need configure a connection string on client computer web form project to access SQL server dat

Solution 1:

Integrated Security=True on your string means that its try to connect to the other server with the credential that asp.net pool have on the local computer.

If they are not match, probably not, then you need either make the same user on both computers with the same password that runs the pool, also have credential to runs on SQL Server , but better use a connection string that connects with the correct user id and pass of sql server on the remote computer.

something like:

<add name="nadra" 
     connectionString ="Data Source=DESKTOP-H8JV03C,1433;Initial Catalog=Nadra;Trusted_Connection=True;User ID=UserName;Password=Password" 
       providerName="System.Data.SqlClient"/>