At one of my client locations we use Sonicwall’s Viewpoint reporting system to gather usage data from the Sonicwall firewall and content filter. Viewpoint is a pita to upgrade or move to a new machine, and I treat the program with care, since it’s very easy to unintentionally break. I was upgrading from an old version (2.9) only because I could no longer access the administrative interface through a web browser to run reports.
One very important thing to know about Viewpoint is it will not install properly on a machine that had any previous instances of SQL Server or MSDE on it. Plus, if you want to use SQL Server instead of MSDE for the Viewpoint database, Sonicwall will not provide you technical support.
After much trial and error I found that just removing prior SQL/MSDE instances was not enough to make the installation a success. I would complete phase 1 of the installation, only to have phase 2 fail with the following error:
SQL Server does not exist or access denied
I searched the Sonicwall tech support web site and forums, but could only find one document that addressed this error, and of course it didn’t work (not a big suprise, if you’ve ever dealt with Sonicwall tech support you know what I mean)
In order to complete the Viewpoint 4.1 Installation I had to:
1) Uninstall the SQL/MSDE from Add/Remove Programs and any other software that used SQL/MSDE. In my case, I had a copy of Dell’s IT Assistant, a part of the OpenManage Management Station. Reboot.
2) Use MyUninstaller to remove Microsoft SQL Server Express 2005, even though the uninstallation process in step 1 had removed it from Add/Remove Programs.
3) Delete the sgmsconfig.xml from the root of the installation drive (C:\ in my case)
4) Rename all of the remaining Viewpoint and SQL/MSDE directories on the hard drive
5) Reboot, then run the Viewpoint installer. I was able install without problems, but phase 2 takes a looooong time, and I thought the machine was locked up. Be patient.
I did find one glitch during the installation – even though I was asked what password I wanted to use for the Viewpoint login, it was not applied. I had to use the default login and password, which you can find in the Viewpoint 4.1 Administrator’s Guide.
You may find Some of the Microsoft Knowledge Base articles I found helpful if you are having SQL/MSDE uninstallation problems:
KB 311762 – How to identify which MSI file was used for an existing MSDE installation
KB 823467 – BUG: You cannot start the SQL Server Agent Service for an instance of SQL Server or the SQL Server 2000 Desktop Engine that has the same instance name as a previously uninstalled instance of the SQL Server 2000 Desktop Engine (Windows)
KB 317619 – FIX: Cannot Remove Microsoft SQL Server 2000 Desktop Engine After You Upgrade to MSDE 2000 SP2
KB 320873 – How to manually remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) instance
KB 909967 – How to uninstall an instance of SQL Server 2005 manually
Aaron also has a detailed procedure for removing SQL Express manually. It also seems that the SQL Express uninstaller requires the .NET framework 2.0, so if you don’t have the .NET 2.0 framework, you may need to install it prior to uninstalling SQL Express.