Install automatically Watchdoc for Reporting Services

With MS SQL^® 2008 R2 and MS SQL^® 2012 R2, it's possible to deploy automatically the WRS^® reports thanks to the WRSTools.exe tool provided in the installation package.

Access the WRSTOOLS.exe tool

To install WRS automatically:

1. from the Watchdoc Tools list in doc.doxense.com, download the WRS installation package;

2. save the archive folder on your server;

3. unzip the archive folder after checking it is not blocked;

4. among the archive files, find the WRSTools.exe file:
   
   
   
   

With the MS SQL Express^® version, the WRS^® tool must be installed on the same server than the server on which is installed the data base. Instances created with SQL Express cannot exceed 10GB. To be able to manage more information, we recommend creating a standard database (or a consolidation database, also standard, in a domain including a master server and other servers).

With the other MS SQL^® version, the WRS^® tool can be installed on an other server than the one on which is installed the data base.

Install WRS^® automatically

To install WRS^® with WRSTools:

1. in the archive folder which contains the WRS installation package, click on the WRSTools.exe file;
   

   
   

2. in the WRS Tools displayed box, under the Settings tab, fill the following fields:

   • Watchdoc server: enter the Watchdoc server name (NETBIOS name or IP address) ;

   • Watchdoc root password: indicate the Watchdoc maintenance password;

   • SQL Report server: indicate the SQL server name (NETBIOS or IP address);

   • WRS Licence File: indicate the licence file path. This licence file provided by Doxense has a .wlk extension;

   • Language: in the list, select the language of the WRS interfaces.

WRS requieres its own licence, different from the licence provided for Watchdoc. When applying for a license, you will have to give the server MAC address from wich will be executed the WRS tool.

The account used by Watchdoc must be dbo owner of the Watchdocstats database because it will create a sql table and an optimazing stored procedure.

 

3. under the Advanced tab, fill the following fields:
   
   
   

    

• Watchdoc port: if it's not the default port (5744), indicate the port number you use;

• Report server Login*: indicate the user name added in the Reporting Services rights (cf. previous chapter);

• Report server password*: indicate the account password used (Reporting Services rigths requiered);

• Folder with *.rdl: indicate the folder path in which the reports will be saved;

• SQL instance: indicate the installed Reporting Service instance name ('WATCHDOC' in our example) ;

To fill the Report fields:
- log on to the Reporting Services web interface:
(example: http://serverreportingservice/Reports_INSTANCESQL) ;
- if you connect yourself, that means that your account is allowed to assign roles in SQL Reporting Services;
- if not, ask to add your account in assigning SQL Reporting Services roles.

 

4. Folder with *.rdl: indicate in this field you RDL files location;

5. Once the settings entered and checked, click the Launch button to run WRS;
   
   

    

6. In the SQL Password not found box, enter the password, then click on the OK button :
   
   
   
   
   

è a message informs you that the WRS installation is completed:

 

7. Click on the URL link to access the SQL Server Reporting Services interface:
   
   
   
   
   

Deploy WRS reports

1. In the SQL Server Reporting Services, click on the Watchoc for Reporting Service folder to open all the reports it contains;

2. click on the Statement entry to access the reports:
   
   
   

    

If problems occur while Statement is running, you can consult the WRS logs (in the WRSTools.exe folder).