Reporting Service and SPS

The problem when installing Reporting Services when SPS is already on the machine lies in Application Pools, however according to microsoft the installations of both systems have logic in them to detect each other and work around the problem.

This link should help: http://support.microsoft.com/kb/917826

If however this "logic" fails, you can try the following.

• Install Reporting Services (Express) and ignore all the errors it brings up.
• If your lucky the IIS reporting services directories will be created for you, otherwise use the report server configuration on the start menu to set up new directories. It simple you just click on the New button.
• DO NOT CHANGE THE APPLICATION POOLS FOR THESE NEW DIRECTORIES!!!

Got it all

Bit late to post this I guess but I actually got 3.1 in my second session!!! :)

So I went for the high dose, which was pretty crappy but I managed quite well, eventually got an immune back after about a month and now after about 2 and a half months even have some fluff on my head again.

So where am I now, well the doctor is positive. I have to wait until 3 months after the chemo before I go for a PET Scan again. Apparently something happens so the PET scans aren't that accurate if you do it too soon after the Treatment.

Anyway, so waiting till about mid November and then I'll finally be done with it!

All prayers and crossed fingers will be appreciated :)

Cannot create a connection to data source 'myDataset'

I almost pulled the hair out of my head trying to resolve this stupid error when working with SQL
Reporting Expresses Data source connection limitations;
Cannot create a connection to data source 'myDataset'

The solution is quite simple yet mystifying, the two connection strings below should be pointing to the same database

Does not work in Reporting Services Express: Server='MyDataBase\SQLEXPRESS';Database=Catalog;
Works in Reporting Services Express: Server=MyDataBase\SQLEXPRESS; Database=Catalog;

In case you miss the difference, you are apparently not allowed inverted commas around your attribute names.

Hope someone finds this helpfull