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

--

Saludos,

gab

@gxsoft

On Mon, Jun 11, 2018 at 10:19 AM Gabriel Medina <gxs...@gmail.com> wrote:

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