SQL Server Does not exist or access denied

[Steven Ung]

Hello all,

I'm having the following error dump from an ASP.net application. The program
is to calculate MRP and it involves complex queries looping thru hundreds of
records in an few SQL 2000 table. After running for 2~3 minutes, the below
error is shown. I've search high and low, but can't find anything close to
solving this problem.

The same ASP page, with less data however works without any issue and is
still on test on our local LAN.

Any help is much appreciated.
SQL Server does not exist or access denied.
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.
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() +139
System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection
connection, SqlConnectionString connectionOptions) +84
System.Data.SqlClient.SqlConnection.Open() +384
ERP_xxx.ERP_xxx.ExecuteNonQuery(String SQL) +56
ASP.xxxx_aspx.GetBOMList(String xxxxx, String xxxxxxx, DateTime xxxxxxx,
Decimal xxxxxxxx, String xxxxx, String xxxxxxxx in x:\xxx\MRP4.aspx:227
ASP.xxxx_aspx.cmdProceed_Click(Object sender, EventArgs e) in
x:\xxx\MRP4.aspx:52
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

 

[Ian Frawley]

How are you actually connecting to the SQL database? Via trusted connection,
or using user credentials or is it hidden in a Webservice???

Ian

 

[Steven Ung]

It is connected using the username and password stored in web.config file
not using any impersonation.

--
Steven Ung

How are you actually connecting to the SQL database? Via trusted
connection,
or using user credentials or is it hidden in a Webservice???

Ian

Hello all,

I'm having the following error dump from an ASP.net application. The program
is to calculate MRP and it involves complex queries looping thru hundreds of
records in an few SQL 2000 table. After running for 2~3 minutes, the
below
error is shown. I've search high and low, but can't find anything close
to
solving this problem.

The same ASP page, with less data however works without any issue and is
still on test on our local LAN.

Any help is much appreciated.
SQL Server does not exist or access denied.
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.
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() +139
System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection
connection, SqlConnectionString connectionOptions) +84
System.Data.SqlClient.SqlConnection.Open() +384
ERP_xxx.ERP_xxx.ExecuteNonQuery(String SQL) +56
ASP.xxxx_aspx.GetBOMList(String xxxxx, String xxxxxxx, DateTime xxxxxxx,
Decimal xxxxxxxx, String xxxxx, String xxxxxxxx in x:\xxx\MRP4.aspx:227
ASP.xxxx_aspx.cmdProceed_Click(Object sender, EventArgs e) in
x:\xxx\MRP4.aspx:52
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1292



-------------------------------------------------------------------------- ------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032

 

[Patrick Olurotimi Ige]

Hi Steve,
It must be a connection error!
If you are using web.config can u post how u are connecting to the
database.
Remember Web.config is case sensitive(Its XML).
Hope it helps.
Patrick

 

[Steven Ung]

Forgive me if I did not explain the situation.

Web.config file

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<!-- application specific settings -->
<appSettings>
<add key="ConnectionString" value="server=g-123server,8960;user
id=erp1234505ConnectionString;password=ERP1234505Thailand;database=erp_123;pooling=false"
/>
<add key="ServerName" value="g-123server,8960" />
<add key="DatabaseName" value="erp_123" />
<add key="UserID" value="ReportsUser" />
<add key="Password" value="ReportsUser213" />
</appSettings>
<!-- forms based authentication -->
<system.web>
<!-- enable Forms authentication -->
<authentication mode="Forms">
<forms name="IBuySpyStoreAuth" loginUrl="login.aspx"
protection="All" path="/" />
</authentication>
<!-- enable custom errors for the application -->
<customErrors mode="Off" defaultRedirect="ErrorPage.aspx" />
<!-- disable session state for application -->
<sessionState mode="Off" />
<compilation debug="false">
<assemblies>
<add assembly="CrystalDecisions.CrystalReports.Engine,
Version=10.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.Shared, Version=10.0.3300.0,
Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.ReportSource,
Version=10.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.Web, Version=10.0.3300.0,
Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
</assemblies>
</compilation>
</system.web>
</configuration>

More info:
Web server is temporarily running on IIS 5.1 (lockdown enabled) on a Windows
XP SP2 and the SQL is running on another Compaq Proliant ML370 SQL 2000 Std
Edition SP3a

 

[Scott Allen]

Hi Steve:

Looks like you are trying to connect to g-123server on port 8960. What
kind of database are you using?

 

[Patrick Olurotimi Ige]

I also wonder Scott!
Patrick

 

[Steven Ung]

Hello Scott,

It is mentioned below that we're using SQL 2000 Std. We changed the port
from 1433 to 8960 as suggested by some websites during the Slammer
outbreaks.

Do you think that is the problem?

 

[Steven Ung]

This article may be our solution as we're setting the polling = "false"

http://support.microsoft.com/kb/328476

 

[Scott Allen]

Changing the port is a good idea from a security perspective. I think
the connection string just had me confused a bit, having
"ConnectionString" in the user id makes it look a little odd.

I don't think it is actually a connectivity issue. But just in case,
you might want to run through the following to see if it gives any
clues:
http://support.microsoft.com/kb/827422

If you execute the heavy duty query on the server in a tool like Query
analyzer does it exhibit any problems?