Base solution for your next web application
Open Closed

Publish Web.Host to Azure server - cannot find SQL server #10195


User avatar
0
TimMackey created

ANZ 8.1.0 angular/.NET core

An unhandled exception occurred while processing the request.
Win32Exception: The system cannot find the file specified.
Unknown location

SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, uint waitForMultipleObjectsTimeout, bool allowCreate, bool onlyOneCheckConnection, DbConnectionOptions userOptions, out DbConnectionInternal connection)

...appears in the browser. How can I diagnose this? How can I know the connection string that is invalid?


1 Answer(s)
  • User Avatar
    0
    TimMackey created

    This issue has been resolved by the creator.