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

DBRepl41a

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)

 

 

DBRepl42

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.

 

 

DBRepl45

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;
Data Source=sql01.labserv.net;
Encrypt=True;TrustServerCertificate=True

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

 

DBRepl46

 

Click on Test connection

and ensure that data source is able to connect successfully.

 

DBRepl47

 

 

 

 

This concludes Part 4

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: