Hello, I have a problem when install Reporting Services Point. This role not install fine and I can't configure. My enviroment is:Windows Server 2008 64 Bits StandardSQL Server 2008 Standard.SCCM 2007 R2.The all components are in same server machine. The SQL Server is configured with one instance where i have the all database for SCCM, WSUS and Reporting Services. The reporting services work fine yI configure with reporting services configuration manager.The problem is in the installation of role with configuration manager console. After add role reporint service point this error 7404 and not is possible access to propierties of reporting / reporting serivices. The all options are disable and unaviable.Thanks.

The R2 version of ConfigMgr is not supported on SQL 2008 yet as far as I know ("not supported" != "does not work at all" ;-) )See rsetup.log andSRSRPSetup.log if the installation was successful.

Hello, it sure? Can you tell me where he said that is not supported?In this link :http://technet.microsoft.com/es-es/library/cc161851(en-us).aspxWrite: "2 When SQLServer2008 is used to host the site database for a ConfigurationManager2007R2 installation, it is recommended that you install the update described in Microsoft article ID 957576 located at http://go.microsoft.com/fwlink/?LinkId=134675." I believe this indicates that supported?and this: SQL Server Site Database Configurations When installing Configuration Manager 2007SP1, the site database can be installed on either the default instance or a named instance of a supported SQLServer version installation. The instance used to host the site database can also be configured as a SQL Server failover cluster instance in an active/passive cluster configuration. It is supported to perform an in-place upgrade of the SQLServer2005SP2 instance hosting the Configuration Manager 2007site database to SQLServer2008. For more information about changing site server software, see How to Change Site Server Software. Additionally, it is supported to move the site database to a new SQLServer2008 instance. For information about moving the site database, see How to Move the Site Database. Important When using SQLServer2008 to host the site database for Configuration Manager 2007SP1 sites, the following update must be applied to the site server computer, SMS Provider computer, and any computers hosting a remote Configuration Manager 2007SP1 Configuration Manager console: Microsoft article ID955262 at http://go.microsoft.com/fwlink/?LinkId=134674. In SMS2003, the mppublish.vbs script, supplied with the SMS2003 installation files, was used to configure Microsoft SQL Server site database replication between the site database server and SQL Server site database replicas used to support management points and server locator points. Because Configuration Manager 2007 introduces new site database views and functions that are not replicated by the mppublish.vbs script, it is not supported for configuring SQL Server site database replication in Configuration Manager 2007 sites. For information about how to configure replication to support management points and server locator points, see How to Configure SQL Server Site Database Replication.

Paco90000 said: Can you tell me where he said that is not supported?In this link :http://technet.microsoft.com/es-es/library/cc161851(en-us).aspx[...] I believe this indicates that supported?Ok, then support for R2 was added recently. My bad. (The second text you quoted is only talking about SP1 - not R2, but the first link indicates that it's supported)Did you have a look at the logfiles I mentioned?

Hello,<01-15-2009 12:15:23> ====================================================================<01-15-2009 12:15:23> SMSSRSRP Setup Started....<01-15-2009 12:15:23> Parameters: D:\PROGRA~2\MICROS~2\bin\i386\ROLESE~1.EXE /install /siteserver:SCCM-LAB-CTRL01 SMSSRSRP<01-15-2009 12:15:23> Installing Pre Reqs for SMSSRSRP<01-15-2009 12:15:23> ======== Installing Pre Reqs for Role SMSSRSRP ========<01-15-2009 12:15:23> Found 0 Pre Reqs for Role SMSSRSRP <01-15-2009 12:15:23> ======== Completed Installion of Pre Reqs for Role SMSSRSRP ========<01-15-2009 12:15:23> Installing the SMSSRSRP<01-15-2009 12:15:23> Invoking process "C:\Windows\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe" "D:\Program Files (x86)\Microsoft Configuration Manager\bin\i386\SRSSERVER.dll"<01-15-2009 12:15:38> Registered DLL D:\Program Files (x86)\Microsoft Configuration Manager\bin\i386\SRSSERVER.dll<01-15-2009 12:15:38> Installation was successful.SMS_EXECUTIVE started SMS_SRS_REPORTING_POINT as thread ID 2672 (0xA70). $$<SMS_SRS_REPORTING_POINT><Thu Jan 15 12:15:40.970 2009 Romance Standard Time><thread=2468 (0x9A4)>This is a SRS Reporting Point Role as SRSRP registry key exists.~ $$<SMS_SRS_REPORTING_POINT><Thu Jan 15 12:15:40.972 2009 Romance Standard Time><thread=2672 (0xA70)>~Waiting for changes for 0 minutes $$<SMS_SRS_REPORTING_POINT><Thu Jan 15 12:15:40.982 2009 Romance Standard Time><thread=2672 (0xA70)>Timed Out...~ $$<SMS_SRS_REPORTING_POINT><Thu Jan 15 12:15:40.983 2009 Romance Standard Time><thread=2672 (0xA70)>STATMSG: ID=7404 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=SCCM-LAB-CTRL01 SITE=LC1 PID=2300 TID=2672 GMTDATE=Thu Jan 15 11:15:40.999 2009 ISTR0="SCCM-LAB-CTRL01" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_SRS_REPORTING_POINT><Thu Jan 15 12:15:40.999 2009 Romance Standard Time><thread=2672 (0xA70)>Failures reported during periodic health check by the SRS Server SCCM-LAB-CTRL01. Will retry check in 57 minutes~ $$<SMS_SRS_REPORTING_POINT><Thu Jan 15 12:15:41.000 2009 Romance Standard Time><thread=2672 (0xA70)>~Waiting for changes for 57 minutes $$<SMS_SRS_REPORTING_POINT><Thu Jan 15 12:15:41.002 2009 Romance Standard Time><thread=2672 (0xA70)>

