asp.net app does not work on 1.1 framework on production box

[Josh Harris]

I am having an issue with an asp.net website not working in production
on the 1.1 framework, yet it works in development on the 1.1
framework. Both production and development are pointing to the same
database server. I get the error below:
Error: {0}System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied. at
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at
CollectorPerformance.menu.isSpecialAccessUser()An error has occurred.
Please contact the Help Desk.

Thanks for any ideas!

 

[Teemu Keiski]

Hi,

should there be equivalent network access to database server from the
production machine? The error states that trying to connect fails, have you
tried to connect any other ways like having SQL client tools temporarily on
production machine or just pinging the DB server?

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist

I am having an issue with an asp.net website not working in production
on the 1.1 framework, yet it works in development on the 1.1
framework. Both production and development are pointing to the same
database server. I get the error below:
Error: {0}System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied. at
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at
CollectorPerformance.menu.isSpecialAccessUser()An error has occurred.
Please contact the Help Desk.

Thanks for any ideas!

 

[Josh Harris]

Teemu, Thanks for the response.
It is not an issue of network access because we were able to recompile
the website with the 1.0 framework (also going to the website
properties/configuration and setting the framework folder to
1.0.3705), and it then works fine on the production server. It just
does not work when compiled with the 1.1 framework (and again setting
the framework folder back to 1.1.4322). Any Idea's?