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)
Code=-2146232060
Proc=
Line=0
Stack Trace=   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at HSP.Models.CSQL.OpenConnection() in D:\HSP\Live\HSP\Models\CSQL.cs:line 79
Source=.Net SqlClient Data Provider
******** Dump of Http Request ********

Request.Params...
ASP.NET_SessionId=tewmghnkdp4fpbyonqj5m2qq
ALL_HTTP=HTTP_CONNECTION:close
HTTP_ACCEPT:*/*
HTTP_ACCEPT_ENCODING:gzip, br, zstd, deflate
HTTP_COOKIE:ASP.NET_SessionId=tewmghnkdp4fpbyonqj5m2qq
HTTP_HOST:www.heatingspareparts.com
HTTP_USER_AGENT:Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; com
patible; ClaudeBot/1.0; +claudebot@anthropic.com)
ALL_RAW=Connection: close
Accept: */*
Accept-Encoding: gzip, br, zstd, deflate
Cookie: ASP.NET_SessionId=tewmghnkdp4fpbyonqj5m2qq
Host: www.heatingspareparts.com
User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compati
ble; ClaudeBot/1.0; +claudebot@anthropic.com)
APPL_MD_PATH=/LM/W3SVC/2/ROOT
APPL_PHYSICAL_PATH=D:\inetpub\wwwroot\HSP\
AUTH_TYPE=
AUTH_USER=
AUTH_PASSWORD=
LOGON_USER=
REMOTE_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, O=Sectigo Limited, CN=Sectigo Public Server Authentication CA DV
 R36
CERT_SERVER_SUBJECT=CN=www.heatingspareparts.com
CERT_SUBJECT=
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, O=Sectigo Limited, CN=Sectigo Public Server Authentication CA DV
 R36
HTTPS_SERVER_SUBJECT=CN=www.heatingspareparts.com
INSTANCE_ID=2
INSTANCE_META_PATH=/LM/W3SVC/2
LOCAL_ADDR=217.154.32.159
PATH_INFO=/boiler-spares/partno/6867/213410
PATH_TRANSLATED=D:\inetpub\wwwroot\HSP\boiler-spares\partno\6867\213410
QUERY_STRING=
REMOTE_ADDR=216.73.216.182
REMOTE_HOST=216.73.216.182
REMOTE_PORT=14450
REQUEST_METHOD=GET
SCRIPT_NAME=/boiler-spares/partno/6867/213410
SERVER_NAME=www.heatingspareparts.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
URL=/boiler-spares/partno/6867/213410
HTTP_CONNECTION=close
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_COOKIE=ASP.NET_SessionId=tewmghnkdp4fpbyonqj5m2qq
HTTP_HOST=www.heatingspareparts.com
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeB
ot/1.0; +claudebot@anthropic.com)

Server Variables...
ALL_HTTP=HTTP_CONNECTION:close
HTTP_ACCEPT:*/*
HTTP_ACCEPT_ENCODING:gzip, br, zstd, deflate
HTTP_COOKIE:ASP.NET_SessionId=tewmghnkdp4fpbyonqj5m2qq
HTTP_HOST:www.heatingspareparts.com
HTTP_USER_AGENT:Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; com
patible; ClaudeBot/1.0; +claudebot@anthropic.com)
ALL_RAW=Connection: close
Accept: */*
Accept-Encoding: gzip, br, zstd, deflate
Cookie: ASP.NET_SessionId=tewmghnkdp4fpbyonqj5m2qq
Host: www.heatingspareparts.com
User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compati
ble; ClaudeBot/1.0; +claudebot@anthropic.com)
APPL_MD_PATH=/LM/W3SVC/2/ROOT
APPL_PHYSICAL_PATH=D:\inetpub\wwwroot\HSP\
AUTH_TYPE=
AUTH_USER=
AUTH_PASSWORD=
LOGON_USER=
REMOTE_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, O=Sectigo Limited, CN=Sectigo Public Server Authentication CA DV
 R36
CERT_SERVER_SUBJECT=CN=www.heatingspareparts.com
CERT_SUBJECT=
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, O=Sectigo Limited, CN=Sectigo Public Server Authentication CA DV
 R36
HTTPS_SERVER_SUBJECT=CN=www.heatingspareparts.com
INSTANCE_ID=2
INSTANCE_META_PATH=/LM/W3SVC/2
LOCAL_ADDR=217.154.32.159
PATH_INFO=/boiler-spares/partno/6867/213410
PATH_TRANSLATED=D:\inetpub\wwwroot\HSP\boiler-spares\partno\6867\213410
QUERY_STRING=
REMOTE_ADDR=216.73.216.182
REMOTE_HOST=216.73.216.182
REMOTE_PORT=14450
REQUEST_METHOD=GET
SCRIPT_NAME=/boiler-spares/partno/6867/213410
SERVER_NAME=www.heatingspareparts.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
URL=/boiler-spares/partno/6867/213410
HTTP_CONNECTION=close
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_COOKIE=ASP.NET_SessionId=tewmghnkdp4fpbyonqj5m2qq
HTTP_HOST=www.heatingspareparts.com
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeB
ot/1.0; +claudebot@anthropic.com)

******** End of Http Request Dump ********

******** Dump of Session Variables ********

CallerIP=216.73.216.182
IPBlocked=N
UserLocation=216.73.216.182, Columbus, Ohio, United States of America, US
IPBlockChecked=Y
IsCrawlByBot=Y
CurrentPageTitle=Part No: 0851 | 24 Hour Delivery | Heating Spare Parts
******** End of Session Variables Dump ********


******** Start of Stack Trace ********
D:\HSP\Live\HSP\Models\DBUtils.cs, GetStackTrace: Line 564: Column 17
D:\HSP\Live\HSP\Models\CSQL.cs, OpenConnection: Line 79: Column 25
D:\HSP\Live\HSP\Models\CSQL.cs, GetDataSet: Line 291: Column 17
D:\HSP\Live\HSP\Models\PartsRepository.cs, FindByPartProductId: Line 738: Column 21
D:\HSP\Live\HSP\Controllers\SparesController.cs, PartNo: Line 73: Column 21
******** End of Stack Trace ********