D
Dave Dudley
Hi,
I have a new ASP .Net project that has been developed on our
development machine and connects to SQL Server 2000 on the same
machine. It is connecting via a connection string similiar to:
Data Source=[Machine Name];Initial Catalog=[Our
Catalog];uid=[Username];Password=[Password]
Everything works fine on this machine. I can change the the connection
string to our production SQL server and everything runs fine. The
production SQL server is also running SQL 2000. All machines are on
Windows 2000 with MDAC 2.8.
Our production web server is in its own zone in the firewall so their
isn't full network access, just a hole to the sql server. When I move
the site to the server I start to get the error below when trying to
access the sql server from the project.
All of the regular ASP connections work, both through named pipes and
ODBC but this one won't. I have read a ton of articles and newsgroup
postings about this now but haven't been able to resolve it and I am
ready to start pulling hair.
I have changed the processmodel to be the system account. I have added
"Network Library=dbmssocn" to the connection string. I have tried
impersonation, though since this isn't on the network I didn't expect
it to work. Reboots, restarts, nothing works.
Is there anything else that I am missing?
Thanks,
Dave Dudley
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +36
KnitPicks.SearchAll.Page_Load(Object sender, EventArgs e) in
C:\Documents and
Settings\Dudleyd\VSWebCache\cagdev_4251\SearchAll.aspx.vb:194
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
I have a new ASP .Net project that has been developed on our
development machine and connects to SQL Server 2000 on the same
machine. It is connecting via a connection string similiar to:
Data Source=[Machine Name];Initial Catalog=[Our
Catalog];uid=[Username];Password=[Password]
Everything works fine on this machine. I can change the the connection
string to our production SQL server and everything runs fine. The
production SQL server is also running SQL 2000. All machines are on
Windows 2000 with MDAC 2.8.
Our production web server is in its own zone in the firewall so their
isn't full network access, just a hole to the sql server. When I move
the site to the server I start to get the error below when trying to
access the sql server from the project.
All of the regular ASP connections work, both through named pipes and
ODBC but this one won't. I have read a ton of articles and newsgroup
postings about this now but haven't been able to resolve it and I am
ready to start pulling hair.
I have changed the processmodel to be the system account. I have added
"Network Library=dbmssocn" to the connection string. I have tried
impersonation, though since this isn't on the network I didn't expect
it to work. Reboots, restarts, nothing works.
Is there anything else that I am missing?
Thanks,
Dave Dudley
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +36
KnitPicks.SearchAll.Page_Load(Object sender, EventArgs e) in
C:\Documents and
Settings\Dudleyd\VSWebCache\cagdev_4251\SearchAll.aspx.vb:194
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750