473,320 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Server Error in '/MyWebForm' Application

I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web
Application Using a Third-Party Business Object). When I first create the
SQL connection in VS.NET 2003, I test the connection and everything works
fine. However, when I attempt to run the first stage of the app (the bound
datagrid), I receive an error stating:

login failed for user 'DELL340\ASPNET'.

There was another post in this newsgroup on this subject (Difficulty
connecting to SQL Server 2000:2002-03-04) that suggested placing the line:

<identity impersonate="true" />

in the Web.config file but when I run the app again, there is the following
failure message:

Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

What can I do to fix the problem?

I appended the full text of the second error message. System is Windows XP,
SP2. MSDE server.

Ed.
--
Edward E.L. Mitchell
Web: www.racesail.org
Phone: (508)771-0806
500 Ocean St., Unit 134,
Hyannis, MA 02601

Server Error in '/MyWebForm' Application.
--------------------------------------------------------------------------------

Login failed for user 'DELL340\IUSR_DELL340'.
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: Login failed for user
'DELL340\IUSR_DELL340'.

Source Error:

Line 48: public void FillDataSet(myDataSet dSet)
Line 49: {
Line 50: sqlDataAdapter1.Fill(dSet);
Line 51: }
Line 52:

Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50

Stack Trace:

[SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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) +38
MyWebForm.Component1.FillDataSet(myDataSet dSet) in
c:\inetpub\wwwroot\mywebform\component1.cs:50
MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
Nov 18 '05 #1
13 2237
Your SQLConnection string has the parameter and value "Integrated
Security=SSPI;" in it. This is telling the connection object to use
integrated windows account. in other words whoever the user running the
aspx page will be the account used to log intothe database. When you have
inpersonation off (which is what it was at first), each page request is
handled by the ASPNet account which is why you are seeing DELL340\ASPNet

when you turn inpersonation on, each page request is the actual user on the
domain requesting the page (which is why the account changes, the page is
now being requested as someone else).

My guess is you don't want to use Integrated Security...and you want to use
SQL Accounts...to do so, you want your connection string to look something
like:

"Provider=sqloledb;Data Source=DATABASE_SERVER;Initial
Catalog=DATABASE_NAME;User Id=USERID;Password=PASSWORD;"

for example

"Provider=sqloledb;Data Source=localhost;Initial Catalog=forums;User
Id=sa;Password=mySaPassword;"
karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:uo**************@TK2MSFTNGP10.phx.gbl...
I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web
Application Using a Third-Party Business Object). When I first create the
SQL connection in VS.NET 2003, I test the connection and everything works
fine. However, when I attempt to run the first stage of the app (the bound datagrid), I receive an error stating:

login failed for user 'DELL340\ASPNET'.

There was another post in this newsgroup on this subject (Difficulty
connecting to SQL Server 2000:2002-03-04) that suggested placing the line:

<identity impersonate="true" />

in the Web.config file but when I run the app again, there is the following failure message:

Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

What can I do to fix the problem?

I appended the full text of the second error message. System is Windows XP, SP2. MSDE server.

Ed.
--
Edward E.L. Mitchell
Web: www.racesail.org
Phone: (508)771-0806
500 Ocean St., Unit 134,
Hyannis, MA 02601

Server Error in '/MyWebForm' Application.
-------------------------------------------------------------------------- ------
Login failed for user 'DELL340\IUSR_DELL340'.
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: Login failed for user 'DELL340\IUSR_DELL340'.

Source Error:

Line 48: public void FillDataSet(myDataSet dSet)
Line 49: {
Line 50: sqlDataAdapter1.Fill(dSet);
Line 51: }
Line 52:

Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50

Stack Trace:

[SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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) +38
MyWebForm.Component1.FillDataSet(myDataSet dSet) in
c:\inetpub\wwwroot\mywebform\component1.cs:50
MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

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

Nov 18 '05 #2
> login failed for user 'DELL340\ASPNET'.

Sounds like the ASPNET account, the account ASP.NET pages run under by
default, doesn't have access to your database.
Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

IUSR_<COMPUTER NAME> is the account IIS is running under. It switched to
that account because you added <identity impersonate="true" /> to your
web.config. And presumably, you left anonymous access checked in IIS
security settings for your virtual directory.

Is SQL server installed on your computer, or on a remote computer? If it is
local, then you need to give ASPNET rights to the database using SQL
Enterpise Manager.

If SQL is remote, then things get stickier, but let us know first...

HTH,
Greg
"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:uo**************@TK2MSFTNGP10.phx.gbl...I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web
Application Using a Third-Party Business Object). When I first create the
SQL connection in VS.NET 2003, I test the connection and everything works
fine. However, when I attempt to run the first stage of the app (the bound
datagrid), I receive an error stating:

