SQLConnection Help



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.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) +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 ?


.



Relevant Pages

  • Very strange SQL connection problem
    ... System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ... System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... Here is some of my connection code: ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ... >> on our test web server, There is only one oracle home on the test server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Server Error in /MyWebForm Application
    ... SQL connection in VS.NET 2003, I test the connection and everything works ... MSDE server. ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Deploying Web Service to my hosting services server
    ... It means that neither ODBC nor ... > connection, ConnectionState& originalState) ... > startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Very strange SQL connection problem
    ... Try creating a *new instance* of SqlConnection and then open and after the ... > connection string again and got the second exception after ... > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.adonet)