locked
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. RRS feed

  • Pergunta

  • Caros Amigos,

    Ao tentar rodar uma aplicação para Web ( .ASPX) uma mensagem de erro é apresentada, alguma dica?

     

    Servidor Win2003

    Sql 2000

    ASP.NET vr 2.0

     

    Obrigado,

     

    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 (0x80131904): Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735011
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
       System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
       System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
       System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
       System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
       System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
       System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
       System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
       System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
       System.Data.SqlClient.SqlConnection.Open() +111
       GeneXus.Data.MssqlConnectionWrapper.Open() +12
       GeneXus.Data.ADO.GxConnection.Open() +212
     
    [GxADODataException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
       GeneXus.Utils.GXUtil.UserId(String key, IGxContext cntxt, String id) +246
       GeneXus.Programs.hm0000.E125K2() +327
       GeneXus.Programs.hm0000.STRUP5K0() +32
       GeneXus.Programs.hm0000.START5K2() +493
       GeneXus.Programs.hm0000.webExecute() +133
       GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +132
     
    [Exception: GXApplication exception]
       GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +202
       System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +317
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65
      

    segunda-feira, 11 de fevereiro de 2008 00:11

Todas as Respostas

  • Eliesio,

     

    Verifique como esta a configuração de acesso e segurança para esta aplicação no IIS, pois a mensagem de erro esta alertando sobre falha de conexão através do usuários 'NT AUTHORITY\NETWORK SERVICE'.

    segunda-feira, 11 de fevereiro de 2008 11:20
    Moderador
  • Eliesio, verifique na sua ConnectionString se está como Windows Authentication, pois me parece que sim, e como por padrão quem executa um código .Net no IIS é o 'NT AUTHORITY\NETWORK SERVICE', ele quem está tentando fazer login no seu servidor SQL Server.

     

    O ideal seria você definir um usuário e senha.

     

     

    Abraços,

     

    segunda-feira, 11 de fevereiro de 2008 17:59
  • Crie uma conta de domínio, dê as devidas permissões no SQL e configure o serviço Asp.net para executar sobre o contexto dessa conta.

    quinta-feira, 28 de fevereiro de 2008 20:45
  •  

    Conseguiu Eliésio?
    sexta-feira, 14 de março de 2008 12:02