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??

Pravin More · Answer

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.

Datta Kharad · Answer

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... connectionString="Server=MyServer;Database=MyDb;Trusted_Connection=Yes;"/> connectionString="Initial Catalog=MyDb;Data Source=MyServer;Integrated Security=SSPI;"/> // 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.

Prabhu Raja · Answer

Check out this : http://www.c-sharpcorner.com/uploadfile/mamta_m/storing-and-retrieving-connection-strings-in-Asp-Net-2-03-5/ D ifferent type of Connection Strings: http://www.connectionstrings.com/sql-server-2005

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)