Thursday, March 22, 2012

Errow whilst initializing report server!

I have an urgent problem which I hope someone can help me with.
After installation, I was told by the wizard that I needed to initialize the report server manually...
So I went to:
http://uacl-sql2/reports
It redirects to:
http://uacl-sql2/reports/Pages/Folder.aspx
And I get the following error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The system cannot find the file specified.
Does anyone know how to fix this...I have ensured that my Reports folder allows everyone to have full access...so I do not believe it is a security issue'?
Help!
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=c26e67c885b3477087ec7fc247396beb
*****************************************I can only think that you may have to use rsactivate (a command line utility
installed with Reporting Services). The syntax would be:
rsactivate -m RSServerName -u Username -p Password.
where username and password is the Windows account with admin priveleges to
the Reporting Services Service. This command would be run on the dbserver.
If this does not work you may need to use rsconfig (another installed
command line tool) prior to using rsactivate. rsconfig sets the connection
to the ReportServer database and the options can be viewed with rsconfig /?.
This should add the symetric keys in and activate or initialize the server.
Hope this helps.
Rodney Landrum, Author "Pro SQL Reporting Services" (Apress)
www.apress.com
"Jared Smith via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c26e67c885b3477087ec7fc247396beb@.SQLMonster.com...
>I have an urgent problem which I hope someone can help me with.
> After installation, I was told by the wizard that I needed to initialize
> the report server manually...
> So I went to:
> http://uacl-sql2/reports
> It redirects to:
> http://uacl-sql2/reports/Pages/Folder.aspx
> And I get the following error:
>
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help The system cannot find the
> file specified.
>
> Does anyone know how to fix this...I have ensured that my Reports folder
> allows everyone to have full access...so I do not believe it is a
> security issue'?
> Help!
> *****************************************
> * This message was posted via http://www.sqlmonster.com
> *
> * Report spam or abuse by clicking the following URL:
> *
> http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=c26e67c885b3477087ec7fc247396beb
> *****************************************|||I ran the rsactivate utility as you suggested and was returned with:
"Unable to find Reporting Services WMI namespace =on <machinename>. Reporting Services may not be installed"
Very odd...any suggestions?
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=48b8b00053c34af6b32f676a46089d07
*****************************************|||Jared,
I would check the ReportServer service on the Report Server through
Administrative Tools\Services to see if it is started. If not, try to start
it and record any errors. Also, check to see if that service is set to logon
at NT Authority\NetworkService on the Log On ta in the properties of the
ReportServer Service itself. You may need to reinstall and one of the
options during install is how you want the service to start. Have you tried
rsconfig on the Report Server? Also, I assume that the Report Server and
ReportServer database are on the same system (from the name you specified in
the URL it appears to be the case but I am only assuming)?
Rodney Landrum, Author "Pro SQL Server Reporting Services" (Apress)
www.apress.com
"Jared Smith via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:48b8b00053c34af6b32f676a46089d07@.SQLMonster.com...
>I ran the rsactivate utility as you suggested and was returned with:
> "Unable to find Reporting Services WMI namespace => on <machinename>. Reporting Services may not be installed"
> Very odd...any suggestions?
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
> *
> * Report spam or abuse by clicking the following URL:
> *
> http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=48b8b00053c34af6b32f676a46089d07
> *****************************************|||Hi Rodney,
The rsconfig appeares to run fine. The service is also running fine, however I changed the login details to be an administrator, and restarted it....
Something odd i did notice in the logs was the same error I get when attempting to initialize the report server i.e. The system cannot find the file specified.
I have pasted the log details below...any ideas?
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__11_08_2004_13_41_25.log</Path>
<SystemName>UACL-SQL2</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!c38!11/8/2004-13:41:25:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!c38!11/8/2004-13:41:25:: i
INFO: Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!c38!11/8/2004-13:41:25:: i
INFO: Reporting Services starting SKU: Standard
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Execution Log Entry Expiration timer enabled: Cycle: 44314 seconds
ReportingServicesService!runningjobs!c38!11/8/2004-13:41:25:: i INFO: Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!1140!11/8/2004-13:41:25:: i INFO: Initializing crypto as user: UACL-SQL2\Administrator
ReportingServicesService!crypto!1140!11/8/2004-13:41:25:: i INFO: Exporting public key
ReportingServicesService!library!1140!11/8/2004-13:41:25:: Exception caught while starting service. Error: System.IO.FileNotFoundException: The system cannot find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!1140!11/8/2004-13:41:25:: Attempting to start service again...
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4819
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=03200d71bc3149edb4cc19ae7dd1db2f
*****************************************

No comments:

Post a Comment