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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics