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

Publicado por Zina ,

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 <gxsoft@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