Hi,
I got an error when i am connecting to remote database through c# code means,
SqlConnection con=new SqlConnection(constr);
Error:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
Please help me..
Thanks in advance
Loading
Khargesh RajputPosted Feb 27, 2015, 10:54 PM
check your connection string and also check sql server is opening or not with remote server
Manish Kumar ChoudharyPosted Feb 27, 2015, 7:32 AM
Go through following links it will, help you
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8cdc71eb-6929-4ae8-a5a8-c1f461bd61b4/provider-sql-network-interfaces-error-26-error-locating-serverinstance-specified?forum=sqlexpress
http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/