When upgrading the database component of Enterprise Console 4.x to version 5.x the installation fails on the pre-checks page of the installer with the following error:
The logon user cannot access the database created during a previous installation.
The following error message is also shown in the 'Sophos_bootstrap [date] [time].log' file found in the installing users temp location (%temp%).
'Sophos_bootstrap [date] [time].log'
16/01/2012 10:52:59, INFO : Validating whether logged on user can access the selected sql instance... 16/01/2012 10:53:00, INFO : There is not a SOPHOS instance on the local machine 16/01/2012 10:53:00, INFO : Uninitialized COM in SQL server searcher thread 16/01/2012 10:53:16, ERROR : COM error. Connection string: Provider='sqloledb'; Data Source='(local)\MSSQLSERVER'; Initial Catalog='master'; Integrated Security='SSPI'; - Error: Unspecified error, Description: [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection. 16/01/2012 10:53:16, ERROR : System Property Check: Logged on user must have access to the database to upgrade it - FAILED
Note: This issue is also mentioned in article 113945.
First seen in Enterprise Console 5.0.0
This error occurs when using a default named SQL Server instance (sometime referred to by the instance name 'MSSQLSERVER') as it is unable to accept connections using the format '(local)\MSSQLSERVER'.
If you wish to confirm you have the issue described in this article see the Technical Information section below.
To enable the upgrade to complete, please do the following on your SQL Server machine:
For further information on how to create a UDL file see article 65525.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.