Inquiridor
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

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:20Moderador -
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 -
sexta-feira, 14 de março de 2008 12:02