Setup

The setup procedure is very simple and consists of two steps:

 

  • Setup database
  • Setup Reports

 

To install the database, run the command SetupDb.cmd.

 

image

 

The procedure will ask the server name and the instance name of SQL Server and then the credentials with which to access to the database. It is possible to specify a SQL Server user or use the Windows integrated security. Specify a user who has at least the rights of database creator.

It is important to specify the same SQL Server instance in which you have BizTalkMgmtDb database.

To install reports, run the command SetupReport.cmd.

 

image

 

You have to specify SQL Server Reporting Services web services URL and the path in which you have installed RS.EXE program.

You must have the rights of content managers to publish reports.

 

Once the setup is complete, you must configure the reports data source.

Run the report manager.

 

01

 

Navigate the "Data Sources" folder, select the data source "BizTalkReport" and edit the connection string.

 

02

 

03

 

Finally apply the configuration.

Last edited Jun 4, 2015 at 7:22 AM by pellitteris, version 2