Jump to content


anyweb

using SCCM 2012 RC in a LAB - Part 11. Adding the Reporting Services Point role

Recommended Posts

Really great documentation here! Thank you for putting this together.

I am having an issue with SQL Server Reporting Services: it does not start. Did not know if it was running before SCCM 2012 was installed, but i noticed after installing Reporting Services Point. SQL Server Reporting Services does not start automatically at bootup or manually. It throws out errors codes: 1053 error, EventID 7000 & 7009, Timeout was reached, Timely fashion etc.).

 

SQL 2008 R2 SP1 CU7 on Server 2008 R2 SP1 Standard

 

Any thoughts?

Share this post


Link to post
Share on other sites

Hi all

 

If you are running SCCM database on a SQL cluster: you will need to run the reporting server on a separate server (I couldn't get it running on a cluster node and I didn't like it anyway :) I went for a VM with not much ressources).

After installing the SRSS service, you must configure it before going back to SCCM:

  • Configure the service to start with the SCCM report user
  • create the DB (point it to your clustered system center instance)
  • Report server DB credential: use once again the SCCM report user
  • Add the Report Manager url (at least http)
  • Define the Execution Account with the SCCM Report user.
  • I also added the sccm report user as local admin of the SRSS server (not sure it's really needed)
  • Add the SCCM server computer account as local admin of the SRSS server (needed to configure the server).

I'm not sure it's a 'production' valid setup regarding security but I couldn't find a way to get it working until i did all these steps.

 

Once done, go back to the SCCM console (based on the following post: http://social.technet.microsoft.com/Forums/en-US/configmanagergeneral/thread/4479e73e-8a19-4c7e-9418-b36770656b9b)

 

In CfgMgr, In the Administration workspace, expand Site Configuration, and then clickServers and Site System Roles.

(....) you have to go to New site system and add the SSRS box.

Then, on the Home tab, in the Server group, clickAdd Site System Role. The Add Site System Roles Wizard opens. Choose Reporting Point, and after verifying the connection to the CfgMgr DB, the instance name should populate.

 

Then check back the installation process as described in the original post by anyweb.

 

Hope this helps

Steve

  • Like 1

Share this post


Link to post
Share on other sites

Hi, Can i get a litle bit of help also?

I have installed the Reporting, I have added the security but.. i do not see the Reports. (My SQL is on one server and SCCM on another one).

Data:

- If i right clik in Reports and select Report Options i see the Reporitng Server

- The last 2 events at the component SMS_SRS_REPORTING_POINT are : "This component started". and "Site Component Manager successfully installed this component on this site system."

- The folder C:\SMS_SRSRP exists and it has reports in it also

- On the Reporting web page http://sqlserver/Reports/ i have the folder ConfigMgr_LC0 , if i go inside the Folder I see only a data source connection ( I do not see any reports)

Is this ok? What shoud I do?

Share this post


Link to post
Share on other sites

Hope this helps someone else out. This fixed my ability to run reports after changing the logon password.

 

EDIT: After rebooting I still get the same error, but my reports are working. sheeeeeeeesh. It may still help someone. I'll update if I figure out how to avoid the error message.

 

I needed to change the password for the account I used for SCCM and after fixing most services I could not get the reporting service to work. After updating all the services with the correct password they all appeared to be working. However, I kept getting the same error.

 

component SMS_SRS_REPORTING_POINT on computer <my site> reported: The report server service is not running on Reporting Service Point server "<my stie>"; start the service to enable reporting.

 

After hours and hours I found where to look from this page: http://markswinkels....messageid-7403/

 

1.) Open Internet Explorer

2.) Browse to the following URL: http://<your SQL Server Name>/Reports

 

Then I had to poke around and drilled down to:

 

SQL Server Reporting Services> Home> ConfigMgr <site name>> Administrative Security> Security Roles Summary

 

Click on "Properties Tab" and Select "Security" Link in the left pane.

Clck edit on the account you've changed the password for. (Mine was tied to "ConfigMgr Report Administrators, Config Mgr Report Users"

Note any items checked then Uncheck them and click "Apply"

Check the items you unchecked and click "Apply"

 

My Reports began working again :)

Share this post


Link to post
Share on other sites

All my other woes seem to have been fixed by uninstalling the application and reporting services roles, resetting the site and then reinstalling the roles. Who knows if that would have fixed it from the beggining :)

 

Note: One thing this beginner didn't account for was that after saying finished the processes (uninstalls/installs) worked in the backgroundand and I needed to check the logs to verify completion before moving on to the next step.

Share this post


Link to post
Share on other sites

Current Setup:

SCCM Server - No Database

Database Server - SQL Server 2008 R2 (10.50.2796)

Reporting Services Server - SQL Server 2008 R2 (10.50.1617)

 

A lot of responses have stated the upgrade to CU 6 fixes the problem. Is this a Reporting Services issue and the Report server needs to be at CU6 or is this a Database issue and the Database server that hosts the SCCM database needs to be at CU6?

Share this post


Link to post
Share on other sites

