MS Report server configurations:

This is highlevel steps how to confifure MS reportserver:

1) Login to the database:
     This can be done in two ways:
         Windows authantication.
          Database authantication

2) Create or restore the database.

3)  Open the MS Reporting Services Configuration Manager.

     3.1) Hit the 'Web Service URL' and change the SSL certificate to 'WMSVC'
     3.2) Hit the 'Report Manager URL' and try to login to the report services.

4) On the report server console, create new datasource:
   
    4.1) Connect using "Credentials stored securely in the report server:" by giving the user crated in
           MS SQL server.
 
   4.2)  This user needs to be created in MS SQL server.

•  In the MS SQL Management Studio go to Security Logins: and create user eg rwmp_v3.3
• Define the database you want to connect and generate reports
• Assign the admin role to the user- In the Server roles tab
• Map the database you want to connect : In the Server Mapping tab.

   4.3)  Hit the 'Test Connection'



   4.4) Create new folder for the reports

   4.5) Deploy reports.

   4.6) Click the manage option of the deployed report.
          In the Data source tab, select the shared datasource which you have created in step 4



   4.7)  Click the report and 'View Report' button  to see the report is being rendered properly.

  Allways give admin user to start services:
    Tomcat server