login failed for user 'DELL340\ASPNET'.

There was another post in this newsgroup on this subject (Difficulty
connecting to SQL Server 2000:2002-03-04) that suggested placing the line:

<identity impersonate="true" />

in the Web.config file but when I run the app again, there is the
following failure message:

Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

What can I do to fix the problem?

I appended the full text of the second error message. System is Windows
XP, SP2. MSDE server.

Ed.
--
Edward E.L. Mitchell
Web: www.racesail.org
Phone: (508)771-0806
500 Ocean St., Unit 134,
Hyannis, MA 02601

Server Error in '/MyWebForm' Application.
--------------------------------------------------------------------------------

Login failed for user 'DELL340\IUSR_DELL340'.
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: Login failed for
user 'DELL340\IUSR_DELL340'.

Source Error:

Line 48: public void FillDataSet(myDataSet dSet)
Line 49: {
Line 50: sqlDataAdapter1.Fill(dSet);
Line 51: }
Line 52:

Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50

Stack Trace:

[SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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) +38
MyWebForm.Component1.FillDataSet(myDataSet dSet) in
c:\inetpub\wwwroot\mywebform\component1.cs:50
MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

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

Nov 18 '05 #3
IIS has a service account: DELL340\IUSR_DELL340 on your machine
ASP.Net has a service account: DELL340\ASPNET on your machine

the default is for you request to run under the asp.net account
setting <identity impersonate="true" /> means use the IIS security token for
the request.
if the web site is anonymous, then the IIS security token is the iis account
if anonymous is turned off, then the IIS security token will match the
authenicated account.

if you turn off anonymous, your connect will work, but there are
restrictions.

1) if basic or kerboreos (and kerboreos delegation is enabled) your ok.
2) if nt authenication is used, then the sqlserver must be on the iis box
except for
a browser running on the local box (say you dev machine) or you will hit
the one hop rule.

if you need anonymous access to your site, then supply an domain account
<identity impersonate="true" userName="domain\user" password
="mypassword" />

-- bruce (sqlwork.com)

"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:uo**************@TK2MSFTNGP10.phx.gbl...
I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web
Application Using a Third-Party Business Object). When I first create the
SQL connection in VS.NET 2003, I test the connection and everything works
fine. However, when I attempt to run the first stage of the app (the bound datagrid), I receive an error stating:

login failed for user 'DELL340\ASPNET'.

There was another post in this newsgroup on this subject (Difficulty
connecting to SQL Server 2000:2002-03-04) that suggested placing the line:

<identity impersonate="true" />

in the Web.config file but when I run the app again, there is the following failure message:

Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

What can I do to fix the problem?

I appended the full text of the second error message. System is Windows XP, SP2. MSDE server.

Ed.
--
Edward E.L. Mitchell
Web: www.racesail.org
Phone: (508)771-0806
500 Ocean St., Unit 134,
Hyannis, MA 02601

Server Error in '/MyWebForm' Application.
-------------------------------------------------------------------------- ------
Login failed for user 'DELL340\IUSR_DELL340'.
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: Login failed for user 'DELL340\IUSR_DELL340'.

Source Error:

Line 48: public void FillDataSet(myDataSet dSet)
Line 49: {
Line 50: sqlDataAdapter1.Fill(dSet);
Line 51: }
Line 52:

Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50

Stack Trace:

[SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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) +38
MyWebForm.Component1.FillDataSet(myDataSet dSet) in
c:\inetpub\wwwroot\mywebform\component1.cs:50
MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

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

Nov 18 '05 #4
Greg,

I'm a neophyte here, just trying to get a first ASP.NET test program to
work. I am running IIS on my XP workstation. No one else needs to get at
it for now.

It seems that I shouldn't be using <identity impersonate="true">. All I
want to do at the moment is to run the test under my account which should be
the "integrated windows account" since I have admistrator privileges.

I don't have SQL Server, just the MSDE engine that I can use to test. The
"select @@version" from osql shows Desktop Engine 5.1; SP2 though after "SQL
Server 2000 - 8.00.760."

There is a user account on the machine "ASP.NET MachineA..." that is
described as a limited account, password protected although I didn't create
is as far as I know! I can't find an ASPNET account.
How would I give it rights under the SQL Enterprise Manager. Is this part of
MSDE?

Regards,

Ed

"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
login failed for user 'DELL340\ASPNET'.


Sounds like the ASPNET account, the account ASP.NET pages run under by
default, doesn't have access to your database.
Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?


IUSR_<COMPUTER NAME> is the account IIS is running under. It switched to
that account because you added <identity impersonate="true" /> to your
web.config. And presumably, you left anonymous access checked in IIS
security settings for your virtual directory.

