ConfigMGR_xxx SQL Reporting folder does not get created
Hi,
Can you run any of the reports from the ConfigMgr. console?Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
January 17th, 2011 3:12pm
Hi An00p
Thanks for the URL.
Everything was already setup with the same steps has showed in the Blog
I am using a domain account for my reporting services credential. That account has sysadmin right on the reports database.
Still same error....ConfigMGR_xxx folder is still missing.
Thanks for any hints.
REgards
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 3:19pm
hummm indeed Kent...
If I run a report and select : Reporting Service, it does work.
I can see the report within the SCCM console and the path to the ConfigMgr_MTL
/ConfigMgr_MTL/bceb6a7e-898a-4caa-a0e7-fe8289f3574a/d4162f4a-0b4f-4292-9961-ba8981a1c980/ConfigMgr_MTL/Client Status
weird.
So The SCCM reporting point is working. I just can't execute the reports within a browser.
I have tried the Web reports from my XP station, directly from the SCCM server itself, and rom the SQL server....same behavior....no ConfigMGR folder.
JP
January 17th, 2011 3:43pm
And what if you open SQL Reporting Services configuration and use the link
http://server/reports link there?Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 3:45pm
I have tried that.
Same issue. No ConfigMGR folder.
Where locally is the ConfigMGR folder created?
Thanks Kent
JP
January 17th, 2011 3:49pm
I think I would spend 10 minutes on reinstalling the SRS site system role in ConfigMgr. while monitoring the log files.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 3:59pm
Will try that.
I will let you guys know.
Thanks for your help
Regards
January 17th, 2011 4:04pm
I just have deployed a SCCM SQL reporting point role on a SQL server 2005 running SQL reporting service.
In SCCM, I have copied the reports.
The setup went fine, no error message.
When I browse the Report web site, I don't see the Config_XXX folder
I can see the HOME reporting page, but not the ConfigMGR_xxx folder.
Thanks for any help.
Regards
JP
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 4:18pm
Hello - Check out the below blog. It may help you?
Easy setup of SRS with Config Manager R2
http://blogs.technet.com/b/mwiles/archive/2009/02/19/east-setup-of-srs-with-config-manager-r2.aspx?wa=wsignin1.0Anoop C Nair
January 17th, 2011 4:57pm
Hi Kent
Nope. That did not help.
Guess it is PSS time!!
I will get this post updated.
Thanks
JP
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 5:12pm
Ok
I did reinstall this morning the RS point on the SQL server.
If I look at the Sitecomp.log, I can see that the RS point did install sucessfully.
In SCCM, I copied the reports to the RS point.
Same behavior.
Are they any other logs that I show take a look at?
Here is a little bit more about my setup:
Server 1 : Windows 2008 R2 : SCCM 2007 R3
Server 2 : Windows 2003 SP2 : SQL 2008 R1 / Reporting Service using defaut instance
I also even tried to re-re create the RS point using a different folder name (SCCMReports, instead od ConfigMGR)
and still no luck.
Againg, I am able to browse the http:\\server2\reports ...
Thanks for any help
JP
January 18th, 2011 5:58pm
Well well well
I sat down with the BDA's ...and they found out that they actually already installed an instance of Reporting Service on the SQL server.
So, the ConfigMGR folder was created but in another RS instance ... hehe
So I followed this link:
http://nocentdocent.wordpress.com/2010/07/03/sccm-how-to-force-sql-reporting-services-point-to-select-a-specific-srs-instance-on-a-machine-with-multiple-instances-an-unsupported-workaround/
And VOILA !!! Problem solved.
Thanks
JP
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 6:14pm
Hello - Try to go through the below article.
http://technet.microsoft.com/en-us/library/cc512026.aspx
Note
Information about the report folder will be shown only after you have created a new report or copied existing reports to this report server.
Anoop C Nair
January 18th, 2011 6:15pm
Hi Anoop
I have done this several times.
Everytimes I re-install the RS point, I always copy the reports. But the folder never gets created.
Thanks
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 6:21pm
Hmm, a little strange. What if you create new reporting project in BIDS and publish that to a new folder?Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
January 18th, 2011 6:31pm
Hello - srsrp.log is the log which you can refer.
Anoop C Nair
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 6:33pm
Another one you can try.
1) Open http://SRSSrver/reports
2) Click Show details, this will list hidden objects. If you see the ConfigMgr folder, open the folder properties and remove the check mark in
Hide in list view.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
January 18th, 2011 6:35pm
srsrp.log show no error:
SMS_EXECUTIVE started SMS_SRS_REPORTING_POINT as thread ID 9692 (0x25DC). $$<SMS_SRS_REPORTING_POINT><Tue Jan 18 08:01:34.207 2011 Eastern Standard Time><thread=1088 (0x440)>
This is a SRS Reporting Point Role as SRSRP registry key exists.~ $$<SMS_SRS_REPORTING_POINT><Tue Jan 18 08:01:34.207 2011 Eastern Standard Time><thread=9692 (0x25DC)>
~Waiting for changes for 0 minutes $$<SMS_SRS_REPORTING_POINT><Tue Jan 18 08:01:34.223 2011 Eastern Standard Time><thread=9692 (0x25DC)>
Timed Out...~ $$<SMS_SRS_REPORTING_POINT><Tue Jan 18 08:01:34.223 2011 Eastern Standard Time><thread=9692 (0x25DC)>
Successfully checked that the SRS web service is healthy on server MTL1DBSQ02~ $$<SMS_SRS_REPORTING_POINT><Tue Jan 18 08:01:35.754 2011 Eastern Standard Time><thread=9692 (0x25DC)>
~Waiting for changes for 57 minutes $$<SMS_SRS_REPORTING_POINT><Tue Jan 18 08:01:35.754 2011 Eastern Standard Time><thread=9692 (0x25DC)>
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 6:44pm
Glad to see that your issue got resolved !!!Anoop C Nair
January 18th, 2011 9:34pm