locked
Unable to open Biztalk Administarton console RRS feed

  • Question

  • Hi ,

    We have Biztalk server and I have admin access to the server , when I am trying to open Biztalk administration I am getting below error .

    I have got BiztalkMgmtDb access but still I am getting below error.

    Please help me with this , I am not able to see if I am missing anything.


    Thanks and Regards, Nitin.

    Friday, July 10, 2015 3:26 AM

Answers

  • Hi Nitin,

    BizTalk Server cannot access SQL server. This could be due to one of the following reasons:

    1. Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.

    2. The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.

    3. The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.

    4. A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.

    Rachit


    Please mark as answer or vote as helpful if my reply does

    • Marked as answer by Angie Xu Friday, July 17, 2015 2:59 AM
    Wednesday, July 15, 2015 6:23 AM
    Moderator

All replies

  • Hi Nitin,

    Can you please validate below are not the case with you :

    1) Your User should be member of Biz Talk groups  .

    2) Your Biz Talk groups may not point to correct SQL server where Management DB exists.

    https://zeetalks.wordpress.com/2010/05/08/biztalk-server-not-available-or-not-configured-on-server/

    3) SQL server service is up and running along with BizTalk SSO service .

    Thanks
    Abhishek

    Friday, July 10, 2015 3:59 AM
  • Hi Nitin,

    BizTalk Server cannot access SQL server. This could be due to one of the following reasons:

    1. Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.

    2. The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.

    3. The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.

    4. A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.

    Rachit


    Please mark as answer or vote as helpful if my reply does

    • Marked as answer by Angie Xu Friday, July 17, 2015 2:59 AM
    Wednesday, July 15, 2015 6:23 AM
    Moderator
  • Hi Nitin,

    Check your BizTalk Server configuration and add your user ID ( windows login ID) to BizTalk Database.

    Regards,

    Sharad

    Wednesday, July 15, 2015 7:16 AM
  • Hi Nitin,

    You can check below links for this problem.

    https://zeetalks.wordpress.com/2010/05/08/biztalk-server-not-available-or-not-configured-on-server/

    http://www.biztalkgurus.com/biztalk_server/biztalk_2006/f/10/t/9000.aspx



    Regards, Anurag Prajesh BizTalk Developer



    Wednesday, July 15, 2015 1:46 PM