http://support.microsoft.com/kb/957576/en-us: "Status message ID 7404 is reported frequently in an installation of System Center Configuration Manager 2007 R2 that uses SQL Server 2008 as the site database"

Hello, this path is installed yet.The patch not solved this problem. This patch not affect to funcionality of sccm.Thanks

I'm seeing this same error message show upwith SCCM 2007 R2 but with SQL 2005 SP2. I believe that this error started as soon as I added the Reporting Point role. Here's the last entry in the srsrp.log file. STATMSG: ID=7404 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=SCCMSRV SITE=THC PID=2836 TID=5440 GMTDATE=Fri Jan 30 19:06:33.017 2009 ISTR0="SCCMSRV" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_SRS_REPORTING_POINT><Fri Jan 30 11:06:33.017 2009 Pacific Standard Time><thread=5440 (0x1540)>Failures reported during periodic health check by the SRS Server SCCMSRV. Will retry check in 57 minutes~ $$<SMS_SRS_REPORTING_POINT><Fri Jan 30 11:06:33.033 2009 Pacific Standard Time><thread=5440 (0x1540)>~Waiting for changes for 57 minutes $$<SMS_SRS_REPORTING_POINT><Fri Jan 30 11:06:33.033 2009 Pacific Standard Time><thread=5440 (0x1540)> Here's the same error as reported in the Application Event log. 1/30/200911:06:33 AMSMS ServerErrorSMS_SRS_REPORTING_POINT7404N/ASCCMSRV"On 01/30/09 11:06:33, component SMS_SRS_REPORTING_POINT on computer SCCMSRV reported: SRS is not installed or properly configured on SRS Reporting point server ""SCCMSRV""." Does anyone have an idea as to why this error is occurring? Should I remove and then re-create the Reporting Point and Reporting Services Point roles? I have verified that I can run reports and view dashboards without a problem. I'm a little concerned about just ignoring this error. I don't have any custom reports created yet. I do have one dashboard that I've created but could easily re-create if needed. Thanks

Hello, Finally i had installed my enviroment with SQL Server without instance name. When I have defalut instance the installation for SRS Reporting Point work good. We can now see reports and configure the role. But...... Now have another error ID 7403.

Ditto! I have- Windows 2008 R2 64bit, SQL 2005 64bit SP2, SCCM R2. All on one server along with WSUS. Following other forums i have Instance id: MSSQL.3, Instance name: MSSQLSERVER, Report Manager URL: http://sccm/reports, report server url: http://sccm/reportserver, Edition ID: -1534726760 I keep getting SMS_SRS_Reporting_Point errors saying Exactly the same thing. I have no Reporting Site node in SCCM Manager console, just Reporting \ Dashboards and Reports and lots or these errors. All this is happening on hte one machine and in the default db. Anyone have any ideas PLEASE! Thanks

