Login failed for user

[twpesquisa 1]

 

Pessoal, estou com um problema mas não estou conseguindo identificar onde esta a falha...

 

Criei um usuario no banco chamado apontamento, porém quando tento efetuar o acesso, exibe a seguinte mensagem:

 

Cannot connect to CHNNB032\SQLEXPRESS.

 

Additional information:

 

Login failed for user 'apontamento'. (Microsoft SQL Server, erro: 18456)

 

 

 

Estou informando o usuario e senha correto, mas não conseguido conectar. Abaixo segue mais detalhes sobre a mensagem...

 

 

 

 

 

 

===================================

 

Cannot connect to CHNNB032\SQLEXPRESS.

 

===================================

 

Login failed for user 'apontamento'. (.Net SqlClient Data Provider)

 

------------------------------

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

 

------------------------------

Server Name: CHNNB032\SQLEXPRESS

Error Number: 18456

Severity: 14

State: 1

Line Number: 65536

 

 

------------------------------

Program Location:

 

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

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, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, 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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

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 Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

 

 

 

[advaldomesquita 93]

senha e login errado.

Tem ctza que a senha e usuario sao esses? Esta ativo na base? Qual a permissao dele na base? a base default dele esta ativa?