Enjoy Sharing

ConfigMgr Reporting Services point

Installing the ConfigMgr Reporting Services point is as simple as adding the a new role to the site server. Before that, ensure the SQL Reporting Services component in SQL 2005 has been added. After all that has been done you will need to copy the reports and here’s how:

Once you have the R2 installed, you will realise an addition to the reporting tree on the left hand pane, Reporting Services. To copy the reports to the Reporting Services, right-click the site server and select Copy Reports to Reporting Services.

image

Here you will need to specify the server name and the database name to retrieve the reports from. If it is fine, the Test button will be grayed out signaling that the connection is working. Click Next.

image

Select the type of authentication then click Next.

image

Select the reports that you would like to copy then click Next.

image

Click Next in the Security page.

image

Just click Next at the Summary page.

image

And the installation begins. View the progress in the page below.

image

The copying completes. Go ahead and click Close.

image

Contrary to some understanding, it IS possible to be running both the conventional Reporting Point and the Reporting Services Point concurrently. The Reporting Services Point gives you the following benefits:

  • Uses an industry standard reporting system to query the Configuration Manager 2007 database.
  • Enables users who are not familiar with Configuration Manager 2007 reporting to generate ad hoc reports.
  • Enables users to subscribe to reports; for example, a manager could automatically be e-mailed a report each day, detailing the status of a patch rollout.
  • Simplifies the creation of SQL-based reports in Configuration Manager 2007 R2.

 

 

Enjoy!!!

Advertisements

10 responses

  1. Mirco

    Hi,

    Thank you for your guides

    I have a problem: if I click on the properties of the reporting services point server everything is grayed out, and in the event viewer I got a lot of error 7404.
    SQL reporting services are configured correctly, I think…
    Can you help me?

    Sccm 2007 release 4.00.6487.2000 with SQL 2008 reporting services

    Bye
    Mirco

    January 28, 2011 at 1:09 am

    • One way to check whether your SQL Reporting Services are working in to go to “servername”/Reports on your browser. Make sure that it works first before adding the Reporting Services Point role.

      February 11, 2011 at 3:59 pm

  2. bonnie

    Nice – thank you so much, after searching and searching and searching, I realized the error messages I was getting was because the reports had not been transferred, hence the configmgr_[site] folder had not been created. I have spent two days researching this and yours was succinct and resolved my issues that were showing up in the logs.

    July 7, 2011 at 6:48 am

    • Hi Bonnie, glad this helped you out. Cheers…

      July 7, 2011 at 11:20 am

  3. hi weikingheh,

    i have problems related to configuring reporting services on SCCM 2010 beta2.

    SQL server is running on separate server (with SQL reporting services installed), and configuration manager on different one.

    when i’m trying to install reporting services point on SCCM server, it does not let me to install. because Reporting Services Server instance is blanch and there is nothing to choose.

    but when i’m trying to install it on SQL Server, in this case Reporting Services Server instance is visible.

    anyway, after that when i want to see reports there is no reports displayed.
    in logs there is only such error logs: “Reporting Point failed to monitor SQL Reporting Services Server on “test-SQL02”.

    what may be the cause of that?

    July 11, 2011 at 9:16 pm

    • Hi Constantine,

      The Reporting Services Point role is supposed to be installed on any computer running SQL Reporting Services. So the installation will fail on any computer without SQL Reporting Services properly installed. What you’re experiencing is expected.

      July 12, 2011 at 12:43 am

  4. Hi Weikingteh,

    Thanks for your reply. Yes you were right. I was trying to configure Reporting Service Point without configuring SQL Reporting Services.

    I took another Compuer and installed there SQL Server and SCCM on that machine. everything worked fine.

    Just i was something missing in that scenario when i had a SQL Server separately….
    i dont know exactly what….

    July 13, 2011 at 9:38 pm

    • You would need to create a new Server under your Site Systems node and then add the Reporting Services Point role. So it could be that your Primary Site is on ServerA and SQL Reporting Services is installed on ServerB. Go to Site Systems node on your console, and right-click on it to choose New > Server, then add \\ServerB. Then add the Reporting Services Point role to ServerB.

      July 18, 2011 at 11:11 am

  5. salman

    Begin Install CMDLINE=/s /m=C:\SMS\bin\i386\rep.val
    Value of WWWROOT = c:\inetpub\wwwroot
    System tests (IIS, IE, WSH) ok
    Checking c:\inetpub\wwwroot\SMSReporting_BSM directory exists
    Existing directory c:\inetpub\wwwroot\SMSReporting_BSM found
    Checking if c:\inetpub\wwwroot\SMSReporting_BSM\global.asa exists
    Directory c:\inetpub\wwwroot\c:\inetpub\wwwroot\SMSReporting_BSM already exists but doesnt have a global.asa file! – fail.

    August 18, 2011 at 5:52 pm

  6. salman

    Above mentioned log is what I get from SMSreportinginstall.log file at my reporting point server.

    August 18, 2011 at 5:56 pm

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