SCCM diet

Online notes for reference

Replicating SCCM DB and adding replicated DB to SCCM Reporting – Part 4

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.

Part 4

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.



DBRepl43 DBRepl44

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



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: