Re: Problem Connecting to SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ignacio Machin \( .NET/ C# MVP \) ("Ignacio)
Date: 05/24/04 

Date: Mon, 24 May 2004 13:41:03 -0400

Hi Aaron,

 It seems that you are using integrated auth. try to change it to SQL auth.

Cheers, 

-- 
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Aaron Bellante" <nope@go.away.com> wrote in message
news:MPG.1b1bd1224b367e32989680@news.microsoft.com...
> I have been creating some pages that pull info from an SQL database
> located on my computer.  I have an identical DB located on the
> production machine.  The page runs fine on my PC (XP Pro), but when I
> move everything over to the target machine (2003 Server) I get this
> error:
>
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
> 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 'NT AUTHORITY\NETWORK SERVICE'.
>
> Source Error:
>
> An unhandled exception was generated during the execution of the current
> web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
>
> Stack Trace:
>
>
> [SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
>    System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction)
>    System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection
> (SqlConnectionString options, Boolean& isInTransaction)
>    System.Data.SqlClient.SqlConnection.Open()
>    System.Web.SessionState.SqlStateConnection..ctor(String
> sqlconnectionstring)
>
> [HttpException (0x80004005): Unable to connect to SQL Server session
> database.]
>    System.Web.SessionState.SqlStateConnection..ctor(String
> sqlconnectionstring)
>    System.Web.SessionState.SqlStateClientManager.GetConnection(Boolean&
> usePooling)
>    System.Web.SessionState.SqlStateClientManager.GetExclusive(String id)
>    System.Web.SessionState.StateClientManager.BeginGetExclusiveSync
> (String id, AsyncCallback cb, Object state)
>
> System.Web.SessionState.SqlStateClientManager.System.Web.SessionState.IS
> tateClientManager.BeginGetExclusive(String id, AsyncCallback cb, Object
> state)
>    System.Web.SessionState.SessionStateModule.GetSessionStateItem()
>    System.Web.SessionState.SessionStateModule.BeginAcquireState(Object
> source, EventArgs e, AsyncCallback cb, Object extraData)
>
> System.Web.AsyncEventExecutionStep.System.Web.HttpApplication+IExecution
> Step.Execute()
>    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +173
>
>
> Can someone help me?  I am obviously fairly new to this.  I really can't
> figure out what I am missing.
>
> Thanks
> -- 
> -- Aaron

Relevant Pages

  • RE: Express refuses to install
    ... Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup ... Action "LaunchPatchedBootstrapAction" will be skipped due to the following ... Action "InvokeSqlSetupDllAction" threw an exception during execution. ... Aborting queue processing as nested installer has completed ...
    (microsoft.public.sqlserver.setup)
  • Re: App_data - ASPNETDB.MDF
    ... If your hosting provider doesn't support Sql Express version, ... retrieving the user's local application data path. ... Anunhandled exception occurred during the execution of the ... Please make sure theuser has a local user profile ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0
    ... SQL CE QP is not going to be able to optimize that stmt. ... >I am reliably reproducing the ExceptionCode 0xc0000005 native exception ... > SQL CE 2.0 database file ...
    (microsoft.public.sqlserver.ce)
  • Re: SQLCommandparameters - viewing prepared statement
    ... corresponding value (we actually often use different levels of logging so at ... throw back Print Statements as well as Sql Error msgs with a Severity level ... If the query threw an exception the evaluated ... the exception that says "incorrect ...
    (microsoft.public.dotnet.framework.adonet)
  • Sql Reporting Serviced - > ASP.NET ACCESS DENIED!
    ... Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000 ... Exception Details: System.UnauthorizedAccessException: Access to the path ... granting access rights to the resource to the ASP.NET request identity. ... System.IO.Directory.InternalGetFileDirectoryNames(String fullPath, String ...
    (microsoft.public.dotnet.framework.aspnet.security)