Hello, Trying to install Reporting Services Point get this error on srsrpsetup.log: <11-22-2010 09:59:05> Parameters: C:\PROGRA~1\MIF083~1\bin\i386\ROLESE~1.EXE /install /siteserver:BISMUTH SMSSRSRP <11-22-2010 09:59:05> Installing Pre Reqs for SMSSRSRP <11-22-2010 09:59:05> ======== Installing Pre Reqs for Role SMSSRSRP ======== <11-22-2010 09:59:05> Found 0 Pre Reqs for Role SMSSRSRP <11-22-2010 09:59:05> ======== Completed Installion of Pre Reqs for Role SMSSRSRP ======== <11-22-2010 09:59:05> Installing the SMSSRSRP <11-22-2010 09:59:05> Chart control detected. Invoking process "C:\Program Files\Microsoft Configuration Manager\bin\i386\DUNSETUP.EXE" <11-22-2010 09:59:05> Chart control setup C:\Program Files\Microsoft Configuration Manager\bin\i386\DUNSETUP.EXE failed with return code 0x00000001. Installation cannot continue. srsrp.log: SMS_EXECUTIVE started SMS_SRS_REPORTING_POINT as thread ID 7184 (0x1C10). SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 6680 (0x1A18) This is a SRS Reporting Point Role as SRSRP registry key exists. SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 7184 (0x1C10) Waiting for changes for 0 minutes SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 7184 (0x1C10) Timed Out... SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 7184 (0x1C10) Microsoft.ConfigurationManagement.Srs.SrsServer. error = Unspecified error SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 7184 (0x1C10) STATMSG: ID=7402 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=BISMUTH SITE=WST PID=5460 TID=7184 GMTDATE=Mon Nov 22 07:59:08.234 2010 ISTR0="BISMUTH" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 7184 (0x1C10) Failures reported during periodic health check by the SRS Server BISMUTH. Will retry check in 57 minutes SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 7184 (0x1C10) Waiting for changes for 57 minutes SMS_SRS_REPORTING_POINT 22/November/2010 9:59:08 AM 7184 (0x1C10) SCCM 2007 R3 on Windows 2003 R2 (x86) server with SQL 2008R2 Any ideas? Thanks

Andrey, I had this error come up because you need IIS on the SQL server. Once I setup IIS similar to the SCCM sites, it worked fine.

SCCM and SQL installed on the same server (IIS also). Is there way to instal SRSP manualy? (with msi?)

Running into the same problem I just did a clean install of sccm SP2 on one server running 2008R2, the SQL server is SQL 2008R2 running also on Windows 2008R2. After the install i installed the R3 update and i think most hotfixes. I was doing the initial configuration and when i tried to install the reporting service on the SCCM site server i got this from the SRSRPSetup.log <03-01-2011 17:00:27> ==================================================================== <03-01-2011 17:00:27> SMSSRSRP Setup Started.... <03-01-2011 17:00:27> Parameters: C:\PROGRA~2\MICROS~2\bin\i386\ROLESE~1.EXE /install /siteserver:NTMQ1042 SMSSRSRP <03-01-2011 17:00:27> Installing Pre Reqs for SMSSRSRP <03-01-2011 17:00:27> ======== Installing Pre Reqs for Role SMSSRSRP ======== <03-01-2011 17:00:27> Found 0 Pre Reqs for Role SMSSRSRP <03-01-2011 17:00:27> ======== Completed Installion of Pre Reqs for Role SMSSRSRP ======== <03-01-2011 17:00:27> Installing the SMSSRSRP <03-01-2011 17:00:27> Chart control detected. Invoking process "C:\Program Files (x86)\Microsoft Configuration Manager\bin\i386\DUNSETUP.EXE" <03-01-2011 17:00:27> Chart control setup C:\Program Files (x86)\Microsoft Configuration Manager\bin\i386\DUNSETUP.EXE failed with return code 0x00000001. Installation cannot continue. <03-02-2011 10:06:20> ==================================================================== I then deleted the role from the site server and installed the Reporting Point Service on the SQL server. While it did install without problems, i tried to go in and create a Report. Every report i try to create causes the SCCM Management MMC to crash after giving the following error; Microsoft.ConfigurationManagement.Srs.SrsServer. error = Unspecified error SMS_SRS_REPORTING_POINT 01/03/2011 5:00:30 PM 3964 (0x0F7C) STATMSG: ID=7402 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=NTMQ1042 SITE=BIM PID=1836 TID=3964 GMTDATE=Tue Mar 01 22:00:30.449 2011 ISTR0="NTMQ1042" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SRS_REPORTING_POINT 01/03/2011 5:00:30 PM 3964 (0x0F7C) Failures reported during periodic health check by the SRS Server NTMQ1042. Will retry check in 57 minutes SMS_SRS_REPORTING_POINT 01/03/2011 5:00:30 PM 3964 (0x0F7C) Waiting for changes for 57 minutes SMS_SRS_REPORTING_POINT 01/03/2011 5:00:30 PM 3964 (0x0F7C) Timed Out... SMS_SRS_REPORTING_POINT 01/03/2011 5:57:30 PM 3964 (0x0F7C) I found another post on the internet of someone suggesting it might be related to .net, however the 2008R2 already has v2 built-in and since it installed on the sql server without giving the same error it doesn't seem likely. I'd appreciate any help of figuring out why its not installing on the sccm server or crashing when installed on the SQL server. thanks

- I've tried turning on .net in the features of both servers and still the same problem - I've also installed Cummulative Update 6 onto the SQL server and still no luck Would appreciate any thoughts on what is causing this. Thanks