I can connect from Management Studio using my domain credentials.
From within the VS IDE I can connect to the database ok however when I try debugging my WebApp it comes up with
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)
The connection string from the web.config is
<connectionStrings>
<
add
name="TESTSQLConnectionString"
connectionString="Data
Source=(local);Initial Catalog=SAMPLEDB;Integrated Security=SSPI;Min Pool Size=5;Max Pool Size=60;Connect Timeout=30"
providerName="System.Data.SqlClient"/>
</
connectionStrings>
Things I have tried.
Changing ports 1433
Firewall disabling
Remote Connection enabled on SQL Server
TCP/IP and Named Pipes enabled in configuration
Modified Web.Config to use IP Addresses/ Usernames passwords /Trusted_Connections/ Different SQL Server on a different machine
gumby2701
Member
4 Points
31 Posts
A network-related or instance-specific error occurred while establishing a connection to SQL Serv...
Oct 16, 2008 04:04 AM|LINK
Hi,
I am completely stumped.
Im running
I can connect from Management Studio using my domain credentials.
From within the VS IDE I can connect to the database ok however when I try debugging my WebApp it comes up with
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)
The connection string from the web.config is
<connectionStrings><
add name="TESTSQLConnectionString" connectionString="Data Source=(local);Initial Catalog=SAMPLEDB;Integrated Security=SSPI;Min Pool Size=5;Max Pool Size=60;Connect Timeout=30" providerName="System.Data.SqlClient"/></
connectionStrings>Things I have tried.
So I have absolutely no idea what to do anymore.
Can anyone give me suggestions on what to try?
Many Thanks
Jeremy