October 7, 2009 at 10:29 am
Hi all,
I just installed RS at home, and of all the 2K5 components it is the only one not running.
Server Status, Report Server/Manager Virtual Directory, Web Service ID, Initialization all need configuration, but I'm not sure what is needed.
Any quick 'How-To' guides on getting this puppy running?
Cheers,
Jake.
October 7, 2009 at 10:39 am
Jake, thats a big question and the answer to it would be very long to type out and vary by server anyway, so you might not get replies. Your best bet is going to be to google 'reporting services configuration', I am sure there are guides out there
---------------------------------------------------------------------
October 8, 2009 at 7:47 am
George is right that is a big subject, but basically if you take the defaults you are usually all set. Here's the basics for each one:
An initialized report server describes a server that can encrypt and decrypt sensitive data that is stored in a report server database (for example, stored credentials and connection strings). Report server initialization is a requirement for report server operations.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 8, 2009 at 9:10 am
Hi Jack,
Yes, at your suggestion I've taken the defaults for the Virtual Directory settings - have to say the process to get to them was a tad unintuitive - and they are fine now. Still a couple of red lights, namely:
1) Web Service ID is still acting up with "ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B".
Which I'll Google later unless anyone here has a fix, likewise
2) Server Status
"System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)"
Which again I'll Google if no answer.
Appreciate the efforts so far, I'm just building a learning platform here for the time being, so no users screaming at me... 🙂
Jake.
October 8, 2009 at 9:38 am
Jake Shelton (10/8/2009)
Hi Jack,Yes, at your suggestion I've taken the defaults for the Virtual Directory settings - have to say the process to get to them was a tad unintuitive - and they are fine now. Still a couple of red lights, namely:
1) Web Service ID is still acting up with "ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B".
Which I'll Google later unless anyone here has a fix,
check the logs in install directory\mssql.n\reporting services\logfiles might give more of a clue.
when I configure Rs I have to give modify permissions to the web services identity account (network service in my case to “C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files”
2) Server Status
"System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)"
again check the logfiles. Also have you configured the reporting databases?
---------------------------------------------------------------------
October 8, 2009 at 11:02 am
Hi George, checked those logs, it looks like everything points back to the ASP account as the root cause - whatever ASP is, I'll look it up. Got this when I tried the web service ID;
ReportingServicesService!configmanager!4!10/8/2009-17:55:18:: w WARN: WebServiceAccount is not specified in the config file. Using default: Jake\ASPNET
ReportingServicesService!library!4!10/8/2009-16:08:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'JAKE\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'Jake\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!10/8/2009-16:08:02:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'Jake\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
Then, when checking Server status, the error log looked different,but the first warning was identical:
ReportingServicesService!configmanager!4!10/8/2009-17:55:18:: w WARN: WebServiceAccount is not specified in the config file. Using default: JAKE\ASPNET
Likewise when I tried to configure the DB's, RS successfully reached UP to the part where it assigns rights, when it found that Jake\ASPNET doesn't exist.
October 8, 2009 at 11:57 am
All done, I created a user (with limited rights), all the red lights are now green.
🙂
October 8, 2009 at 12:36 pm
great, RS is a confusing litttle ******
---------------------------------------------------------------------
October 8, 2009 at 1:12 pm
Well, look on the bright side, if RS or (anything about IT) were straightforward, the users would do it themselves and we wouldn't be able to pay our ex-wives any alimony.
Btw, I'm single, footloose and fancy-free, I just have a dark sense of humour.
😀
Thanks for you help, mate!!
October 11, 2009 at 1:32 am
Hi, Jake.
In my opinion, you can refer to the url below:
http://technet.microsoft.com/en-us/library/ms159261.aspx
I believe it will be helpful for you.
Regareds,
Becklery.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply