Rummage through this blog

Sunday, 25 September 2011

Windows 7 Libraries

I've been driven to distraction over the last few days - Media Centre (64 bit Win 7) has lost its music and no amount of rebuilding libraries has helped.

Finally had to ask for help and cracked the problem by artificially adding then removing items from the library. Along the way I discovered that the performance of music in WMC is massively improved by stopping Windows Media Player from accessing the internet for album covers & info (set it manually and be done with it).

I also found that the default WMP on Win 7 64 bit is the 32 bit version (so you can change the short cut to point at the 64 bit folder rather than 32 bit, no problems there).

Also documented in the posts I made on The Green Button (title above is the link) are some checks to ensure folders are set correctly in the registry - they probably aren't if you've made drive / path changes.

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.

Thursday, 20 January 2011

All that glitters is not gold...

....and all that looks like icing on the Christmas cake isn't, ouch.

Tuesday, 4 January 2011

SQL Server 2005 metadata error when installing Reporting Services

Shiny new install of Reporting Services all done. Unfortuntately attempts to login to RS via SQL Management Studio give an html string error mentioning metadata problems with IIS. Attempts to access http://localhost/Reports result in an IIS error about changing permissions.

This is install problems with .Net Framework.

Just goto the v2.0.50727 folder (c:\windows\Microsoft.net\framework\v2.0.50727) and run
aspnet_regiis -ga aspnet
where "aspnet" is the name of the ASPNet user found in the list of users on the local machine.