Is SQL server installed on your computer, or on a remote computer? If it
is local, then you need to give ASPNET rights to the database using SQL
Enterpise Manager.

If SQL is remote, then things get stickier, but let us know first...

HTH,
Greg
"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:uo**************@TK2MSFTNGP10.phx.gbl...
I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web
Application Using a Third-Party Business Object). When I first create the
SQL connection in VS.NET 2003, I test the connection and everything works
fine. However, when I attempt to run the first stage of the app (the
bound datagrid), I receive an error stating:

login failed for user 'DELL340\ASPNET'.

There was another post in this newsgroup on this subject (Difficulty
connecting to SQL Server 2000:2002-03-04) that suggested placing the
line:

<identity impersonate="true" />

in the Web.config file but when I run the app again, there is the
following failure message:

Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

What can I do to fix the problem?

I appended the full text of the second error message. System is Windows
XP, SP2. MSDE server.

Ed.
--
Edward E.L. Mitchell
Web: www.racesail.org
Phone: (508)771-0806
500 Ocean St., Unit 134,
Hyannis, MA 02601

Server Error in '/MyWebForm' Application.
--------------------------------------------------------------------------------

Login failed for user 'DELL340\IUSR_DELL340'.
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: Login failed for
user 'DELL340\IUSR_DELL340'.

Source Error:

Line 48: public void FillDataSet(myDataSet dSet)
Line 49: {
Line 50: sqlDataAdapter1.Fill(dSet);
Line 51: }
Line 52:

Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50

Stack Trace:

[SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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) +38
MyWebForm.Component1.FillDataSet(myDataSet dSet) in
c:\inetpub\wwwroot\mywebform\component1.cs:50
MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

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


Nov 18 '05 #5
Karl,

Can't I use the Integrated Security? It would seem that this is the easiest
since I don't have to bother with an account name/password.

When I test the data adapter access to the data base the test is successful.

I did notice however that when I select the sqlDataAdapter in the
Component1.cs [Design] page and then Tools>Connect to Database..., there
seems to be no permanent selection in the Data Link Properties. I always
have to select the button "Use Windows NT Integrated security."

When the dialog box is shown, the "Use a specific user name and password is
selected" and all the text fields are blank! If I change the radio button
selection to the "Use Windows NT Integrated security", the "Test Connection
" button still succeeds even though the text fields are empty.

Regards,

Ed


"Karl" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in
message news:%2****************@TK2MSFTNGP15.phx.gbl...
Your SQLConnection string has the parameter and value "Integrated
Security=SSPI;" in it. This is telling the connection object to use
integrated windows account. in other words whoever the user running the
aspx page will be the account used to log intothe database. When you have
inpersonation off (which is what it was at first), each page request is
handled by the ASPNet account which is why you are seeing DELL340\ASPNet

when you turn inpersonation on, each page request is the actual user on
the
domain requesting the page (which is why the account changes, the page is
now being requested as someone else).

My guess is you don't want to use Integrated Security...and you want to
use
SQL Accounts...to do so, you want your connection string to look something
like:

"Provider=sqloledb;Data Source=DATABASE_SERVER;Initial
Catalog=DATABASE_NAME;User Id=USERID;Password=PASSWORD;"

for example

"Provider=sqloledb;Data Source=localhost;Initial Catalog=forums;User
Id=sa;Password=mySaPassword;"
karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:uo**************@TK2MSFTNGP10.phx.gbl...
I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web
Application Using a Third-Party Business Object). When I first create
the
SQL connection in VS.NET 2003, I test the connection and everything works
fine. However, when I attempt to run the first stage of the app (the

bound
datagrid), I receive an error stating:

login failed for user 'DELL340\ASPNET'.

There was another post in this newsgroup on this subject (Difficulty
connecting to SQL Server 2000:2002-03-04) that suggested placing the
line:

<identity impersonate="true" />

in the Web.config file but when I run the app again, there is the

following
failure message:

Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

What can I do to fix the problem?

I appended the full text of the second error message. System is Windows

XP,
SP2. MSDE server.

Ed.
--
Edward E.L. Mitchell
Web: www.racesail.org
Phone: (508)771-0806
500 Ocean St., Unit 134,
Hyannis, MA 02601

Server Error in '/MyWebForm' Application.
--------------------------------------------------------------------------

------

Login failed for user 'DELL340\IUSR_DELL340'.
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: Login failed for

user
'DELL340\IUSR_DELL340'.

Source Error:

Line 48: public void FillDataSet(myDataSet dSet)
Line 49: {
Line 50: sqlDataAdapter1.Fill(dSet);
Line 51: }
Line 52:

Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50

