Archive for February, 2009

Uninstalling Microsoft Sharepoint Services x64

February 3, 2009

Uninstalling Sharepoint Services in a 64 bit server with Windows 2003 SP2 by using add/remove programs leaves behind some internal databases.

Furthermore, uninstalling it appears to have an impact in IIS, wherefore IIS needed to be uninstalled, reinstalled.

Here are the steps followed, part of them found ‘googling’ for Sharepoint Services x64 uninstallation / IIS uninstallation.

1. Remove SharepointServices using add/remove programs.
2. Go to C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSQL\DATA and manually
 remove all sharepoint internal databases
3. Remove IIS
4. Reboot the machine
5. run aspnet_regiis –ir (notice that if you run
aspnet_regiis -i in the x64 system it not only doesn't work but
the message that appears seems to imply the need to look for
another application that does the same task.)
6. Go to add/remove > Microsoft .net2.0 Framework service pack 1
7. Go to IIS Manager, Web Service Extension - ASP.NET v2.0.50727
set it to Allow
8. Reinstall Sharepoint.  Notice that the default web site is
disabled. Enable it and thus the process ends.

After going through the above steps the installation worked reliably.



On Automating Windows Tasks

February 1, 2009

The past month I was assigned the task of automating the installation of a software package that uses msi files and then setup dialog windows.
Python (download_Python) has excelent libraries for this task:
Python Windows Automation

There is a great video that demonstrates the usage of the pywinauto: pywinauto_video

Follow the instructions in the page to download it (download_Pywinauto) and install it.
The above program will allow you to open and identify windows and control buttons using the application class, that can be found in the file
Notice there that the combo boxes are controlled using its name. Internally the tool finds the window’s handle.
For some applications the window’s fields are hard to handle. This is because the fields don’t have unique names.
The way to handle this situation is to tab around the page until you land in the right field.
To this end download the Sendkeys tool, also in the page (download_Sendkeys). Make sure that you select the ‘Binaries’ download. Select the version that corresponds to the python version you have installed.
Once you have installed these two tools you can start controlling the windows and its contents.
Omar Flores