Hi, You can install SQL CU4, that will remove error 7403 - http://support.microsoft.com/kb/2345451Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

Hi, You can install SQL CU4, that will remove error 7403 - http://support.microsoft.com/kb/2345451 Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund This is for SQL 2008 I am running SQL 2005

Auch, then the correct answer is to upgrade the SQL server to 2008 R2 :-) - check this thread for an answer to solving the SQL 2005 problem http://www.myitforum.com/forums/m224441-print.aspxKent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

Then you do not have the correct permissions configured. Permissions in SSRS are a whole separate mechanism from the ConfigMgr permissions.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys

Auch, then the correct answer is to upgrade the SQL server to 2008 R2 :-) - check this thread for an answer to solving the SQL 2005 problem http://www.myitforum.com/forums/m224441-print.aspx Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund I found that thread last week and tired this a couple times. Didn't work. 1. Deleted the ConfigMgr Reporting Services Point 2. Added New Role, ConfigMgr Reporting Services Point 3. Restarted the SMS_SRS_REPORTING_POINT in configmgr service manager 4. It works, no error message! 5. I won't even ask why this solves the problem but, without any intention to offend anyone, WTF just happend? Jason I don't understand, I am using a domain admin account to configure SSRS

My Setup 1. SCCM 2007 R2 and Server 2008 2. SQL2005 running on Server 2008 R2 I am having an issue with my SRS site installing. I get the following error SMS SRS web service is not running on SRS Reporting point server "LEWSQL2". Now I can browse to the site using http://SQLservername/reports and that show the homepage but no site folder under that. The SRS web service is running. Here is the log info. SRSRP.log STATMSG: ID=7403 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=LEWSQL2 SITE=LEW PID=2448 TID=10832 GMTDATE=Mon Jan 17 18:27:45.066 2011 ISTR0="LEWSQL2" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 $$<SMS_SRS_REPORTING_POINT><Mon Jan 17 12:27:45.066 2011 Central Standard Time><thread=10832 (0x2A50)> Failures reported during periodic health check by the SRS Server LEWSQL2. Will retry check in 57 minutes~ $$<SMS_SRS_REPORTING_POINT><Mon Jan 17 12:27:45.097 2011 Central Standard Time><thread=10832 (0x2A50)> ~Waiting for changes for 57 minutes $$<SMS_SRS_REPORTING_POINT><Mon Jan 17 12:27:45.113 2011 Central Standard Time><thread=10832 (0x2A50)> SRSSetup.log <01-14-2011 15:36:30> ==================================================================== <01-14-2011 15:36:30> SMSSRSRP Setup Started.... <01-14-2011 15:36:30> Parameters: \\LEWSQL2\F$\SMS\bin\i386\ROLESE~1.EXE /install /siteserver:LEWSCCM SMSSRSRP <01-14-2011 15:36:30> Installing Pre Reqs for SMSSRSRP <01-14-2011 15:36:30> ======== Installing Pre Reqs for Role SMSSRSRP ======== <01-14-2011 15:36:30> Found 0 Pre Reqs for Role SMSSRSRP <01-14-2011 15:36:30> ======== Completed Installion of Pre Reqs for Role SMSSRSRP ======== <01-14-2011 15:36:30> Installing the SMSSRSRP <01-14-2011 15:36:30> Invoking process "C:\Windows\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe" "F:\SMS\bin\i386\SRSSERVER.dll" <01-14-2011 15:36:32> Registered DLL F:\SMS\bin\i386\SRSSERVER.dll <01-14-2011 15:36:32> Installation was successful.

Looks like the installation was successful: <01-14-2011 15:36:32> Installation was successful. Did you configure the SRS componet in the ConfigMgr console after installation? By default, there are no reports and nothing is created until you initiate the configuration. See this link for an "easy" setup experience: http://blogs.technet.com/b/mwiles/archive/2009/02/19/east-setup-of-srs-with-config-manager-r2.aspx. You should be able to skip down to the section titled Configuring Properties for the Reporting Services Point near the bottom.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys

Looks like the installation was successful: <01-14-2011 15:36:32> Installation was successful. Did you configure the SRS componet in the ConfigMgr console after installation? By default, there are no reports and nothing is created until you initiate the configuration. See this link for an "easy" setup experience: http://blogs.technet.com/b/mwiles/archive/2009/02/19/east-setup-of-srs-with-config-manager-r2.aspx . You should be able to skip down to the section titled Configuring Properties for the Reporting Services Point near the bottom. Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys I did the setup and can copy over the reports without issue. I still get the same error and nothing shows up on the web site.