Rummage through this blog

Thursday, 14 April 2011

SQL Server Installation Problem

Another day and another install of SQL Server Developer Edition (2005 in this case). Installation complete & there's no way to connect to reporting services or analysis services. Strange, no icons, nothing in the object explorer connection.

Turns out SQL Server Express edition is installed and it is a higher version that I've just tried to install so I am missing the options.

The resolution was to install using SKUUPGRADE = 1 as a startup parameter and then when that install completed I had to refer to an earlier post because management studio was still missing.

Got there in the end.

Wednesday, 13 April 2011

Sql Server Reporting Services 2005 Issue

Again SSRS 2005 has stopped working.

This time it follows install of Sql Server 2008 developer edition on my machine so I've been trying to figure out how to get both working on the same box - it is possible according to the documentation but there is no mention of how.

Unfortunately I am getting the following message when attempting to connection to Reporting Services via SQL Management Studio "unable to connect to the remote server. No connection could be made because the target machine actively refused it."

Now that's not very nice is it, I ask nicely & it does nothing.

Anyway after a few weeks of digging I've finally found my problem is not related to the Dev 2008 install - it is in fact our network wide security settings, they have been changed!

So the solution was to go into IIS Admin console, goto the properties of my default web site (which hosts my SSRS pages) and goto the Home Directory tab and then change the Execute Permissions to Script and Executables.

Job done.

Tuesday, 5 April 2011

Polarising filters

New camera, new screw in filter.

I've purchased a Panasonic Lumix FZ100 camera and needed a new 52mm threaded polariser. So one short trip to ebay later and  I have ordered a Hoya Por1 Digital filter. Rather nice all in all - however, I now conclude it is the worst polarizer I've ever owned.

Why?

Well, the first thing I managed to do is get a finger print on the glass surface, polarisers are often pigs to clean and this proved to be the case and repeated wiping with a lens cloth has caused the coatings to start wiping off.

You can't see the current lost areas (both sides) on pictures yet but as the filter hasn't been out of the house yet I can't imagine it's going to last long as pretty sure I'll have to clean it again one day.