RE: ConfigMgr 2007 R2 Reporting Services Issues

Hello Darryl,

Thank you for your post.
My name is Eric Zhang, and it is my pleasure to work with you on this
issue!
Please understand that this newsgroup is for SMS related issues.

As you have posted the same thread in our Technet Forum for SCCM, our forum
support engineer will help you to perform the troubleshooting

Thank you for your time and cooperation!

Best regards,

Eric Zhang(MSFT)
Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on MOM technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: "Darryl V." <d_vezina@xxxxxxxxxxxxxxxx>
| Subject: ConfigMgr 2007 R2 Reporting Services Issues
| Date: Wed, 8 Oct 2008 16:58:09 -0700
| Lines: 204
| Message-ID: <A0F38AA5-5EA3-4CEB-B9FF-C81198C4DF40@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| format=flowed;
| charset="iso-8859-1";
| reply-type=original
| Content-Transfer-Encoding: 7bit
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
| X-MS-CommunityGroup-MessageCategory:
{E4FCE0A9-75B4-4168-BFF9-16C22D8747EC}
| X-MS-CommunityGroup-PostID: {A0F38AA5-5EA3-4CEB-B9FF-C81198C4DF40}
| Newsgroups: microsoft.public.sms.setup
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sms.setup:2687
| NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
| X-Tomcat-NG: microsoft.public.sms.setup
|
| This was also posted in the CfgMgr Setup/Deployment forum.
|
| Hi There,
|
| I've been trying to get R2 SQL Reporting services Point to work and
continue
| to run into issues that won't allow me to move forward with this. Errors
| are showing up in the component status.
|
| Here is my setup:
|
| Single Site,
| SCCM R2 running on Win2k8 x64 Std Ed. (3 different servers to balance
roles)
| Remote SQL 2005 x64 std Edition server on Win2k8 x64. Reporting services
is
| also running on this server and there are 3 instances (My OpsMgr 2007
| reports are here as well as sharepoint 2007).
| Reporting Services Role is installed on the SQL Server
| There is no "Reporting Point" role installed
| I have reporting services setup and configured to the best of my
knowledge
| based on the MS articles for doing so. I can get to my SMSReports
instance
| using the browser.
|
|
|
| When I go to the ConfigMgr Reporting Services Object and pull up the
| properties, I am unable to actually specify any information in any of the
| tabs of the dialogue box. I can't specify datasource, server name, or
| anything else. Its all greyed out and the General Tab simply says
| "Unavailable" for all items other then the name of the server hosting the
| reporting services point.
|
|
|
| Thanks very much for any assistance you can provide.
|
|
|
| Cheers,
|
|
|
| -Darryl
|
|
|
| Here are some logs:
|
|
|
| Application Event Log on SQL Server where Reporting Service Point is
| installed:
|
|
|
| On 10/7/2008 10:51:17 PM, component SMS_SRS_REPORTING_POINT on computer
| VM-VICSQL reported: SMS SRS web service is not running on SRS Reporting
| point server "VM-VICSQL".
|
|
|
|
|
| SRSRP.log
|
| SMS_EXECUTIVE started SMS_SRS_REPORTING_POINT as thread ID 3304 (0xCE8).
| $$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:05.245 2008 Pacific Daylight
| Time><thread=1772 (0x6EC)>
| This is a SRS Reporting Point Role as SRSRP registry key exists.~
| $$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:05.386 2008 Pacific Daylight
| Time><thread=3304 (0xCE8)>
| ~Waiting for changes for 0 minutes $$<SMS_SRS_REPORTING_POINT><Tue Oct
07
| 22:51:05.386 2008 Pacific Daylight Time><thread=3304 (0xCE8)>
| Timed Out...~ $$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:05.386 2008
| Pacific Daylight Time><thread=3304 (0xCE8)>
| STATMSG: ID=7403 SEV=E LEV=M SOURCE="SMS Server"
| COMP="SMS_SRS_REPORTING_POINT" SYS=VM-VICSQL SITE=ABE PID=5452 TID=3304
| GMTDATE=Wed Oct 08 05:51:17.651 2008 ISTR0="VM-VICSQL" ISTR1="" ISTR2=""
| ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0
| $$<SMS_SRS_REPORTING_POINT><Tue Oct 07 22:51:17.651 2008 Pacific Daylight
| Time><thread=3304 (0xCE8)>
| Failures reported during periodic health check by the SRS Server
VM-VICSQL.
| Will retry check in 57 minutes~ $$<SMS_SRS_REPORTING_POINT><Tue Oct 07
| 22:51:17.651 2008 Pacific Daylight Time><thread=3304 (0xCE8)>
| ~Waiting for changes for 57 minutes $$<SMS_SRS_REPORTING_POINT><Tue Oct
07
| 22:51:17.667 2008 Pacific Daylight Time><thread=3304 (0xCE8)>
|
|
| SRSRPSetup.log
|
| <10-07-2008 22:51:01>
| ====================================================================
| <10-07-2008 22:51:01> SMSSRSRP Setup Started....
| <10-07-2008 22:51:01> Parameters:
\\VM-VICSQL\L$\SMS\bin\i386\ROLESE~1.EXE
| /install /siteserver:VM-VICSCM01 SMSSRSRP
| <10-07-2008 22:51:01> Installing Pre Reqs for SMSSRSRP
| <10-07-2008 22:51:01> ======== Installing Pre Reqs for Role
SMSSRSRP
| ========
| <10-07-2008 22:51:01> Found 0 Pre Reqs for Role SMSSRSRP
| <10-07-2008 22:51:01> ======== Completed Installion of Pre Reqs
for
| Role SMSSRSRP ========
| <10-07-2008 22:51:01> Installing the SMSSRSRP
| <10-07-2008 22:51:01> Invoking process
| "C:\Windows\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe"
| "L:\SMS\bin\i386\SRSSERVER.dll"
| <10-07-2008 22:51:02> Registered DLL L:\SMS\bin\i386\SRSSERVER.dll
| <10-07-2008 22:51:02> Installation was successful.
|
|
|
| SMSAdminUI.log
|
| [4][10/7/2008 4:07:31 PM] ystem.Management.ManagementException\r\nNot
found
| \r\n at
|
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus

