PureMessage for Microsoft Exchange: Unable to connect to \local\SOPHOS when upgrading to or installing version 3.0.2

Issue
When attempting to install PureMessage for Microsoft Exchange, or upgrade from a previous version, you receive an error message:

Unable to connect to \local\SOPHOS.
Please ensure that the selected SQL Server instance is available,
that you have the access rights to connect to it, and that it is a supported version.
Please check the documentation for supported SQL Server versions and service pack levels.

Sophos product and version
PureMessage for Windows Exchange 3.0.2

Operating system
Windows 2000
Windows 2003

What to do

• If you installed the default Sophos database while installing a Sophos product in the past, follow the instructions given below for Upgrading MSDE
• If you installed and use SQL, follow the instructions given below for Upgrading SQL .

Upgrading MSDE

Check which version of MSDE 2000 you are using:

1. Open 'Add/Remove Programs'
2. Locate 'Microsoft SQL DesktopServer Engine (SOPHOS)'
3. Select 'Click here for support information'.
   
   Compare the version you are using to the table below:

   Supported	Not supported
   8.00.2039 - MSDE 2000 SP4 and later	8.00.194 - MSDE 2000 RTM
   	8.00.384 - MSDE 2000 SP1
   	8.00.534 - MSDE 2000 SP2
   	8.00.760 - MSDE 2000 SP3
   	8.00.761 - MSDE 2000 SP3a

   If you are using an unsupported version, you must upgrade now. Follow the instructions below according to whether you have Sophos Enterprise Solutions or Sophos Small Business Solutions.

Sophos Enterprise Solutions

Upgrade from MSDE to Microsoft SQL Server 2005 Express before upgrading PureMessage.

Follow this link to a Microsoft Technet white paper that describes how to do this http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx. You can also download a Microsoft Word version of the document from this page.

NOTE: The download link for .NET in the Microsoft knowledgebase article will download the beta version of the product. As this will cause problems when you try to install SQL 2005 Express. Use this link to download the full version of .NET instead:
http://www.microsoft.com/downloads/details.aspx?familyid=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en

Small Business Solutions

If you are not already using it, install MSDE service pack 4 (SP4) before upgrading PureMessage.

The steps below are taken from this article from Microsoft describing how to upgrade MSDE: http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32desksp4.htm#_install_desktop_engine_sp4.

Please be sure to read the article before upgrading.

1. From the Microsoft website, download, save, run and extract MSDE 2000 SP4 (SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE):
   http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en
2. Open a command prompt and navigate to:
   C:\SQL2KSP4\MSDE\
3. Type the command
   setup /upgradesp sqlrun INSTANCENAME=SOPHOS /L*v c:\msdelog.txt
   This will upgrade the instance. You will then be prompted to reboot.

   NOTE: If you receive a warning message
   Setup has detected that your current SA password is set to blank.
   (It then details what you should do)
   you must change the SA password from blank to a secure password. To do this

   1. Open a command prompt and type the command
      OSQL -U sa -S .\SOPHOS
   2. Press enter, type 
Password:
   3. Press enter.
   4. At line 1> type
      sp_password @old = null, @new = 'qwerty/1', @loginame ='sa'
   5. Press enter.
   6. At line 2> type go
   7. Press enter then you will see a confirmation message
      Password changed.


You can now run the PureMessage 3.0.2 installer again to complete installation.

Note: If you see the error message "Unable to run script file" during the upgrade, acknowledge the error and reboot the computer. Then, continue to install PureMessage.

Upgrading SQL

Follow the instructions below according to whether you are running SQL 2000 or SQL 2005

SQL 2000

1. Open a command prompt.
   
2. At the prompt enter the following:

   OSQL -E -S .\Sophos
SELECT @@VERSION
GO

Where Sophos is the instance name to be used by PureMessage.

Supported	Not supported
8.00.2039 SQL Server 2000 SP4 and later	8.00.194 - SQL Server 2000 RTM
	8.00.384 - SQL Server 2000 SP1
	8.00.534 - SQL Server 2000 SP2
	8.00.760 - SQL Server 2000 SP3
	8.00.760 - SQL Server 2000 SP3a

If you are using an unspported version, you must upgrade now.

SQL 2000 service pack 4 is available from the Microsoft website: http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en

SQL 2005 (all versions, including Express)

1. Open a command prompt.
2. At the prompt enter the following:

   OSQL -E -S .\SOPHOS
SELECT @@VERSION
GO

   Supported	Not supported
   2005.90.3042 - SQL Server 2005 Service Pack 2 and later	2005.90.1399 - SQL Server 2005 RTM
   	2005.90.2047 - SQL Server 2005 Service Pack 1

If you are using an unsupported version, you must upgrade now.

• SQL 2005 Service Pack 2 is available here http://www.microsoft.com/downloads/details.aspx?FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
  
• SQL 2005 EXPRESS, Service Pack 2, a redistributable install is provided in the Resources folder of the PureMessage 3.0.2 download and is also available here http://www.microsoft.com/downloadS/details.aspx?familyid=31711D5D-725C-4AFA-9D65-E4465CDFF1E7&DisplayLang=en