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)
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

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.

I was reading a very interesting article on coding horror the other day (http://www.codinghorror.com/blog/archives/001006.html) about browser wars.
This got me thinking about how much Microsoft must be worrying about how the enhancements in browsers and related technology will effect there business model.

When you think about it, most there money comes from selling operating systems and Office products. Now, browsers are becoming more and more the platform of choice to write applications on. it makes sense really.

The app will run on any device with a net connection (including phones, pda’s etc), you can almost guarantee it will work, there is no need for the user to install software, updates are easy to roll out, ease of distribution, the list go’s on and on.

While as it stands there aren’t to many office based application that can challenge the MS office in the features category, there are certainly very capable alternatives out there, the main one being Googles offering, Google docs (http://docs.google.com/). All the documents are saved online, so you can give other people access to them and wherever you are in the World you will always have access to your data.

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

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