Archive

Archive for the ‘Uncategorized’ Category

SQL Server 2008 R2 Nov CTP – Uninstall issues

5 May, 2010 4 comments

I was attempting to uninstall the SQL Server 2008 R2 Nov CTP and I found the SQL server 2008 R2 (x64 in my case) uninstaller and everything appeared to go to plan, but….

When it had finished uninstalling the Icon still appeared in my list of things to uninstall. So I attempted to uninstall again and chose everything that was there and uninstalled that. Again it told me success but the icon remained.

So next I thought I will just uninstall all the other 2008 R2 items in the list, starting with something like native client, and it told me:

Warning 26002: The following products on SQL Server 2008 Native Client
– SQL Server 2008 R2 Database Engine Shared
– SQL Server 2008 R2 Common Files

I understand dependencies, so I thought fine, I will just uninstall in reverse order of precedence until I could succesfully uninstall everything. The stupid thing was I could not find these items in the list of software installed on my computer.

Firstly note the name, is not Microsoft SQL Server … so check down your list of items to see if it is not just listed at the bottom of the page in the “S” section not in “M” where all the other Microsoft SQL Server entries are.. (grrrr <– angry @ microsoft sound).

So if you still cant find it do this, go to this registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

Assume I was looking to unintall the "SQL Server 2008 R2 Database Engine Shared",

  • Search for SQL Server 2008 keys in the uninstall registry.
  • Keep searching until you find the Database engine shared install location
  • Note the “Install source”, copy the path and access that path via Start :: Run
  • Luckily I still had the install media on my machine, (it was in my downloads directory), and opening the path showed a directory with the .msi file. If you are not as lucky as me you will need to find the installation media and go to this relative path location
  • Right click on the msi and choose uninstall
  • This threw a little error,which I ignored and it then proceeded to successfully uninstall the item

    Repeat this process until you have successfully uninstalled all the items, that it is complaining about and then go back and start uninstalling from the uninstall UI those other SQL Server 2008 R2 files.

    Cheers

Categories: SQL Server, Uncategorized

SQL Server 2008 Uninstall – Restart Computer Failure

5 May, 2010 2 comments

Sometimes when attempting to uninstall SQL Server, “Setup Support Rules” performs a check and fails on “Restart Computer” with the following error;

“A computer restart is required. You must restart this computer before installing SQL Server”

So you restart your computer and try again, same error… Doh!

So now it turns out there is a bad registry entry, so if you have restarted your computer and there are actually no pending restart operations that you are aware of the do the following

  1. Leave the Setup Support Rules UI open if you are already in there
  2. Open Regedit
  3. Go to the following registry key”HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager”
  4. Delete the “PendingFileRenameOperations”
  5. Click “Re-Run” in Setup Support Rules launch the uninstall again

So now you will have passed the restart computer check and you can continue and get rid of that pesky old version of SQL Server.

Categories: SQL Server, Uncategorized

Canon CameraWindow and Windows 7

9 April, 2010 9 comments

After upgrading to windows 7 my camera software refused to work. I did a lot of searching and even emailed Canon and got a really poor response that they new about it but didn’t know when it would be fixed.

I was about to write a post to describe the work around, but found there was a new version of the software CameraWindow DC.

I have downloaded the installer for ZoomBrowser 6.5.1 for windows7/vista, I got mine here:
http://support-au.canon.com.au/P/search?model=Digital+IXUS+65&menu=download&filter=0&tagname=g_os&g_os=Windows%207

When it installs it is version 8.1.0.11 of CameraWindow DC.

And guess what… it works! Yeah, but read the following points…

1. After install you will have lost any configuration about where to download your photos. This can be reconfigured. At first I couldn’t work out how and then I noticed the nice little graphics in the top right hand corner. Mouse over them and the little gear icon is the preferences which allows you to configure the download location and options for file re-naming.

2. The blue button on the camera no longer works. You have to use your mouse and choose “Import Untransfered Images”, (or the action you want to do).

About time Canon.

Cheers

Categories: Uncategorized

Deploy reporting services web parts (RSWebParts) to SharePoint 2010

9 February, 2010 Leave a comment

I had to do this the other day and here are the short and curlies of doing it.

If you have SQL 2008 installed the RSWebParts.cab file can be found @
C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint

The stsadm.exe can be found here on a 2010 SharePoint install
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN

Cd to this directory and run this command

STSADM.EXE -o addwppack -filename “C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab” -globalinstall

The webparts are now available in SharePoint.
They show up under miscellaneous, when you try to add a web part

Categories: Uncategorized