Stack Trace:

[SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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) +38
MyWebForm.Component1.FillDataSet(myDataSet dSet) in
c:\inetpub\wwwroot\mywebform\component1.cs:50
MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

--------------------------------------------------------------------------

------
Version Information: Microsoft .NET Framework Version:1.1.4322.573;

ASP.NET
Version:1.1.4322.573


Nov 18 '05 #6
Edward Mitchell wrote:
Greg,

I'm a neophyte here, just trying to get a first ASP.NET test program to
work.
I feel your pain. :^)
I am running IIS on my XP workstation. No one else needs to get at
it for now.

It seems that I shouldn't be using <identity impersonate="true">.
Not needed here.
All I want to do at the moment is to run the test under my account which should be
the "integrated windows account" since I have admistrator privileges.

You could connect as yourself and it would work since you are
administrator, but this is NOT the recommended approach. Normally you
connect to a database as a single user, not just anybody who happens to
run your web page. This allows connection pooling to do its thing. (Of
course, this also may not be the correct approach depending on the
secuirty design of your database.)
I don't have SQL Server, just the MSDE engine that I can use to test. The
"select @@version" from osql shows Desktop Engine 5.1; SP2 though after "SQL
Server 2000 - 8.00.760."

You know you can buy the Developer Edition of SQL 2000 for under $50.
This gives you everything in Enterpise verion of SQL, but only with a
for development only license.

There is a user account on the machine "ASP.NET MachineA..." that is
described as a limited account, password protected although I didn't create
is as far as I know! I can't find an ASPNET account.
You won't see the ASPNET user acount in the sugar coated Users icon in
control panel. It is a "hidden" account by default. If your
right-click My Computer->Manage->Local Users & Groups you will see the
ASPNET here.

When anonymous access is turned on for the virtaul directory in IIS, and
your access an .aspx page, it will run under the ASPNET user. This
account (ASPNET) is auto-created when you installed DOTNET. Its
password is also auto-generated, so don't change it or things will break.
How would I give it rights under the SQL Enterprise Manager. Is this part of
MSDE?
As you probably realized, MSDE does NOT come with a GUI. Hence, no
Enterprise Manager. Sure, you can do what you need using the command
window and OSQL, but you probably don't want to go there if you're just
getting started. (Or even after you obtain your MCDBA!) If you plan on
doing anything useful with SQL at all, you need to get EM.

Regards,

Ed


Leave the virtual directory set to Anonymous (this is the default,
unless you changed it).

I see in another post you are using the wizards, which fortunately for
me (unfortunate for you) I've never used. I do everything manually.
Which makes things so much more understandable, as far as what is
happening, but I digress...

