Biztalk 2009 configuration error for Multi Environment

Home Page Forums BizTalk 2004 – BizTalk 2010 Biztalk 2009 configuration error for Multi Environment

Viewing 1 reply thread
  • Author
    Posts
    • #24363

      Hi,

       

      I am facing the following error while configuring Biztalk on Multi environment servers.
      I have installed SQl 2005 on SQl Box and Biztalk server 2009 on another box.

      I am configuring Biztalk with Service account.It is having acess on all the stuffs on SQl box.

       

      Error

       

      Microsoft.BizTalk.Bam.Management.BamManagerException: The database cannot be found. —> System.Data.SqlClient.SqlException: Cannot open database “BAMPrimaryImport” requested by the login. The login failed.

      Login failed for user ‘ITLINFOSYS\AMEXExMed’.

         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.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 Microsoft.BizTalk.Bam.Management.SqlHelper.ExecuteQuery(String cmdText, CommandType cmdType, Transaction transaction)

         — End of inner exception stack trace —

         at Microsoft.BizTalk.Bam.Management.SqlHelper.ExecuteQuery(String cmdText, CommandType cmdType, Transaction transaction)

         at Microsoft.BizTalk.Bam.Management.BamConfigurationManager.GetConfigurationXmlFromPrimaryImportDb()

         at Microsoft.BizTalk.Bam.Management.BamConfigurationManager..ctor(String piServer, String piDatabase, Int32 sqlHelperCmdTimeout, Boolean validateServerNames)

         at Microsoft.BizTalk.Bam.Management.BamManager..ctor(String primaryImportServer, String primaryImportDatabase, Int32 sqlCmdTimeout, Boolean validateServerNames)

         at Microsoft.BizTalk.Bam.Management.BamManager..ctor(String primaryImportServer, String primaryImportDatabase)

         at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.get_BamManager()

         at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.HandleGetActivities()

         at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.DispatchCommand()

         at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Run()

         at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Main(String[] args)

       

      Please help me to resolve it. Your help is greatly appreciated.

      Thanks

    • #24381

      The error is pointing to a permissions problem in SQL:

      System.Data.SqlClient.SqlException: Cannot open database “BAMPrimaryImport” requested by the login. The login failed.
      Login failed for user ‘ITLINFOSYS\AMEXExMed

      Is ITLINFOSYS\AMEXExMed the account you are signed as or the Service account you are trying to setup?

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.