Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > SQLConnection Help

Reply
Thread Tools

SQLConnection Help

 
 
Claudiu Tescu
Guest
Posts: n/a
 
      03-31-2005
I make an project in ASP that use SQL Server that is on the same computer at
compilation time I have the problem :
Login failed for user 'NOSTRU\IUSR_NOSTRU'.
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
'NOSTRU\IUSR_NOSTRU'.

Source Error:


Line 31: // if (sqlConnection1.State==ConnectionState.Open)
Line 32: // {
Line 33: sqlDataAdapter1.Fill(dataSet11);
Line 34: this.DataGrid1.DataBind();
Line 35: // }


Source File: c:\inetpub\wwwroot\Servici\WebForm1.aspx.cs Line: 33

Stack Trace:


[SqlException: Login failed for user 'NOSTRU\IUSR_NOSTRU'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +474
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
Servici.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\Servici\WebForm1.aspx.cs:33
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750





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

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


How I can resolve this problem ?


 
Reply With Quote
 
 
 
 
Brock Allen
Guest
Posts: n/a
 
      03-31-2005
This was discussed recently:

http://groups-beta.google.com/group/...72794fbca0d600

-Brock
DevelopMentor
http://staff.develop.com/ballen



> I make an project in ASP that use SQL Server that is on the same
> computer at
> compilation time I have the problem :
> Login failed for user 'NOSTRU\IUSR_NOSTRU'.
> 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 'NOSTRU\IUSR_NOSTRU'.
>
> Source Error:
>
> Line 31: // if (sqlConnection1.State==ConnectionState.Open)
> Line 32: // {
> Line 33: sqlDataAdapter1.Fill(dataSet11);
> Line 34: this.DataGrid1.DataBind();
> Line 35: // }
> Source File: c:\inetpub\wwwroot\Servici\WebForm1.aspx.cs Line: 33
>
> Stack Trace:
>
> [SqlException: Login failed for user 'NOSTRU\IUSR_NOSTRU'.]
> System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
> isInTransaction) +474
>
> System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(Sql
> ConnectionString
> 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
> Servici.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\Servici\WebForm1.aspx.cs:33
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750
> ----------------------------------------------------------------------
> ----------
>
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
>
> How I can resolve this problem ?
>




 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help -- SQLConnection Problem Michael D Murphy ASP .Net 19 09-05-2005 11:57 PM
Can't open a SqlConnection Mark ASP .Net 3 07-19-2005 10:23 AM
SQLDataAdapter lost (along with SQLConnection) - HELP!!! Randy Smith ASP .Net 3 05-05-2005 12:10 AM
SQLConnection event catch, please help Amar ASP .Net 3 06-11-2004 07:47 AM
Re: does an Sqlconnection object get shared at application level? Nick ASP .Net 0 06-27-2003 10:35 AM



Advertisments