When you use either "Integrated
Security=SSPI;" in your connection string OR "Trusted_Connection=true;"
(they are interchangeable) you will connect to your MSDE database as the
built in ASPNET user account (unless your also have identity
impersonate="true", in which case you will connect as the "actual user
on the domain requesting the page" credits to Karl).

The real issue you are having is how to give the ASPNET user access to
your MSDE instance and the specific database within that MSDE instance.

I would suggest (since this is just for learning), adding the ASPNET
account into your local adminstrators group on your PC. Any user in
that group is also an administrator for the SQL/MSDE server on the
machine. This is of course highly unsecure, but will still allow you to
use Integrated Security and not have to specify a SQL username/password
(which may not even work if your instance of MSDE is not in mixed-mode,
which I don't think it is by default...) or to connect to your web page
as yourself.
HTH,
Greg

Nov 18 '05 #7
As others have mentioned, it's better to avoid Integrated Security. There
are a number of reasons for this, such as the performance gain you get from
performance pooling. Either way you'll need to "bother" about an account.
Whether it's an SQL Account or an windows account (if anonymous is on, else
one for every account in your domain).

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
Karl,

Can't I use the Integrated Security? It would seem that this is the easiest since I don't have to bother with an account name/password.

When I test the data adapter access to the data base the test is successful.
I did notice however that when I select the sqlDataAdapter in the
Component1.cs [Design] page and then Tools>Connect to Database..., there
seems to be no permanent selection in the Data Link Properties. I always
have to select the button "Use Windows NT Integrated security."

When the dialog box is shown, the "Use a specific user name and password is selected" and all the text fields are blank! If I change the radio button
selection to the "Use Windows NT Integrated security", the "Test Connection " button still succeeds even though the text fields are empty.

Regards,

Ed


"Karl" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in
message news:%2****************@TK2MSFTNGP15.phx.gbl...
Your SQLConnection string has the parameter and value "Integrated
Security=SSPI;" in it. This is telling the connection object to use
integrated windows account. in other words whoever the user running the
aspx page will be the account used to log intothe database. When you have inpersonation off (which is what it was at first), each page request is
handled by the ASPNet account which is why you are seeing DELL340\ASPNet

when you turn inpersonation on, each page request is the actual user on
the
domain requesting the page (which is why the account changes, the page is now being requested as someone else).

My guess is you don't want to use Integrated Security...and you want to
use
SQL Accounts...to do so, you want your connection string to look something like:

"Provider=sqloledb;Data Source=DATABASE_SERVER;Initial
Catalog=DATABASE_NAME;User Id=USERID;Password=PASSWORD;"

for example

"Provider=sqloledb;Data Source=localhost;Initial Catalog=forums;User
Id=sa;Password=mySaPassword;"
karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:uo**************@TK2MSFTNGP10.phx.gbl...
I have a problem that involves the error I receive when attempting to
complete the asp.net web application example (Walkthrough: Creating a Web Application Using a Third-Party Business Object). When I first create
the
SQL connection in VS.NET 2003, I test the connection and everything works fine. However, when I attempt to run the first stage of the app (the

bound
datagrid), I receive an error stating:

login failed for user 'DELL340\ASPNET'.

There was another post in this newsgroup on this subject (Difficulty
connecting to SQL Server 2000:2002-03-04) that suggested placing the
line:

<identity impersonate="true" />

in the Web.config file but when I run the app again, there is the

following
failure message:

Login failed for user 'DELL340\IUSR_DELL340'.

How come the user changed and where did the user name come from?

What can I do to fix the problem?

I appended the full text of the second error message. System is Windows
XP,
SP2. MSDE server.

Ed.
--
Edward E.L. Mitchell
Web: www.racesail.org
Phone: (508)771-0806
500 Ocean St., Unit 134,
Hyannis, MA 02601

Server Error in '/MyWebForm' Application.
-------------------------------------------------------------------------

- ------

Login failed for user 'DELL340\IUSR_DELL340'.
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: Login failed for

user
'DELL340\IUSR_DELL340'.

Source Error:

Line 48: public void FillDataSet(myDataSet dSet)
Line 49: {
Line 50: sqlDataAdapter1.Fill(dSet);
Line 51: }
Line 52:

Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50

Stack Trace:

[SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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) +38
MyWebForm.Component1.FillDataSet(myDataSet dSet) in
c:\inetpub\wwwroot\mywebform\component1.cs:50
MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
-------------------------------------------------------------------------

- ------
Version Information: Microsoft .NET Framework Version:1.1.4322.573;

ASP.NET
Version:1.1.4322.573



Nov 18 '05 #8
Karl,

When you say avoid "Integrated Security"...

Do you mean avoid "Integrated Security=SSPI;" / "Trusted_Connection=true;"
???

OR

avoid <identity impersonate="true"> ???

I would assume you would mean the <identity impersonate="true">, but the
terminology is confusing me a bit.

Seems to be me, the recommended approach is to use anonymous access with
Trusted_Connection=true and connect to SQL as the ASPNET user. Do you
concur, or am I missing something?

Greg

"Karl" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in
message news:O3**************@TK2MSFTNGP15.phx.gbl...
As others have mentioned, it's better to avoid Integrated Security. There
are a number of reasons for this, such as the performance gain you get
from
performance pooling. Either way you'll need to "bother" about an account.
Whether it's an SQL Account or an windows account (if anonymous is on,
else
one for every account in your domain).

Karl

Nov 18 '05 #9
Greg, I'm very tired so I'm not 100%...I meant Integrated Security in the
connection string. I would say the vaste majority of people are using an
SQL account and not Integrated Security. I would also say the vaste
majority of people don't use impersonation. Impersonation is only really
handy in intranets where users are all on the same domain....or workgroup or
whatever they call then (not a network guy).

Back to the connection string. I realize that SSPI is what microsoft
recommends but I just don't think that's what most people are using. This
might make no sense, but isn't the ASPNET account local to the webserver?
Would it be able to access an SQL database on a different server even if
they were on the same domain? other than that (which is obviously a deal
breaker), not sure why I'm so anti-integrated security....

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:en*************@tk2msftngp13.phx.gbl...
Karl,

When you say avoid "Integrated Security"...

Do you mean avoid "Integrated Security=SSPI;" / "Trusted_Connection=true;"
???

OR

avoid <identity impersonate="true"> ???

I would assume you would mean the <identity impersonate="true">, but the
terminology is confusing me a bit.

Seems to be me, the recommended approach is to use anonymous access with
Trusted_Connection=true and connect to SQL as the ASPNET user. Do you
concur, or am I missing something?

Greg

