How to Connect to a Database on Another Computer With SQL Server

Question

The SQL Server is connecting through Windows authentication, how to write the connection string in web.config file??

Answer 1

Hi Symesh,

Set in your connection string IP address of remote server. E.g.
"Data source=112.160.0.18; Database=dbname;User ID=urusername;password=****"
where 192.168.0.13 is your remote server IP and MyDb is your database name.
Also, make sure to configure your SQL Server Express to allow remote connections! Those are disabled by default after installation.

Thanks,
Pravin.

Answer 2

Hi

 
   string connectionstring ="data source=[Servername];initial catalog=Northwind; integrated security=SSPI;persist security info=False; Trusted_Connection=Yes."

Where datasource will be computer name or IP Address, and initial catalog is the name of database.
       For Windows Aunthetication you can use either MyDbConn1 or MyDbConn2:-
In web.config file...

<connectionStrings>
<add name="MyDbConn1"
connectionString="Server=MyServer;Database=MyDb;Trusted_Connection=Yes;"/>
<add name="MyDbConn2"
connectionString="Initial Catalog=MyDb;Data Source=MyServer;Integrated Security=SSPI;"/>
</connectionStrings>

      // Retrieving connection string from Web.config.
 String connString = WebConfigurationManager.ConnectionStrings["MyDbConn1"].ToString();
  SqlConnection conn = new SqlConnection(connString);
  conn.Open();

Please mark as Accepted answer if your query resolved.  

Answer 3

Check out this :

http://www.c-sharpcorner.com/uploadfile/mamta_m/storing-and-retrieving-connection-strings-in-Asp-Net-2-03-5/

Different type of Connection Strings:

http://www.connectionstrings.com/sql-server-2005