Tuesday, November 10, 2009

Installing UDDI 3 with a separate SQL Server

The installation documents doesn't explain how the setup for UDDI 3 is to be done when the SQL Server is installed on a separate machine than where the UDDI services are to be placed (in my case on the BizTalk 2009 server). Here is the steps I take.
  1. Run setup.exe from the BizTalk media on the SQL Server and choose to install UDDI 3. Install only the database components.

  2. When the installation finishes, choose to configure the UDDI services.
  3. Select to do a custom configuration and specify the service account to use.
  4. Go to the UDDI Services Database Component page of the configuration and choose to enable UDDI Services Database Component and deselect the SSL requirement.

  5. Apply the configuration.
    A failure with the apply task will most likely be due to a lack of permissions to the SQL Server. Make sure that the account you are logged in as (or use to run the configuration tool) has the appropriate permissions to SQL Server.
    If successful, you should end up with a UDDI3 database on your SQL Server.

  6. Start the UDDI3 setup from the BizTalk media on the BizTalk server.
  7. Choose to install the components necessary, except for Database Components.

  8. Finish the installation and select to run the configuration tool.
  9. Enter the SQL Server name and the credentials for the service account and select to do a custom configuration.
  10. Check the Enable UDDI Services Web Application box.

    Note! If you lack the proper credentials to the UDDI3 database on the SQL Server, you will see a red cross next to the Data Store name with an error message of "The database UDDI3 on BTSSQLSRV01 is not a valid UDDI database.". The database is in fact just fine, but the account used to run the configuration tool doesn't have all the required permissions to access the database.

  11. Go to the next page and check the Enable UDDI Service Notification Service box. Enter the information for SMTP server and E-mail address.

  12. Apply the configuration.
  13. Go to the URL specified for the UDDI services and verify that everything is up and running.