"Karl" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in
message news:O3**************@TK2MSFTNGP15.phx.gbl...
As others have mentioned, it's better to avoid Integrated Security. There are a number of reasons for this, such as the performance gain you get
from
performance pooling. Either way you'll need to "bother" about an account. Whether it's an SQL Account or an windows account (if anonymous is on,
else
one for every account in your domain).

Karl


Nov 18 '05 #10
comments inline...

"Karl" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in
message news:O2**************@TK2MSFTNGP15.phx.gbl...
Greg, I'm very tired so I'm not 100%...I meant Integrated Security in the
connection string. I would say the vaste majority of people are using an
SQL account and not Integrated Security.
I am not sure what most do, but I've always read to use Integrated Security
w/ the ASPNET account
I would also say the vaste majority of people don't use impersonation.
Impersonation is only really
handy in intranets where users are all on the same domain....or workgroup
or
whatever they call then (not a network guy).
Yes, I agree with that. Intranet is what we call them in these parts. :)

Back to the connection string. I realize that SSPI is what microsoft
recommends but I just don't think that's what most people are using. This
might make no sense, but isn't the ASPNET account local to the webserver?
Would it be able to access an SQL database on a different server even if
they were on the same domain? other than that (which is obviously a deal
breaker), not sure why I'm so anti-integrated security....


I had this discussesion a few weeks ago with somebody else here who thought
the same.

The ASPNET user is a local account on the webserver. You are correct that
this will be an issue when trying to connect as that user to SQL on another
server in same domain.

Two solutions:
#1 Change machine.config's <processModel> so that it doesn't use local
ASPNET user, but instead uses a domain account. If you do this, you must
give this domain user the equivalent rights as the ASPNET user. (Read PITA)

#2 Change machine.config's <processModel>, but this time keep ASPNET user
(ie, user="machine") but change password from "autogenerate" to a known
password. Reset ASPNET user's password to that known password.
Now on your SQL server, create a local account named (wait for it...)
ASPNET. Set the password to the same as on web server. Believe or not,
this WILL work. It is referred to as Pass-through authentication. Now
there is some issue with the "number of hops", but there my expertise ends,
cause I also am not a network guy. :^)

In fact, method #2 is recommended by MS. Check out: "Building Secure
ASP.NET Applications" chp. 12 p299
or on the web

http://msdn.microsoft.com/library/de...SecNetch12.asp

under: Using the ASP.NET process identity

It is late here also, time to call it quits.

g'night!
Greg
Nov 18 '05 #11
Thanks greg, hopefully the information will be informative to others as
well.

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:up****************@TK2MSFTNGP09.phx.gbl...
comments inline...

"Karl" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in
message news:O2**************@TK2MSFTNGP15.phx.gbl...
Greg, I'm very tired so I'm not 100%...I meant Integrated Security in the connection string. I would say the vaste majority of people are using an SQL account and not Integrated Security.
I am not sure what most do, but I've always read to use Integrated

Security w/ the ASPNET account
I would also say the vaste majority of people don't use impersonation.
Impersonation is only really
handy in intranets where users are all on the same domain....or workgroup or
whatever they call then (not a network guy).
Yes, I agree with that. Intranet is what we call them in these parts. :)

Back to the connection string. I realize that SSPI is what microsoft
recommends but I just don't think that's what most people are using. This might make no sense, but isn't the ASPNET account local to the webserver? Would it be able to access an SQL database on a different server even if
they were on the same domain? other than that (which is obviously a deal breaker), not sure why I'm so anti-integrated security....


I had this discussesion a few weeks ago with somebody else here who

thought the same.

The ASPNET user is a local account on the webserver. You are correct that
this will be an issue when trying to connect as that user to SQL on another server in same domain.

Two solutions:
#1 Change machine.config's <processModel> so that it doesn't use local
ASPNET user, but instead uses a domain account. If you do this, you must
give this domain user the equivalent rights as the ASPNET user. (Read PITA)
#2 Change machine.config's <processModel>, but this time keep ASPNET user
(ie, user="machine") but change password from "autogenerate" to a known
password. Reset ASPNET user's password to that known password.
Now on your SQL server, create a local account named (wait for it...)
ASPNET. Set the password to the same as on web server. Believe or not,
this WILL work. It is referred to as Pass-through authentication. Now
there is some issue with the "number of hops", but there my expertise ends, cause I also am not a network guy. :^)

In fact, method #2 is recommended by MS. Check out: "Building Secure
ASP.NET Applications" chp. 12 p299
or on the web

http://msdn.microsoft.com/library/de...SecNetch12.asp
under: Using the ASP.NET process identity

It is late here also, time to call it quits.

g'night!
Greg

