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  [Microsoft] [SQL Server Native Client 10.0] Named Pipes Provider: Could not open connection to SQL Server .
ERROR [HYT00] [Microsoft] [SQL Server Native Client 10.0] Login timed out
ERROR  [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