Data Engineering Technical Blog

Step 1: Configuring SQL Reporting Services – Web Service URL Simply go to Reporting Services Configuration Manager and choose Web Service URL and populate the following needed information. The fields are named properly so I guess there is no need for further explanation. What this does is that it configures the IIS for you depending on what Virtual Directory names you had declared. Step 2: Configuring SQL Reporting Services – Create a Report Database Same here, fields need no further explanation except for one which is Native Mode and SharePoint Integrated mode which I will explain below. Choose create a database or if you already have one choose an existing one. For this example, we will create a new one: Connect to the database where you want your Report Data to be stored: Give it a Name and a Report Server Mode. With SharePoint Integrated Mode the report RDLs are stored on SharePoint and not in the Report Database. For this instance, we will use the SharePoint ...