SCCM diet

Online notes for reference

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

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 .

Part 3

Part 1 & Part 2 were dedicated to standing up the alternate SCCM database.

In Part 3 I am going to detail the steps necessary to prepare machine from where reports will be authored.

In order to author SQL reports from a workstation , SQL database server ( SQL01 in this case) needs to trust the workstation.

This is done by exporting the server certificate from SQL database server where copied database is hosted from and importing it on workstation where reports will be authored.

Perform these steps on the SQL database server where replicated database is hosted (SQL01 in this case)

Open mmc – click on file and add remove snap-ins

Select Certificated and click on add

DBRepl23

Select computer account and click next

 

DBRepl24

Select local computer and click finish

 

DBRepl25

Click OK

 

DBRepl26

Now go to Certificates -> Personal->Certificates

 

DBRepl27

Select the Server authentication certificate and right click -> All tasks ->Export

 

DBRepl28

On the welcome certificate export wizard click next

 

 

DBRepl29

Leave default selected , No, Do not export the private key  and click next

 

 

DBRepl30

 

Leave default selected DER encoded binary X.509 and click next

DBRepl31

Browse and provide the path to the certificate and a name of the file and click next

DBRepl32

Click finish to complete the export

 

 

DBRepl33

Click OK and finish

 

DBRepl34

Copy the exported certificate to the workstation which will be used to author reports. This steps needs to be on all the machines which will be used to creating reports.

Right click the certificate and click on install certificate

 

 

DBRepl35

This will open the import certificate wizard , Click next

 

DBRepl37

 

Browse to certificate store and select Trusted Root Certification Authorities store and click next

DBRepl38

Click finish to finish the import

 

 

DBRepl39

Click OK

 

 

DBRepl40

To verify if the certificate is present in the certificate store , Open mmc , add certificate snap-in for local computer.

Go to Trust root certification authorities and on the right side as highlighted SQL01 certificate is present.

DBRepl41

 

 

This concludes Part 3

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: