Error de servidor en la aplicación '/KBtest.NetEnvironment'.

558 views
Skip to first unread message

Gabriel Medina

unread,
Jun 11, 2018, 9:19:40 AM6/11/18
to ggg (GeneXus Google Groups)







Error de servidor en la aplicación '/KBtest.NetEnvironment'.

Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.

Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código. 

Detalles de la excepción: System.Data.SqlClient.SqlException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.

Error de código fuente: 

Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.

Seguimiento de la pila: 

[SqlException (0x80131904): Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) +1431
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +1085
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +70
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +964
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +109
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1529
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +156
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +258
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +312
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +202
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +413
   System.Data.SqlClient.SqlConnection.Open() +128
   GeneXus.Data.MssqlConnectionWrapper.Open() +29
   GeneXus.Data.ADO.GxConnection.Open() +591

[GxADODataException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.ADO.GxConnection.Open() +1203
   GeneXus.Data.ADO.GxConnectionManager.IncOpenHandlesImpl(GxConnection con) +30
   GeneXus.Data.ADO.GxConnectionManager.IncOpenHandles(Int32 handle, String dataSource) +65
   GeneXus.Data.GxSqlCursorDataReader.LoadFirstBlock() +240
   GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +478

[GxADODataException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +737
   GeneXus.Data.GxSqlServer.GetDataReader(IGxConnectionManager connManager, IGxConnection con, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt) +280
   GeneXus.Data.ADO.GxCommand.ExecuteReader() +720

[GxADODataException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.ADO.GxCommand.ExecuteReader() +886
   GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +129

[GxADODataException: Type:GeneXus.Data.GxADODataException.DBMS Error Code:4060.Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +793
   GeneXus.Data.NTier.ADO.ForEachCursor.execute() +121
   GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch) +775
   GeneXus.Programs.people.GetKey011() +107
   GeneXus.Programs.people.btn_enter() +31
   GeneXus.Programs.people.Process() +600
   GeneXus.Programs.people.UserMainFullajax() +32

[TargetInvocationException: Se produjo una excepción en el destino de la invocación.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +260
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +142
   System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) +774
   GeneXus.Http.DynAjaxEvent.doInvoke(Object[] MethodParms) +180
   GeneXus.Http.DynAjaxEvent.invoke(String JsonMessage, GXHttpHandler targetObj) +296
   GeneXus.Http.GXHttpHandler.webAjaxEvent() +230
   GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +900

[Exception: GXApplication exception]
   GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +1169
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +866
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +213
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +91


Información de versión: Versión de Microsoft .NET Framework:4.0.30319; Versión ASP.NET:4.7.3056.0

Error de servidor en la aplicación '/KBtest.NetEnvironment'.

Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.

Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código. 

Detalles de la excepción: System.Data.SqlClient.SqlException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.

Error de código fuente: 

Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.

Seguimiento de la pila: 

[SqlException (0x80131904): Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +345
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +156
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +258
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +312
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +202
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +413
   System.Data.SqlClient.SqlConnection.Open() +128
   GeneXus.Data.MssqlConnectionWrapper.Open() +29
   GeneXus.Data.ADO.GxConnection.Open() +591

[GxADODataException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.ADO.GxConnection.Open() +1203
   GeneXus.Data.ADO.GxConnectionManager.IncOpenHandlesImpl(GxConnection con) +30
   GeneXus.Data.ADO.GxConnectionManager.IncOpenHandles(Int32 handle, String dataSource) +65
   GeneXus.Data.GxSqlCursorDataReader.LoadFirstBlock() +240
   GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +478

[GxADODataException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +737
   GeneXus.Data.GxSqlServer.GetDataReader(IGxConnectionManager connManager, IGxConnection con, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt) +280
   GeneXus.Data.ADO.GxCommand.ExecuteReader() +720

[GxADODataException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.ADO.GxCommand.ExecuteReader() +886
   GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +129

[GxADODataException: Type:GeneXus.Data.GxADODataException.DBMS Error Code:4060.Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.]
   GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +793
   GeneXus.Data.NTier.ADO.ForEachCursor.execute() +121
   GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch) +775
   GeneXus.Programs.people.GetKey011() +107
   GeneXus.Programs.people.btn_enter() +31
   GeneXus.Programs.people.Process() +600
   GeneXus.Programs.people.UserMainFullajax() +32

[TargetInvocationException: Se produjo una excepción en el destino de la invocación.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +260
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +142
   System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) +774
   GeneXus.Http.DynAjaxEvent.doInvoke(Object[] MethodParms) +180
   GeneXus.Http.DynAjaxEvent.invoke(String JsonMessage, GXHttpHandler targetObj) +296
   GeneXus.Http.GXHttpHandler.webAjaxEvent() +230
   GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +900

[Exception: GXApplication exception]
   GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +1169
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +866
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +213
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +91


Información de versión: Versión de Microsoft .NET Framework:4.0.30319; Versión ASP.NET:4.7.3056.0

--
Saludos,
gab
@gxsoft

Gabriel Medina

unread,
Jun 11, 2018, 9:25:49 AM6/11/18
to ggg (GeneXus Google Groups)
 SOLUCION: 
La solución es agregar el usuario a la DB, el mismo que está dando error, y que sugieere el FORM dialog de Edit Connection en preferences de la KB
en 2 Pasos


image.png

image.png



--
Saludos,
gab
@gxsoft


Alejandro Alvarez

unread,
Apr 19, 2024, 9:23:40 AMApr 19
to GeneXus
Eso está bien cuando lo pruebas en tu maquina local, pues es ahí donde tienes la KB... PERO, si lo tienes en un servidor.. no se sabe como hacer eso.. Alguien sabe como agregar esa funcinón pero en un servidor ?
Reply all
Reply to author
Forward
0 new messages