Re: Installing SQL Server Reporting Services

From: Alex (alim_at_rogers.com)
Date: 01/21/05


Date: Fri, 21 Jan 2005 08:15:19 -0500

Hi Chad,

Thank you for the reply.

Yes. SQL Server is at SP3a and default instance as well as default IIS. I
installed SBS on a brand new server and installed SQL Server and reporting
server. All settings were default.

Alex

"Chad A. Gross [SBS MVP]" <chad.gross@laytonflower.nospam.com> wrote in
message news:u0x8%23E2$EHA.3424@TK2MSFTNGP11.phx.gbl...
> Hi Alex -
>
> SQL is running SP3a? I'm assuming we're installing Reporting Services to
a
> default SQL instance as well as the default web site in IIS? Perhaps
> uninstall & reinstall Reporting Services.
>
> I have Reporting Services running on a few different SBS boxes - never had
> an issue installing, etc. . . .
>
> --
>
> Chad A. Gross - SBS MVP
> SBS ROCKS!
>
> www.msmvps.com/cgross
> www.gosbs.org
>
>
> Alex wrote:
> > Hi,
> >
> > I have installed SBS 2003 premium andSQL Server 2000 on my server with
> > default settings and patched it using Windows Update site. Also,
> > installed SQL Server reporting services. During setup, it warned me
> > the Sharepoint is installed (I don't know how Sharepoint got
> > installed) and at the end, it failed to initialize reporting
> > services. Now, when I enter "localhost/reports" in address line of
> > IE, I get this error message:
> > The underlying connection was closed: Unable to connect to the remote
> > server.
> >
> > I checked SRM*.log error log and found an error message:
> > <Func Name='Do_Activate_ReportService'>
> > <Func Name='CreateProccessAndWait'>
> > Error reported by child process:
> > Failure starting the web service:
> > The Report Server Web service has not generated a public key. The
> > service may not have started successfully. Check the log files for
> > more information.
> >
> > <EndFunc Name='CreateProccessAndWait' Return='1603' GetLastError='0'>
> > Error 1603 Launching RSActivate.exe:
> > C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe
> > "C:\DOCUME~1\alim\LOCALS~1\Temp\RSActivate.exe" /c "C:\Program
> > Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\RSReportServer.config"
> > Do_Activate_ReportService: Activation Failed!
> > <EndFunc Name='Do_Activate_ReportService' Return='0' GetLastError='0'>
> > <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> > -----------------------------------------
> >
> > When I execute RSActivate on command line, I get the same error (The
> > Report Server Web service has not generated a public key).
> > I played with settings of reporting services installation (service
> > account and SQL Server user) in hope to get it installed successfully
> > but it always fails.
> >
> > Do you have any idea about my problem?
>
>



Relevant Pages

  • Re: Cannot upgrade SQL Server 2005 Reporting Services from Standard to Enterprise
    ... I should set up a test machine and try to reproduce this problem. ... I'll try it out as soon as I find an available test machine on my test server. ... There is no constraint in my installing extra components/features. ... > 4035) Server that is running SQL Server 2005 Reporting Services, ...
    (microsoft.public.sqlserver.setup)
  • 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: Reporting Services DISABLES DEFAULT Transaction Isolation Level!!!
    ... installing RS specifically, while I see it without such install. ... Tibor Karaszi, SQL Server MVP ... > Server when run pre- and post- Reporting Services install. ... > It's like the Reporting Services team removed the read committed isolation ...
    (microsoft.public.sqlserver.server)
  • Reporting Services Installation Woes
    ... Below is my experience with Reporting Services as well as ... I could never get past this on Windows Server 2003, ... Local Database and Application Server: ... SQL Server 2000 Enterprise Edition w/ SP3a ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server Reporting Services
    ... SQL is running SP3a? ... uninstall & reinstall Reporting Services. ... an issue installing, etc.. ... > I have installed SBS 2003 premium andSQL Server 2000 on my server with ...
    (microsoft.public.windows.server.sbs)

Loading