Microsoft BizTalk Server 2006 Configuration

After Installing the Biz Talk server 2006, you must configure it before starting any development. If you have started, you might have encountered the below error when publishing the solution or when selecting the deployment server.

<No BizTalk Configuration database(s) found on server '(LOCAL)'.>

This confirms that the issue is with user access to the database, not with the connection/network issue. If you have already configured the Biz Talk server 2006, You can check the BizTalk admin group in the SQL server where BizTalkMgmtDb exists. In my case, I haven't configured the BTS.

Go to Start à All Programs à Microsoft BizTalk Server 2006 à BizTalk Server Configuration

Note :: You must run the application with Administrative privileges. (Right-click and select run as Administrator)

 You can progress ahead with either Basic Configuration or Custom Configuration. The only point that you have to consider is if the database server is in another server (i.e. not localhost) and the Biz Talk instance have configured before, you have to select the "Custom configuration" option.

Provide NT AUTHORITY\NETWORK SERVICE as the username and click on Configure.

Let's enable all the features.

1. Enterprise Single Sign-On (SSO)

If you are getting the below error on Data Stores,
failed to connect to the sql database ssodb on sql server

Do the below described steps to create the SSO database.

1. Start the Visual Studio command prompt as an Administrator (must)

2. Go to the C:\Program Files\Common Files\Enterprise Single Sign-On directory

3. Run regasm ssosql.dll command

4. Deselect "Enable Enterprise Single Sign-On this computer" and select it again.

Now If you are still getting the below error on Windows Service,
failed to connect to the sql database ssodb on sql server

Do the below-described steps to configure SSO.

Go to Start à All Programs à Microsoft Enterprise Single Sign-On à SSO Administration (run it as an Administrator)

Select the SSO server name and tick Set SSO Server for all users, and click OK.

Expand Enterprise Single Sign-On and click on "Create Database"

For security reasons, inbuilt Administrator accounts are not allowed to add. 

(To be continued... )