The following installation notes cover a fresh installation of SCRUBS for SQL Server 2008, Premium Edition. If you already have Community Edition, and wish to upgrade, follow these notes instead.

First, check that you meet the following system requirements.

The steps are as follows:

1. Copy the SCRUBS application objects to your server
2. Attach the SQL Server 2008 database
3. Create the SQL Server Agent job
4. (Optional) Configure the SQL Server Agent Job
5. Deploy the SSRS Reports

 

Copy the SCRUBS Objects to your Application Server

1. Copy the folder \SummitCloud and all of its contents to C:\Program Files
   * Note: You can change the folder, but you'll need to modify the path used in the SQL Server Agent Job which looks to the c:\Program Files\SummitCloud location by default.

Attach the SQL Server 2008 Database

1. Open SQL Server Management Studio 2008 (SSMS) and connect to your database server.
2. Right Click Databases and select Attach...
   
   
3. Click the Add.. button
   
   
4. Browse to c:\Program Files\SummitCloud\SCRUBS\DB
   
   
5. Select the SummitCloud_SCRUBS.mdf file
6. Click OK

Add the SQL Server Agent Job
This step will create the automated job to import log data from SQL Server Reporting Services 2008 to SCRUBS. It looks to default locations and will execute every 5 minutes. All settings can be modified.

1. In SQL Server Management Studio, Select File, Open, then File...
   
   
2. Browse to c:\Program Files\SummitCloud\SCRUBS\DB\Scripts and select the file 'Create Job for SCRUBS.sql'
   
   
3. Review the SQL, then Click the ! Execute button.
   
   
   
   By default, the job will run every 5 minutes. If you are anxious to get started and can't wait 5 minutes for the first run, you can select the job in SQL Server Agent and run it now:
   1. Expand SQL Server Agent
   2. Find the job: SummitCloud SCRUBS - SSRS Log Feeder
   3. Right click the job and select Start Job at Step...
   4. If all goes well, after a few moments you will see green checks.
      
      

Modify the SQL Server Agent Job Configuration (Optional)
Modify the job if you:

 

• Used a different default location for the SCRUBS files (particularly the .dtsx file)
• Your SSRS Execution log data is not the default database, or not on this server
• Want to change the execution from every 5 minutes to another schedule

1. Right Click the job SummitCloud SCRUBS - SSRS Log Feeder and select Properties. The job properties will open:
   
   
2. In 'Select a Page', Click Steps, then on Step 1 "SSRS Log Update" click Edit.
   
   
3. If you aren't using the default directory for SCRUBS, or want to move the SSIS package, change the file path in the Package field.
   
   
4. Select the Data sources tab
   
   Destination: This is the logging datawarehouse (SummitCloud_SCRUBS) attached earlier. The connection uses SSPI, but if you want to modify to use SQL Server credentials, do so here.
   Source: This is the source to the ReportServer database that manages SSRS. It is not necessary to be on the same server. Modify this connectionstring if you need to provide credentials or if you want to import execution log data from a named instance on this server, or import from a completely different server.
   
   Note: The SQL Server Agent account will need sufficient privileges to read / write to your selected databases. Another option is to create a SQL Agent proxy with stored credentials.
   
   
5. Additional configurations:
6. On the Set values tab, you will find user configurable property settings:
   
   FullLogging True / False (default is True)
   Determines amount of run logging to store. This is not the execution logging. Rather, it refers to the RunLog which reports on the status of this job. If you run this package every 5 minutes and don't care to see that 0 Reports or 0 Jobs were encountered, set this to False. The default is True, for maximum verbosity.

 

 

Deploy the SCRUBS for SQL Server 2008 Reports
Note: Reports can be run from BIDS (Visual Studio) or may be deployed to any SQL Server 2008 Reporting Services instance that can connect to the SCRUBS datawarehouse. You may deploy to SQL Native mode or SharePoint integrated mode installations.

 

1. Open Business Intelligence Development Studio (BIDS)
   
2. From the File Menu, select Open, then Project/Solution...
   
   
3. Browse to the location of the SCRUBS solution file. By default, this is c:\Program Files\SummitCloud\SCRUBS\Community Edition Reports\Premium Edition Reports.sln
   
   
4. Right Click the Solution and select Properties to change the deployment location. The defaults are shown below. However, as noted above, you may deploy to another SSRS 2008 instance in native or SharePoint mode.
   Note that the reporting datasource uses Integrated Security. Change the credential settings in that file as your environment dictates.
   
    
5. On the Build Menu, select 'Deploy Premium Edition Reports'
   
    
6. After successful deployment, browse to the location of the SummitCloud folder.
   
   
7. Select the Premium Edition Reports folder.