无法打开登录请求的数据库<database>。登录失败。登录失败的用户<user>

问题描述：

当我用management studio访问数据库时，一切正常，我访问表......但是当我运行用相同用户访问数据库的Windows服务时，会引发此错误。无法打开登录请求的数据库<database>。登录失败。登录失败的用户<user>

System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Cannot open database "sttcoletorsbvt" requested by the login. The login failed. 
Login failed for user 'usr_stt_coletor'. 
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) 
    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) 
    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) 
    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) 
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) 
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) 
    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) 
    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) 
    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) 
    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) 
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) 
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 
    at System.Data.SqlClient.SqlConnection.Open() 
    at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) 
    --- End of inner exception stack trace --- 
    at DynamicModule.ns.Wrapped_IServicoConfiguracaoColetor_3f81c81b8be24d3998bbc85dfa25d87f.SelecionarConfiguracao() 
    at Infraero.TINE3.STTColetor.Negocio.Coletor.ColetarBilhetes(String arquivoParaProcessar) 
    at Infraero.TINE3.STTColetor.WindowsService.ManipuladorBilhetes.RealizarProcedimentoColeta(String caminhoArquivo) 
    at Infraero.TINE3.STTColetor.WindowsService.ServicoColetor.RealizarColeta()

我该如何解决这个问题？

您是否检查过您是否在Windows服务中传递了与您登录管理工作室时相同的确切密码？ – 2013-03-22 18:41:07

是的，我使用app.config的副本/粘贴进行登录。 – 2013-03-22 18:45:18

可能将不得不分享你用来连接的代码。还评论一下，如果这个SQL身份验证或Windows身份验证？并且是错误中提到的数据库，您尝试连接到的数据库。还要确保你连接到正确的服务器等等。 – 2013-03-22 18:52:10

答

尝试确保用户有权访问连接字符串中的初始目录。如果连接字符串没有初始目录，请添加一个用户有权访问的目录。这可以解释为什么它在一种情况下工作，而不是另一种情况。

当前配置：'Data Source = s-vtgn02 \ prdsbvt04; Initial Catalog = sttcoletorsbvt; User ID = usr_stt_coletor; Password = 'usr_stt_coletor' ：db_datareader和db_datawriter。 – 2013-03-22 18:58:37

无法打开登录请求的数据库。登录失败。登录失败的用户

相关推荐