| errorCode)
| at System.Management.ManagementObject.Initialize(Boolean getObject)
| at System.Management.ManagementBaseObject.get_wbemObject()
| at System.Management.PropertyData.RefreshPropertyInfo()
| at System.Management.PropertyDataCollection.get_Item(String
propertyName)
| at System.Management.ManagementBaseObject.GetPropertyValue(String
| propertyName)
| at
|
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConne
ctionManager.RefreshSiteControlFile(ManagementBaseObject
| managementObject)\r\nManagementException details:
| instance of __ExtendedStatus
| {
| Operation = "GetObject";
| ParameterInfo =
|
"SMS_SCI_SysResUse.FileType=2,ItemName=\"[\\\"Display=\\\\\\\\VM-VICSQL\\\\\
\\"]MSWNET:[\\\"SMS_SITE=ABE\\\"]\\\\\\\\VM-VICSQL\\\\,SMS
| Distribution Point\",ItemType=\"System Resource Usage\",SiteCode=\"ABE\"";
| ProviderName = "WinMgmt";
| };
| \r\n
| [4][10/7/2008 4:07:57 PM] ystem.Management.ManagementException\r\nNot
found
| \r\n at
|
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus

| errorCode)
| at System.Management.ManagementObject.Initialize(Boolean getObject)
| at System.Management.ManagementBaseObject.get_wbemObject()
| at System.Management.PropertyData.RefreshPropertyInfo()
| at System.Management.PropertyDataCollection.get_Item(String
propertyName)
| at System.Management.ManagementBaseObject.GetPropertyValue(String
| propertyName)
| at
|
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConne
ctionManager.RefreshSiteControlFile(ManagementBaseObject
| managementObject)\r\nManagementException details:
| instance of __ExtendedStatus
| {
| Operation = "GetObject";
| ParameterInfo =
|
"SMS_SCI_SysResUse.FileType=2,ItemName=\"[\\\"Display=\\\\\\\\VM-VICSQL\\\\\
\\"]MSWNET:[\\\"SMS_SITE=ABE\\\"]\\\\\\\\VM-VICSQL\\\\,SMS
| SRS Reporting Point\",ItemType=\"System Resource
Usage\",SiteCode=\"ABE\"";
| ProviderName = "WinMgmt";
| };
| \r\n
| [4][10/7/2008 4:12:35 PM] :Creating folder name 'ConfigMgr_ABE', path '/'.
| [4][10/7/2008 4:13:08 PM] :Client found response content type of
'text/html;
| charset=utf-8', but expected 'text/xml'.
| The request failed with the error message:
| --
| <html>
| <head>
| <title>
| SQL Server Reporting Services
| </title><meta name="Generator" content="Microsoft SQL Server Reporting
| Services 9.00.3073.00" />
| <meta name="HTTP Status" content="500" />
| <meta name="ProductLocaleID" content="9" />
| <meta name="CountryLocaleID" content="1033" />
| <style>
| BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
| COLOR:black}
| H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
| LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
| DISPLAY:inline}
| .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
| COLOR:gray}
| A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC;
| TEXT-DECORATION:none}
| A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300;
| TEXT-DECORATION:underline}
| A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC;
| TEXT-DECORATION:none}
| A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300;
| TEXT-DECORATION:underline}
|
| </style>
| </head><body bgcolor="white">
| <h1>
| Reporting Services Error<hr width="100%" size="1" color="silver" />
| </h1><ul>
| <li>An internal error occurred on the report server. See the error log
| for more details. (rsInternalError) <a
|
href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Reportin
gServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=
Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3073.00"
| target="_blank">Get Online Help</a></li><ul>
| <li>For more information about this error navigate to the report
server
| on the local server machine, or enable remote errors</li>
| </ul><hr width="100%" size="1" color="silver" /><span
| class="ProductInfo">SQL Server Reporting Services</span>
| </ul>
| </body>
| --.
|
|
|
|

.

Relevant Pages

  • RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi
    ... Microsoft CSS Online Newsgroup Support ... >Subject: RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi ... >> you that install it back on your server. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL lokaler Report. Beispiele gesucht
    ... Im "Client/Local-Mode" werden KEINE Reporting Services und kein IIS und kein SQL Server 2005 benötigt. ... Dazu ist weder ein SQL Server noch ein IIS notwendig. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • RE: Alert Problem
    ... Thank you for posting to the SBS Newsgroup. ... I understand that you have Monitoring and Reporting issue on the SBS 2K3 ... understand that if the problem persists and the server is not able to work ...
    (microsoft.public.windows.server.sbs)
  • Socket Address usage exception on SharePoint site hosting SSRS reports
    ... SQLServer Reporting Services reports: ... Server Reporting Services. ... Server A - Running SharePoint Server 2007, SQL Server 2005, and SQL ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Monitoring and reporting problems
    ... Thank you for posting in SBS newsgroup. ... displayed" errors in "monitoring and reporting" pages of the Server ... Connect to the Internet on Server Management. ...
    (microsoft.public.windows.server.sbs)