Hi all, I received this error, any idea why?

The adapter failed to transmit message going to send port "LA837SendPort" with URL "sqlserver". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed for user 'BTSAppHost'. ---> System.Data.SqlClient.SqlException: Login failed for user 'BTSAppHost'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   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, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.Adapters.Sql.SqlAdapterConnection.OpenConnection()
   --- End of inner exception stack trace ---

Server stack trace: 
   at Microsoft.Adapters.Sql.SqlAdapterConnection.OpenConnection()
   at Microsoft.Adapters.Sql.ASDKConnection.Open(TimeSpan timeout)
   at Microsoft.ServiceModel.Channels.Common.Design.ConnectionPool.GetConnection(Guid clientId, TimeSpan timeout)
   at Microsoft.ServiceModel.Channels.Common.Design.ConnectionPool.GetConnectionHandler[TConnectionHandler](Guid clientId, TimeSpan timeout, MetadataLookup metadataLookup, String& connectionId)
   at Microsoft.ServiceModel.Channels.Common.Channels.AdapterRequestChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.OneWayOperationSendPortRequestChannel`1.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at System.ServiceModel.ICommunicationObject.Open()
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.GetChannel[TChannel](IBaseMessage bizTalkMessage, ChannelFactory`1& cachedFactory)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.SendMessage(IBaseMessage bizTalkMessage)&

Think User 'BTSAppHost' dont have access to the database, provide required permissions.

• Marked as answer by Christiane0696 17 hours 0 minutes ago

Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed for user 'BTSAppHost'. ---> System.Data.SqlClient.SqlException: Login failed for user 'BTSAppHost'.

Because the account for the BizTalk Host Instance, BTSAppHost, is either invalid or does not have permissions for the target database, TPAQLSQL01/OPRDEV/HICoreInterface.

There several specific reasons the account could be invalid which are described in this article: http://msdn.microsoft.com/en-us/library/ms366351.aspx

Note, if a password change is required, you must follow the procedure to change the SSO password: http://msdn.microsoft.com/en-us/library/aa561505.aspx

• Proposed as answer by Abhishek0127 18 hours 42 minutes ago
• Marked as answer by Christiane0696 17 hours 0 minutes ago

Hi Christiane,

The error is Login failed for user 'BTSAppHost' Ensure you have given access to read/write the record for the user BTSAppHost in the database youre trying to access.

Refer this article for the step-by-step guidance:http://sandroaspbiztalkblog.wordpress.com/2012/02/29/cannot-open-database-requested-by-the-login-the-login-failed-or-the-execute-permission-was-denied-on-the-object-database-schema-dbo/

Think User 'BTSAppHost' dont have access to the database, provide required permissions.

• Marked as answer by Christiane0696 Wednesday, January 22, 2014 6:27 PM

Think User 'BTSAppHost' dont have access to the database, provide required permissions.

• Marked as answer by Christiane0696 Wednesday, January 22, 2014 6:27 PM

Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed for user 'BTSAppHost'. ---> System.Data.SqlClient.SqlException: Login failed for user 'BTSAppHost'.

Because the account for the BizTalk Host Instance, BTSAppHost, is either invalid or does not have permissions for the target database, ServerName/Instance/Database.

There several specific reasons the account could be invalid which are described in this article: http://msdn.microsoft.com/en-us/library/ms366351.aspx

Note, if a password change is required, you must follow the procedure to change the SSO password: http://msdn.microsoft.com/en-us/library/aa561505.aspx

• Proposed as answer by Abhishek0127 Wednesday, January 22, 2014 4:45 PM
• Marked as answer by Christiane0696 Wednesday, January 22, 2014 6:27 PM
• Unmarked as answer by Christiane0696 16 hours 54 minutes ago
• Edited by boatseller 16 hours 27 minutes ago Change actual names

Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed for user 'BTSAppHost'. ---> System.Data.SqlClient.SqlException: Login failed for user 'BTSAppHost'.

Because the account for the BizTalk Host Instance, BTSAppHost, is either invalid or does not have permissions for the target database, ServerName/Instance/Database.

There several specific reasons the account could be invalid which are described in this article: http://msdn.microsoft.com/en-us/library/ms366351.aspx

Note, if a password change is required, you must follow the procedure to change the SSO password: http://msdn.microsoft.com/en-us/library/aa561505.aspx

• Proposed as answer by Abhishek0127 Wednesday, January 22, 2014 4:45 PM
• Marked as answer by Christiane0696 Wednesday, January 22, 2014 6:27 PM
• Unmarked as answer by Christiane0696 Thursday, January 23, 2014 6:32 PM
• Edited by boatseller Thursday, January 23, 2014 7:00 PM Change actual names
• Marked as answer by Christiane0696 17 hours 38 minutes ago

Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed for user 'BTSAppHost'. ---> System.Data.SqlClient.SqlException: Login failed for user 'BTSAppHost'.

Because the account for the BizTalk Host Instance, BTSAppHost, is either invalid or does not have permissions for the target database, ServerName/Instance/Database.

There several specific reasons the account could be invalid which are described in this article: http://msdn.microsoft.com/en-us/library/ms366351.aspx

Note, if a password change is required, you must follow the procedure to change the SSO password: http://msdn.microsoft.com/en-us/library/aa561505.aspx

• Proposed as answer by Abhishek0127 Wednesday, January 22, 2014 4:45 PM
• Marked as answer by Christiane0696 Wednesday, January 22, 2014 6:27 PM
• Unmarked as answer by Christiane0696 Thursday, January 23, 2014 6:32 PM
• Edited by boatseller Thursday, January 23, 2014 7:00 PM Change actual names
• Marked as answer by Christiane0696 Friday, January 24, 2014 5:49 PM

Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed for user 'BTSAppHost'. ---> System.Data.SqlClient.SqlException: Login failed for user 'BTSAppHost'.

Because the account for the BizTalk Host Instance, BTSAppHost, is either invalid or does not have permissions for the target database, ServerName/Instance/Database.

There several specific reasons the account could be invalid which are described in this article: http://msdn.microsoft.com/en-us/library/ms366351.aspx

Note, if a password change is required, you must follow the procedure to change the SSO password: http://msdn.microsoft.com/en-us/library/aa561505.aspx

• Proposed as answer by Abhishek0127 Wednesday, January 22, 2014 4:45 PM
• Marked as answer by Christiane0696 Wednesday, January 22, 2014 6:27 PM
• Unmarked as answer by Christiane0696 Thursday, January 23, 2014 6:32 PM
• Edited by boatseller Thursday, January 23, 2014 7:00 PM Change actual names
• Marked as answer by Christiane0696 Friday, January 24, 2014 5:49 PM

BoatSeller,

Can you remove the name of the target database that is tpaql....opr....hicor.....

for security reasons.

Thanks.

No problem.  Why did you unmark the answer?  Was it incorrect?

Boatseller,

Everything you suggest is correct! i unmarked it until the database name gets removed.

Thank you for always helping me out!