BUG: You may not be able to distinguish between instances of Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows) in the Add or Remove Programs entry in Control Panel (823465)



The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (Windows), when used with:
    • the operating system: Microsoft Windows Server 2003
  • Microsoft SQL Server 2000 Desktop Engine (MSDE), when used with:
    • the operating system: Microsoft Windows Server 2003

BUG # : 469531(SQL Server 8.0)

SYMPTOMS

When you install Microsoft SQL Server 2000 Desktop Engine (Windows) and Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) on your computer, you may not be able to distinguish between the two instances in the Add or Remove Programs dialog box entry in Control Panel.

WORKAROUND

You can use the following methods to distinguish between the instances of MSDE 2000 and Microsoft SQL Server 2000 Desktop Engine (Windows) that are installed on the computer.
  • Use the SQL Server error log file

    To identify whether an instance corresponds to MSDE 2000 or to Microsoft SQL Server 2000 Desktop Engine (Windows), you can use the SQL Server error log file. To do so, follow these steps
    1. Open Windows Explorer.
    2. Locate the following folder:
      <Installation Drive>:\Program Files\Microsoft SQL Server\MSSQL$<instance name>\LOG
    3. Use Notepad to open the error log file.
    If the specified instance is an instance of MSDE 2000, the SQL Server error log file contains lines that are similar to the following:

    	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 3)
    

    However, if the specified instance is an instance of Microsoft SQL Server 2000 Desktop Engine (Windows), the SQL Server error log file contains lines that are similar to the following:

    	Microsoft SQL Server  2000 - 8.00.760 (Intel X86) 
    	Dec 17 2002 14:22:05 
    	Copyright (c) 1988-2003 Microsoft Corporation
    	Desktop Engine (Windows) on Windows NT 5.0 (Build 2195: Service Pack 3)
    

    Note The product name for the instance of Microsoft SQL Server 2000 Desktop Engine (Windows) contains the word "(Windows)" in the product name.
  • Use the @@VERSION configuration function

    You can also distinguish between the instances of MSDE and Microsoft SQL Server 2000 Desktop Engine (Windows) by using the @@VERSION configuration function. You can connect to the instance of MSDE or to the instance of Microsoft SQL Server 2000 Desktop Engine (Windows) by using Query Analyzer. In Query Analyzer, run the following query to obtain the version for the instance:
    SELECT @@version

    If the current instance is an instance of MSDE 2000, the result of the query is similar to the following:
    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 3) 

    However, if the current instance is an instance of Microsoft SQL Server 2000 Desktop Engine (Windows), the result of the query is similar to the following:

    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine (Windows) on Windows NT 5.0 (Build 2195: Service Pack 3) 
Notice that the result of the query is the same as the SQL Server error log file information.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The problem that is specified in the "Symptoms" section occurs only when the instance of Microsoft SQL Server 2000 Desktop Engine (Windows) version 1.0 is installed on the computer because build number 8.00.760 for Microsoft SQL Server 2000 Desktop Engine (Windows) version 1.0 is the same as the build number for MSDE Service Pack 3. Therefore, you may not be able to distinguish between an instance of MSDE 2000 and an instance of Microsoft SQL Server 2000 Desktop Engine (Windows) in the Add or Remove Programs entries.

Modification Type:MajorLast Reviewed:2/26/2004
Keywords:kbsetup kbTSQL kbbug KB823465 kbAudDeveloper