0

My application uses SSRS (on SQL Server 2017 on a server) and IIS. It runs fine in my IDE (VS 2017 or VS 2015) but when I put it on the server I get an error page.

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)

No connection string to SQL Server Express.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Jim
  • 1
  • 1
  • Probably it is the issue discussed here: https://stackoverflow.com/questions/24158072/what-does-clear-signify-when-specifying-a-connectionstring – Steve Apr 12 '19 at 21:16
  • Thank you for the suggestion but "connectionString" is not found anywhere in the solution. – Jim Apr 12 '19 at 21:41
  • This application hasn't ever before required aspnetdb but it is when I am publishing it to the IIS now. I'm trying to figure out why and remove any reference / namespace that requires that. – Jim Apr 17 '19 at 16:05

1 Answers1

0
  • Firstly make sure that your SQL server is running and SQL Server browser service is running.
    • Make sure SQL Server is configured to allow remote connections.
    • Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports.
    • Test server connectivity with PING from the client machine.
    • Test port connectivity using TELNET or PowerShell to the server and port from the client machine. For example a. TELNET 1433 b. PowerShell: 1433 | % { echo ((new-object Net.Sockets.TcpClient).Connect("YourServerName",$)) "server listening on TCP port $" }
    • Check firewall settings.
    • Also check your web.config file.

You could also refer below article: “A network-related or instance-specific error occurred”

Regards, Jalpa.

Jalpa Panchal
  • 8,251
  • 1
  • 11
  • 26
  • I am trying to figure out why my app is calling aspnetdb. I want to remove any references that use it. – Jim Apr 16 '19 at 16:19