How to Connect to a Database on Another Computer With SQL Server
The SQL Server is connecting through Windows authentication, how to write the connection string in web.config file??
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 16, 2011, 4:07 AM
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 KharadPosted Nov 16, 2011, 4:17 AM
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 RajaPosted Nov 16, 2011, 4:05 AM
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