Nov 18 '05 #12
Greg,

Thanks for the feedback. I put ASPNET into the Administrator's group and my
web page was built. I guess this isn't the best solution for the long term
but at least, I can continue with the learning and the tutorial!

I didn't really want to become a SysAdmin but it looks like you have to know
this stuff to interface with ADO. My goal is to have an admin web page that
could create a couple of tables and a simple users page that could populate
these!

Thanks also for the info that I can get the SQL 2000 for fifty bucks. A
small price to pay if I can get some real tools. Though maybe there's too
much info in the full system:(

Regards,

Ed

"Greg Burns" <greg_burns@DONT_SPAM_ME_homtail.com> wrote in message
news:uf**************@TK2MSFTNGP11.phx.gbl...
Edward Mitchell wrote:
Greg,

I'm a neophyte here, just trying to get a first ASP.NET test program to
work.


I feel your pain. :^)
I am running IIS on my XP workstation. No one else needs to get at it
for now.

It seems that I shouldn't be using <identity impersonate="true">.


Not needed here.
All I want to do at the moment is to run the test under my account which
should be the "integrated windows account" since I have admistrator
privileges.


You could connect as yourself and it would work since you are
administrator, but this is NOT the recommended approach. Normally you
connect to a database as a single user, not just anybody who happens to
run your web page. This allows connection pooling to do its thing. (Of
course, this also may not be the correct approach depending on the
secuirty design of your database.)
I don't have SQL Server, just the MSDE engine that I can use to test.
The "select @@version" from osql shows Desktop Engine 5.1; SP2 though
after "SQL Server 2000 - 8.00.760."


You know you can buy the Developer Edition of SQL 2000 for under $50. This
gives you everything in Enterpise verion of SQL, but only with a for
development only license.

There is a user account on the machine "ASP.NET MachineA..." that is
described as a limited account, password protected although I didn't
create is as far as I know! I can't find an ASPNET account.


You won't see the ASPNET user acount in the sugar coated Users icon in
control panel. It is a "hidden" account by default. If your right-click
My Computer->Manage->Local Users & Groups you will see the ASPNET here.

When anonymous access is turned on for the virtaul directory in IIS, and
your access an .aspx page, it will run under the ASPNET user. This
account (ASPNET) is auto-created when you installed DOTNET. Its password
is also auto-generated, so don't change it or things will break.
How would I give it rights under the SQL Enterprise Manager. Is this part
of MSDE?


As you probably realized, MSDE does NOT come with a GUI. Hence, no
Enterprise Manager. Sure, you can do what you need using the command
window and OSQL, but you probably don't want to go there if you're just
getting started. (Or even after you obtain your MCDBA!) If you plan on
doing anything useful with SQL at all, you need to get EM.

Regards,

Ed


Leave the virtual directory set to Anonymous (this is the default, unless
you changed it).

I see in another post you are using the wizards, which fortunately for me
(unfortunate for you) I've never used. I do everything manually. Which
makes things so much more understandable, as far as what is happening, but
I digress...

