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.

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

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

Hi Nitin,

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

Regards,

Sharad

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