Tuesday, December 18, 2007

My Blog has moved

Please note that this blog will no longer be updated. I have got some cheap webspace and now live at http://www.beakersoft.co.uk

I will still keep this blog active for a while, but there will be no new posts here. Please use my new page.

Thursday, December 13, 2007

Error trying to edit Reporting Subscription

Over the weekend we did a big upgrade, part of witch meant all the reports had to be recreated to work with the new database schema, so I told people they would have to setup any subscriptions again.

First of all I think the being able to create subscriptions is a great idea. The only downside to it is having to specify a username/password to run as (i'm not sure how you could get round this though apart from running all the subscription reports as a specific user), and the fact that it has no built in print functionally.

To get round the lack of printing, we use a product call batch print pro, available from traction-software.co.uk. It is a fantastic piece of software that you point at a directory, and it monitors in there for PDF files and sends them to a printer you specify as they drop in. The setup of it is sometimes a bit odd but it worked well.

Anyway, a user created her subscriptions again but could not edit them once they changed, she kept getting an error when hitting save:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The EXECUTE permission was denied on the object 'sp_add_category', database 'msdb', schema 'dbo'.

For some reason, when I looked on the reports server config, the windows service identity section was in an error state. I just put the username and password back in, and it worked again. I didn't even have to restart reporting services

Thursday, December 06, 2007

Internet Explorer 8 here we come

Just a quick post after my rant yesterday, seams like Microsoft is already working on a new version of Internet Explorer , at least according to the IE developer blog. You can read the entry at http://blogs.msdn.com/ie/archive/2007/12/05/internet-explorer-8.aspx

There is no mention of new features or anything yet, but keep checking back as i'm sure they will post the latest info there first.