When you use either "Integrated
Security=SSPI;" in your connection string OR "Trusted_Connection=true;"
(they are interchangeable) you will connect to your MSDE database as the
built in ASPNET user account (unless your also have identity
impersonate="true", in which case you will connect as the "actual user on
the domain requesting the page" credits to Karl).

The real issue you are having is how to give the ASPNET user access to
your MSDE instance and the specific database within that MSDE instance.

I would suggest (since this is just for learning), adding the ASPNET
account into your local adminstrators group on your PC. Any user in that
group is also an administrator for the SQL/MSDE server on the machine.
This is of course highly unsecure, but will still allow you to use
Integrated Security and not have to specify a SQL username/password (which
may not even work if your instance of MSDE is not in mixed-mode, which I
don't think it is by default...) or to connect to your web page as
yourself.
HTH,
Greg

Nov 18 '05 #13
The next version of MSDE (SQL Server Express 2005) will have a GUI tool that
comes with it. (I don't believe the beta that is out has it yet though)

Gerg

"Edward Mitchell" <em*******@nospam.ieee.org> wrote in message
news:uA**************@TK2MSFTNGP15.phx.gbl...
Greg,

Thanks for the feedback. I put ASPNET into the Administrator's group and
my web page was built. I guess this isn't the best solution for the long
term but at least, I can continue with the learning and the tutorial!

I didn't really want to become a SysAdmin but it looks like you have to
know this stuff to interface with ADO. My goal is to have an admin web
page that could create a couple of tables and a simple users page that
could populate these!

Thanks also for the info that I can get the SQL 2000 for fifty bucks. A
small price to pay if I can get some real tools. Though maybe there's
too much info in the full system:(

Regards,

Ed

"Greg Burns" <greg_burns@DONT_SPAM_ME_homtail.com> wrote in message
news:uf**************@TK2MSFTNGP11.phx.gbl...
Edward Mitchell wrote:
Greg,

I'm a neophyte here, just trying to get a first ASP.NET test program to
work.


I feel your pain. :^)
I am running IIS on my XP workstation. No one else needs to get at it
for now.

It seems that I shouldn't be using <identity impersonate="true">.


Not needed here.
All I want to do at the moment is to run the test under my account which
should be the "integrated windows account" since I have admistrator
privileges.


You could connect as yourself and it would work since you are
administrator, but this is NOT the recommended approach. Normally you
connect to a database as a single user, not just anybody who happens to
run your web page. This allows connection pooling to do its thing. (Of
course, this also may not be the correct approach depending on the
secuirty design of your database.)
I don't have SQL Server, just the MSDE engine that I can use to test.
The "select @@version" from osql shows Desktop Engine 5.1; SP2 though
after "SQL Server 2000 - 8.00.760."


You know you can buy the Developer Edition of SQL 2000 for under $50.
This gives you everything in Enterpise verion of SQL, but only with a for
development only license.

There is a user account on the machine "ASP.NET MachineA..." that is
described as a limited account, password protected although I didn't
create is as far as I know! I can't find an ASPNET account.


You won't see the ASPNET user acount in the sugar coated Users icon in
control panel. It is a "hidden" account by default. If your right-click
My Computer->Manage->Local Users & Groups you will see the ASPNET here.

When anonymous access is turned on for the virtaul directory in IIS, and
your access an .aspx page, it will run under the ASPNET user. This
account (ASPNET) is auto-created when you installed DOTNET. Its password
is also auto-generated, so don't change it or things will break.
How would I give it rights under the SQL Enterprise Manager. Is this
part of MSDE?


As you probably realized, MSDE does NOT come with a GUI. Hence, no
Enterprise Manager. Sure, you can do what you need using the command
window and OSQL, but you probably don't want to go there if you're just
getting started. (Or even after you obtain your MCDBA!) If you plan on
doing anything useful with SQL at all, you need to get EM.

Regards,

Ed


Leave the virtual directory set to Anonymous (this is the default, unless
you changed it).

I see in another post you are using the wizards, which fortunately for me
(unfortunate for you) I've never used. I do everything manually. Which
makes things so much more understandable, as far as what is happening,
but I digress...

When you use either "Integrated
Security=SSPI;" in your connection string OR "Trusted_Connection=true;"
(they are interchangeable) you will connect to your MSDE database as the
built in ASPNET user account (unless your also have identity
impersonate="true", in which case you will connect as the "actual user on
the domain requesting the page" credits to Karl).

The real issue you are having is how to give the ASPNET user access to
your MSDE instance and the specific database within that MSDE instance.

I would suggest (since this is just for learning), adding the ASPNET
account into your local adminstrators group on your PC. Any user in that
group is also an administrator for the SQL/MSDE server on the machine.
This is of course highly unsecure, but will still allow you to use
Integrated Security and not have to specify a SQL username/password
(which may not even work if your instance of MSDE is not in mixed-mode,
which I don't think it is by default...) or to connect to your web page
as yourself.
HTH,
Greg


Nov 18 '05 #14

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Andrew | last post by:
(I've made two previous attempts to post this using MSDN's web interface, but it doesn't seem to be working. I've switched to a newsreader, but I apologize for the duplication if the other posts...
5
by: VinnieT | last post by:
I have a load balanced system that consists of 3 production servers. There are about 20 different applications that are used on these boxes. One of my applications in particular is used more than...
6
by: Javier Cortés Cortés | last post by:
i am getting this error when i am trying to access any file(with the ext. aspx) from my remote server. the error is : Server Error in '/' Application....
1
by: Keith | last post by:
All, I have been told this is an ASP.NET issue and not an IIS issue, so I am posting this here. I have a problem with ASP.NET returning an HTTP 500 error when trying to run ASPX pages on...
9
by: Steve Buster | last post by:
All right, I have read every forum, newsgroup etc about this issue and no one seems to know how to fix it. I am getting a "Server Application Unavailable" exception running my .NET 1.1...
4
by: tommy | last post by:
hello everbody, i write a little asp-application with forms-authentication. i copy my aspx-files with web.config to my webspace and i get the error above... i tried to set the...
17
by: Jon B | last post by:
Hi All! I have a ASP.NET 2.0 site that works on the Windows 2000 Server. However, when I tried to view this site on my local Windows XP machine, I get "Server Unavailable". If I switch the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.