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.OpenAn dLogin() +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.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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
--
Steve

[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" <st****@nodomainname.com> wrote in message
news:30*************@uni-berlin.de...

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.OpenAn dLogin() +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.IPo stBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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
--
Steve

[Steven Ung]

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

--
Steven Ung
"Ian Frawley" <ch****@away.com> wrote in message
news:cd***************@news-1.opaltelecom.net...

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" <st****@nodomainname.com> wrote in message
news:30*************@uni-berlin.de...

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.OpenAn dLogin() +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.IPo stBackEventHandler.RaisePo
stBackEvent(String

eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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
--
Steve

[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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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=ERP1234505T hailand;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

--
Steven Ung
"Patrick Olurotimi Ige" <pa*********@crazyjohns.com.au> wrote in message
news:er**************@tk2msftngp13.phx.gbl...

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Scott Allen]

Hi Steve:

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

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Fri, 26 Nov 2004 15:37:00 +0800, "Steven Ung"
<st****@nodomainname.com> wrote:

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=ERP1234505 Thailand;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

[Patrick Olurotimi Ige]

I also wonder Scott!:(
Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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
"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:cr********************************@4ax.com...

Hi Steve:

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

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Fri, 26 Nov 2004 15:37:00 +0800, "Steven Ung"
<st****@nodomainname.com> wrote:

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=ERP123450 5Thailand;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

[Steven Ung]

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

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

--
Steven Ung
"Patrick Olurotimi Ige" <pa*********@crazyjohns.com.au> wrote in message
news:e%****************@TK2MSFTNGP09.phx.gbl...

I also wonder Scott!:(
Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Mon, 29 Nov 2004 07:36:57 +0800, "Steven Ung"
<st****@nodomainname.com> wrote:

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?