Part 14 describes the configuration of SQL reporting in Config Mgr 2012. I will also show a sample report and how to export the report to PDF and xls files.
Navigate to Administration/Site Configuration/Servers and Site System Roles
Right click server and choose Add Site System Roles
Add Site System Roles wizard starts
Verify server name
Enter Proxy details if required - not required in this deployment.
Select Reporting Service Point
Verify database details
Click next to add the Reporting Service Point
Reports are now available in Monitoring/Reporting
See sample report
Click on the drop down arrow to choose file format
Sample PDF
Sample Excel file
Wow that was unusual. I jusst wrote an incredibly long comment but aafter I clicked submit mmy comment didn't appear.
ReplyDeleteGrrrr... well I'm not writing alll thatt over again.
Anyhow,just wanted to say wonderful blog!
Also visit my web-site; master resale rights selling your scribd Free work At
Appreciate this post. Will try it out.
ReplyDeleteAlso visit my weblog jailbreak ipod 4 6.1.3 evasion
You ought to take part in a contest for one of the most useful ssites
ReplyDeleteonline. I am going too highly recommend this website!
Feel free to surf to mmy blog ... thrombosed hemorrhoid treatment during pregnancy
Hmm iѕ anyone elѕ&X65; having problemѕ wit&X68; thе
ReplyDeleteimages on this blog lo&X61;ding? I'm trying tο determine i&X66; its a problem on &X6d;y end or if it's
the blo&X67;. Any response&X73; would be gгeatlу appreciateԁ.
Feel free to visi&X74; mу web-site; Hostgator Helmet Cam Review Wordpress
Gerry,
ReplyDeleteI really appreciate your help. May the fruits of your labor and help come back to you bountifully. The Reporting Services server instance: is not showing my MSSQLServer. Do you know why this is the case; actually it's not giving me any option.
Thanks
Charles
Thanks Charles.
DeleteRemember you have to add the Reporting Point role to the SQL site system (not the Primary Site Server).
Have you heard or installed 2012 R2 with the Primary and CAS in a SQL Cluster getting reporting point working?
ReplyDeleteI ALWAYS insist of local SQL to avoid this kind of problem.
Deletesoftware metering reports can't seem in sccm 2012 r2
ReplyDeleteI don't understand Amir.
DeleteHi Gerry,
ReplyDeleteWhn i enable the reporting point, the instance is blank. i installed SRS, configured it and still the same prbm. any help is appreciated.
You haven't given enough information Surya. Is this local or remote SQL? Is your installation account local administrator of the SQL server and sysadmin role in SQL?
DeleteHi Gerry,
ReplyDeleteThanks for the response. Its a remote SQL. Yes, the install account is a sys admin in SQL and is a local admin of the SQL.
I am unable to enable the reporting point in my primary site server, however the same is possible when i try to create reporting point in sql server. Does this make sense?
ReplyDeleteHi Gerry, Yes it is a remote SQL on a CLSUTER and the account is provided sysadmin role in SQL
ReplyDeleteSSRS is not cluster aware. It must be configured as a scale-out solution. Have you done this? You can find good information about this here:
Deletehttps://social.technet.microsoft.com/Forums/en-US/4479e73e-8a19-4c7e-9418-b36770656b9b/sccm-2012-reporting-point-server-instance-blank
Also your problem could be that your virtual directories have not been created in IIS. Have a look
Deletehttp://myitforum.com/myitforumwp/2012/10/10/reporting-services-site-role-setup-instance-blankempty/
Hi Gerry,
ReplyDeleteThe issue is resolved. Missed the simplest of things. my SMS_executive service was in stopped state. Do not how or why it was stopped. However once that is started, all the reports are now in my console.
Thanks for all your help.
Glad you sorted it out Surya
Delete