Current Setup:

SCCM Server - No Database

Database Server - SQL Server 2008 R2 (10.50.2796)

Reporting Services Server - SQL Server 2008 R2 (10.50.1617)

 

A lot of responses have stated the upgrade to CU 6 fixes the problem. Is this a Reporting Services issue and the Report server needs to be at CU6 or is this a Database issue and the Database server that hosts the SCCM database needs to be at CU6?

 

Are you running your sql in the default sql instance? if not you need the CU6.

Share this post


Link to post
Share on other sites

Hi,

 

I'm having a bit of a nightmare with the reporting service. I first had it up and running but the report log size was going through the roof. So I uninstalled the reporting service from the sql server and removed the role from CM. I also deleted the “ReportServer” DB.

 

Now I have reinstalled the sql reporting service. I tried to create a “ReportServer” database, but I am getting an error that this already exists.

 

post-16533-0-25432900-1347611125_thumb.jpg

 

So I named it NewReportServer and have added the role to CM, but in component status the reporting point is critical.

 

 

post-16533-0-53314900-1347611131_thumb.png

 

 

post-16533-0-35436600-1347611137_thumb.png

 

 

Can anyone help?

Share this post


Link to post
Share on other sites

Changed my tcp dynamic port range in order to be able to please the firewall administrators. After doing this the reports are troubeling me, I guess it could do with this or?

 

srsrp.log Reporting Services URL from Registry [https://server.domain.com/ReportServer/ReportService2005.asmx] Reporting Services is running Retrieved datasource definition from the server. Retrieved datasource definition from the server. Updating data source {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} at ConfigMgr_XXX Loading localization resources from directory [F:\SMS_SRSRP\SrsResources.dll] Looking for 'Swedish (Sweden)' resources Looking for 'Swedish' resources Falling back to 'en' resource set Confirmed the configuration of SRS role [ConfigMgr Report Users]. Confirmed the configuration of SRS role [ConfigMgr Report Administrators]. Confirmed the security policy for folder [/]. Confirmed the security policy for folder [/ConfigMgr_XXX]. Confirmed the security policy for folder [/ConfigMgr_XXX/Asset Intelligence]. Confirmed the security policy for folder [/ConfigMgr_XXX/Compliance and Settings Management]. Confirmed the security policy for folder [/ConfigMgr_XXX/Administrative Security]. Confirmed the security policy for folder [/ConfigMgr_XXX/Operating System]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Updates - A Compliance]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Updates - B Deployment Management]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Updates - C Deployment States]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Updates - D Scan]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Updates - E Troubleshooting]. Confirmed the security policy for folder [/ConfigMgr_XXX/Driver Management]. Confirmed the security policy for folder [/ConfigMgr_XXX/Task Sequence - Deployment Status]. Confirmed the security policy for folder [/ConfigMgr_XXX/Task Sequence - Deployments]. Confirmed the security policy for folder [/ConfigMgr_XXX/Task Sequence - Progress]. Confirmed the security policy for folder [/ConfigMgr_XXX/Task Sequence - References]. Confirmed the security policy for folder [/ConfigMgr_XXX/State Migration]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Distribution - Application Monitoring]. Confirmed the security policy for folder [/ConfigMgr_XXX/Virtual Applications]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Distribution - Package and Program Deployment Status]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Distribution - Package and Program Deployment]. Confirmed the security policy for folder [/ConfigMgr_XXX/User - Device Affinity]. Confirmed the security policy for folder [/ConfigMgr_XXX/Software Metering]. Confirmed the security policy for folder [/ConfigMgr_XXX/Status Messages]. Confirmed the security policy for folder [/ConfigMgr_XXX/Migration]. Confirmed the security policy for folder [/ConfigMgr_XXX/Device Management]. Confirmed the security policy for folder [/ConfigMgr_XXX/Status Messages - Audit]. Confirmed the security policy for folder [/ConfigMgr_XXX/Alerts]. Confirmed the security policy for folder [/ConfigMgr_XXX/Client Status]. Confirmed the security policy for folder [/ConfigMgr_XXX/Client Push]. Confirmed the security policy for folder [/ConfigMgr_XXX/Hardware - CD-ROM]. Confirmed the security policy for folder [/ConfigMgr_XXX/Hardware - Disk]. Confirmed the security policy for folder [/ConfigMgr_XXX/Hardware - General]. Confirmed the security policy for folder [/ConfigMgr_XXX/Hardware - Memory]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Hardware - Modem]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Hardware - Network Adapter]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Hardware - Processor]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Hardware - SCSI]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Hardware - Sound Card]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Hardware - Video Card]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Site - Client Information]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Site - Discovery and Inventory Information]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Site - General]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Site - Server Information]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Network Access Protection]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Power Management]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Wake On LAN]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Upgrade Assessment - Windows 7]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Network]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software - Files]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software - Companies and Products]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Users]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Distribution - Collections]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Distribution - Content]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Out Of Band Management]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Endpoint Protection]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Status Messages/Status Messages - Hidden]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Endpoint Protection/Endpoint Protection - Hidden]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Distribution - Application Monitoring/Software Distribution - Application Monitoring - Hidden]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Network Access Protection]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Asset Intelligence]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Compliance and Settings Management]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Administrative Security]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Operating System]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Updates - A Compliance]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Updates - B Deployment Management]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Updates - C Deployment States]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Updates - D Scan]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Software Updates - E Troubleshooting]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Driver Management]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Task Sequence - Deployment Status]. Unable to connect to the remote server Failed to retrieve existing folder security for folder [/ConfigMgr_XXX/Task Sequence - Deployments].

Unable to connect to the remote

 

 

-----

 

Cant see any reports in my console....

 

Any help appreciated!

 

Cheers,

SamAdam

Share this post


Link to post
Share on other sites

Hi,

 

I'm having a bit of a nightmare with the reporting service. I first had it up and running but the report log size was going through the roof. So I uninstalled the reporting service from the sql server and removed the role from CM. I also deleted the “ReportServer” DB.

 

Now I have reinstalled the sql reporting service. I tried to create a “ReportServer” database, but I am getting an error that this already exists.

 

post-16533-0-25432900-1347611125_thumb.jpg

 

So I named it NewReportServer and have added the role to CM, but in component status the reporting point is critical.

 

 

post-16533-0-53314900-1347611131_thumb.png

 

 

post-16533-0-35436600-1347611137_thumb.png

 

 

Can anyone help?

 

I had the same problem. The problem was that reporting services was added AFTER SP1 was installed on the SQL. You need version 2500 of reporting services to be able to use it with SCCM 2012. Look at my picture and check the version you have.

 

 

22046682.png

 

 

If you have 1600 like the picture, you need to re-install SP1.

 

Just to clarify, this fixes the problem "The report server service is not running...." problem.

  • Like 1

Share this post


Link to post
Share on other sites

Our site (SCCM 2012) is using a single SCCM 2012 server that is using a remote SQL Server 2008 R2 with SP1 CU6 - 10.50.2811.0 with reporting services installed on default instance (mssqlserver). On the SQL box is also IIS with a default website in use.

From the SCCM 2012 server i can connect and browse to http://sql1/reports and http://sql1/reportserver

On my SCCM2012 i try to add the Reporting Services Point to the SQL server from the SCCM console, it succesfully finds the MSSQLSERVER instance on the remote SQL server but then encounter errors.

In Site Status during installation i see error below:

Meesage ID 7403 > The report server service is not running on Reporting Service Point server "SQL1.DOMAIN.COM"; start the service to enable reporting.

Looking on the SQL/REPORT SERVER We've verified the service is running and we can connect to the URL.

In the URL http://sql1/reports the folder name isn't there and is not being created.

In addition i CAN'T find a Log file SRSRP.LOG on my server Program Files\Microsoft Configuration Manager\Logs

I found many post with this 7403 error but my Report is CU6

Share this post


Link to post
Share on other sites

Our site (SCCM 2012) is using a single SCCM 2012 server that is using a remote SQL Server 2008 R2 with SP1 CU6 - 10.50.2811.0 with reporting services installed on default instance (mssqlserver). On the SQL box is also IIS with a default website in use.

From the SCCM 2012 server i can connect and browse to http://sql1/reports and http://sql1/reportserver

On my SCCM2012 i try to add the Reporting Services Point to the SQL server from the SCCM console, it succesfully finds the MSSQLSERVER instance on the remote SQL server but then encounter errors.

In Site Status during installation i see error below:

Meesage ID 7403 > The report server service is not running on Reporting Service Point server "SQL1.DOMAIN.COM"; start the service to enable reporting.

Looking on the SQL/REPORT SERVER We've verified the service is running and we can connect to the URL.

In the URL http://sql1/reports the folder name isn't there and is not being created.

In addition i CAN'T find a Log file SRSRP.LOG on my server Program Files\Microsoft Configuration Manager\Logs

I found many post with this 7403 error but my Report is CU6

 

 

Did you check my post above? check the version on the reporting services.

Share this post


Link to post
Share on other sites

I am trying to add the Reporting services role to my primary site server. I have a Windows server 2008 R2 with SQL 2008 R2 sql server and windows server 2008 R2 application server (primary site server). During the add site system roles wizard I am stuck on the reporting services point page. I specify my sql server (fqdn) and database name, clicked verify, it successfully verified the DB. I accepted the default folder name, but when I go to choose the Reporting Services server instance the drop down box is empty.

 

I have tried specifying the service account that I have configured on my SQL box, i even tried opening up full access for that account as a local admin on SQL and SA on the Database. No matter what I try it will not find the RS instance.

 

Any help appreciated.

  • Like 1

Share this post


Link to post
Share on other sites

In SCCM 2007 when you ran a report you could specify a wildcard (%), like if I wanted to run a report that showed all the versions of Java that were installed in a particular collection. But with 2012 it will only allow me to enter in the exact name of the program. Is there anyway to modify the report? If so, how?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...