When upgrading from Enterprise Console version 4.0 to version 5.0 the following error message may be displayed:
Invalid SQL Server Instance The version of SQL Server instance CUSTOM is not supported.
Note: Where 'CUSTOM' is the name of your instance.
The following error can be seen in the Sophos_bootstrapper [timestamp].log as found in the installing users temporary directory (Start | Run | Type: %temp% | Press return):
ERROR : COM error. Conexion string: Provider='sqloledb'; Data Source='(local)\CUSTOM'; Integrated Security='SSPI'; - Error: IDispatch error #3092 ERROR : Could not obtain the sql version of the current instance for upgrading INFO : Version of SQL server set to: 0.0.0
First seen in Enterprise Console 5.0.0
This error will only be shown if:
The query to obtain the version of SQL server fails to establish the version during the initial pre-checks. This allows the installer to potentially reach the "Database Details" page (providing either of the conditions mentioned in the "Issues" section above are met) before detecting that the SQL version is not compatible with Enterprise Console version 5.0.
This defect has been assigned the defect number "DEF77195" and will be fixed in a future version of Enterprise Console.
You should upgrade the version of SQL used with console 4.0 to SQL 2005 Express or higher before performing the upgrade. For more information on how to upgrade MSDE to SQL Express 2008 see the appropriate Microsoft documentation (e.g., Upgrading MSDE 2000 to SQL Server 2005 Express).
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.