Reporting Services setup

Every time I have to stuff around with Report Services configuration I end up frustrated!

I never bother to store encryption keys to a disk anywhere, so when I change anything (often the Admin password coz I'm lazy and often use that user to run scheduled reports) I usually end up having to re-activating the service, and re-configuring all the encrypted info with the new password. (Even if my initial changes didn't warrant it, I usually end up changing something that does)...this should've been so easy.

You get useless error info too - at the moment it's "Logon Failed" when a scheduled report runs. There's bugger all in the log files accept for the occasional "logon failed" - which, I already determined, from the previous "logon failed" on the subscription screen.

Anyway - which bloody logon!? I can run the report manually. I'm trying to use a purpose built user account to run these reports now, not the admin user, but if I change the logon details of my datasource back to the administrator it works, so it's got to be that logon right? Well then why does the report work manually?

Is it a database logon - well my use has plenty of rights in the ReportServer database - RSExec role no less. After firgging around with this for a good part of the day, it turns out, it was the RSConfig utility I was not running correctly.

Naturally, changing our Admin password, and having the RS service running using that utility (while stupid) caused the problem -as I knew. I re-ran the rsconfig utility in order to set the new password, but I only ran it with the -c command line parameter -  connection information (shhot me!) I stupidly didn't look at the details of the -e command line option, which by the way, must be run separately to the -c one. This option seem to make the same config settings, but for unattended execution.

 

So > rsconfig -e -s serverName -d databaseName -a Windows -u domainName\MyUserName -p MyPassword fixed it!

 

And by the way - not using the administrator account anymore either!  Worth the effort I guess. If only I'd run the -e option a few hours ago I'd have saved some time, but not learnt anything right?