In Part 1 I backed up the SCCM database and copied the backed up data base files to a different SQL server. I also attached the data base files and created the database
In Part 2 I created a SQL job to run daily . This job will copy the backed up files from SCCM database server. Then this job will attach the copied database files .
In Part 3 I exported the certificate from SQL server and imported in on a machine where reports will be authored.
In part 4 I am going to install Report Builder 3.0 on client machine Win7 and configure data source for creating SQL reports. SQL reporting services is running from SCCM Primary server . See network diagram in Part 1
At this time you should have report builder 3.0 installed for SQL 2012 on a Windows 7 machine . If you do not have it installed download it from here and install on the workstation
Once Report builder is installed .
Open SQL reporting services , In my case it is http://cm01/reports.
Click on New folder ( Only for keeping reports separate)
Provide the name of the folder and click ok.
After the new folder is created , Go to folder SCCM reports from SQL01
Click on New Data Source
Data Source contains the connection information for a particular database.
Provide the name to the data source , SQL01 DataSource
Check – Enable this data source
Data Source type – Microsoft SQL server
In the connection string type in the following
(Change the name of Initial_Catalog to your database name and data source to your SQL server name)
Persist Security Info=False;Initial Catalog=CM_R01;
As mentioned in part 1 user labserv\cmreports has read rights to CM_R01 database. Once this database is replicated same rights are assigned to the replicated database.
Check box – Use as windows credentials when connecting to the data source
Click on Test connection
and ensure that data source is able to connect successfully.
This concludes Part 4