Microsoft KB Archive/823465

= 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 =

Article ID: 823465

Article Last Modified on 2/26/2004

-

APPLIES TO

 Microsoft SQL Server 2000 Desktop Engine (Windows), when used with:  Microsoft Windows Server 2003, Standard Edition (32-bit x86)

 Microsoft Windows Server 2003, Standard Edition (32-bit x86) 

-



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 <ol> Open Windows Explorer.</li> Locate the following folder:

<Installation Drive>:\Program Files\Microsoft SQL Server\MSSQL$ \LOG</li> Use Notepad to open the error log file.</li></ol>

If the specified instance is an instance of MSDE 2000, the SQL Server error log file contains lines that are similar to the following:

<pre class="fixed_text">   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:

<pre class="fixed_text">   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 &quot;(Windows)&quot; in the product name. </li>  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:

<pre class="fixed_text">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:

<pre class="fixed_text">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) </li></ul>

Notice that the result of the query is the same as the SQL Server error log file information.

<div class="status_section">

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

<div class="moreinformation_section">

MORE INFORMATION
The problem that is specified in the &quot;Symptoms&quot; 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.

Keywords: kbbug kbtsql kbsetup KB823465

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.