Sonicwall Viewpoint 4.1 Installation Error: SQL Server does not exist or access denied

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.

Comments [13]

  1. I also experienced this same issue with the installation of Viewpoint 4.1. However I didn’t remove MSDE from the system. At the beginning of Phase 2, the installer attempts to install to the 127.0.0.1\SNWL database. Changing the field “Database Host/IP” to the machinename\SNWL allows the installation to complete normally. At least I hope your experience will be the same as mine.

  2. Max,

    I tried that too, but it didn’t work for me at all. I tried both the ip and localhost with no success. I even tried modifying those xml files the one Sonicwall document referred to.

    Glad to hear someone got it working without removing MSDE.

    – Julie

  3. This seemed to work for me:
    When the error occurs during step 2;
    – uninstall MSDE.
    – Install a new named instance of SQL 05 server
    (I named it SNWL)
    – set the same SA password as entered in Viewpoint setup
    – complete the Viewpoint install
    – enter for DB server “computer\Instance” and
    “jdbc:sqlserver://serverName\instanceName” in the JDBC connect string.
    …If this helps even one person from calling SonicWall tech support, then I’ve done my good deed for the day. 🙂

  4. You are the man, Steven. And I second your comments about SonicWall Tech Support. I opened a service request online two days ago, and still haven’t heard back from them. I could go into a whole rant about their support, but they just don’t seem to care.

  5. I had three instances of SQL Express with advanced services already installed (The default instance a sharepoint instance and a MS Search instance). I ran the installation of SQL Express again and, when prompted, enterted the instance name SNWL as Steven said above. I had a connection problem but forgot to enable TCP/IP on the SNWL named instance. Once I did this (In MS SQL Server Management Studio Express -> right click on the instance name in ‘Registered Servers’ pane and choose ‘SQL Server Configuration Manager…’ then choose Network Configuration of the instance nad enable TCP/IP) it worked fine.

    Thanks Steve!

  6. I had the same errors. I made the changes to the sgmsconfig.xml and web.xml files as recommended by Sonicwall tech note. When the bldmsdb.bat file still failed with “access denied” errors, I tried logging in to the SNWL database using the osql utility with the -S machinename\SNWL switch. After I could successfully login to the database, I edited the bldmsdb.bat file for all lines with the -S switch to match the value used with the osql utility. The same user name and password used with the osql utility were also added. I did not uninstall MSDE. Then the bldmsdb.bat file ran normally. It seems that schedinstall.bat and vpinstall.bat were redundant as the services were installed already, but didn’t hurt anything to run them. My Viewpoint is working now, but shouldn’t be this big of a hassle to install.

  7. Steven:

    Thanks very much. Your advice saved me much frustration!

  8. Hi all,
    I had been struggling with this for a day too, I am trying to install SGMS on one server with the SQL DB on another. Changing the fields had a connection error, I was mucking about with the JDBC url field, adding instance name etc
    In the end Maxs solution worked!

    Thanks Max
    Changing the field “Database Host/IP” to the machinename\SNWL allows the installation to complete normally
    I changed mine to 192.168.249.23\CW_INST (our lan IP and instance name)

    Nice one!

  9. Yes, I struggled with this today. This thread was very useful, but I had to change the bldmsdb.bat to replace the -U and -P parameters with -E (trusted connection) and use hostname\BKUPEXEC in the -S. It is running now.

  10. You can get phase 2 to work by ensuring the named instance is installed and specified correctly in the first and second fields. In phase 1, make sure the password you specify is the same as the password CURRENTLY used by the SA account. If you’re already on step 2, change the password for the SA account to match what you specified in phase 1. Good luck!

  11. Solution:
    Perform the following steps to continue with the installation:
    1. Exit from the Phase 2 Install by clicking “Cancel”.
    2. Open a DOS window and run the SQL Server Network Utility—SVRNETCN.EXE. Typically, this
    program is located in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn folder.
    3. If there are multiple SQL Server instances running on the system, you may see multiple entries in the
    ‘Instance(s) on this server” list box. Select the item ServerName\SNWL from the list box.
    4. Select TCP/IP from the Protocols list and click Properties.
    5. Write down the port number.
    6. Exit from the menu.

    C:\ViewPoint4\bin\postinstall.bat
    Change the database/hostip address to your computer name\SNWL
    In JDBC URL add the port number after the localhost
    e.g localhost:1127

  12. I can’t install View Point on windows 2008 server(32 bit) which already loaded with MS SQL 2005.
    Please provide more clarification on this as we are in win 2008/Vista environment(domain).

    Thanks

    1. Thank you farhad. Easiest instructions and they worked like a charge. If you want Dell ITA and Viewpoint on the same machine, only option I could find was vers 4.1 and your workaround. Cheers!

Leave a Reply

Your email address will not be published. Required fields are marked *