Unable to Connect to IIS 7 SystemDSN ODBC Data Source

I have configured the odbc datasource as a system DSN. It works fine on its own and from within Visual Studio.

When I try to start the application under IIS 7 when connected, I get an error:

ERROR [08001] [Microsoft] [SQL Server Native Client 10.0] Named Pipes Provider: Could not open connection to SQL Server [5].

ERROR [HYT00] [Microsoft] [SQL Server Native Client 10.0] Login timed out

ERROR [08001] [Microsoft] [SQL Server Native Client 10.0] A network-related or instance-specific error occurred while establishing a connection to SQL Server. Server not found or not available. Check if the instance name is correct and if the SQL Server is configured for remote connections. For more information, see the SQL Server Books on the Internet.


source to share

1 answer

The IIS application is running as a different user - that user has no hunch about accessing what ODBC is using.

I changed the ApplicationPool ID to work as an administrator - this solved my problem. It was a quick decision. At least this is a cut. :)



All Articles