Replace MSDE with SQL2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: ysh (ysh-nospam-_at_9online.fr)
Date: 03/21/04 

Date: Sun, 21 Mar 2004 07:46:41 +0100

HI,

We are running SBS2000. On this same server box we have also installed
Veritas BackupExec 9.0

Unfortunately the installation path we adopted meant that BackupExec was
installed before we installed the SQL2000 component included with SBS.

We have since then installed SQL2000 and are accessing our DBs serviced by
this server.

Recently we attempted to do two things : apply sp3 to SQL2K, and update
BackupExec to version 9.1.
We were unsuccessful in both cases.

Apparently we are running version MSDE :

    Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05

    Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows
NT
    5.0 (Build 2195: Service Pack 4)

Is this a sort of SQL run-time ? Which was probably installed by BackupExec.

How can we tell W2K that it is harbouring a full fledged SQL2000 server and
not an MSDE one ?
(registry tweak ?)

Thanks in advance

YSH

Relevant Pages