Summary
Microsoft SQL Server 2000 and Microsoft Desktop Engine (MSDE) 2000 both use the same main executable and, therefore, require special configuration to distinguish between the two applications. This technical note describes how the two can be separated into distinct license units by specifying a Globally Unique Identifier (GUID) for one of the applications.

Important Note: The information in this technical note applies to Express Software Manager version 7.6 and earlier. If you are running version 8.0 or above, SQL 2000 and MSDE 2000 will be automatically configured. If you manually configured them using this process on a pre-8.0 version, you should unconfigure both license units and reconfigure them by selecting Tools/Automatically Identify License Units in the Administrative Console.

How to Configure SQL Server and MSDE as Distinct License Units
By default, Express Software Manager identifies applications by using the main executable of an application. In addition, the product uses Globally Unique Identifiers (GUID) to identify suites. The GUID technology can be used to separate applications that use identical main executables such as Microsoft SQL Server and Microsoft Desktop Engine.

Note: This procedure can be used for any similar applications provided a unique GUID is present for each that you want to separate out from the default. The following procedure will allow you to configure Microsoft SQL Server 2000 and Microsoft SQL Desktop Engine 2000 so they are viewed as separate License Units.

1. From the Express Administrative Console, navigate to the License Units panel.
2. Expand the Full list folder so the entire list of License Units is displayed in the left-hand pane.
3. Select Microsoft SQL Server from the list.
4. In the right panel you will see a list of application versions that make up the license unit. For example, you will at least see one entry named Microsoft SQL Server and a version. In this example, let's assume that Microsoft SQL Server, version 2000 SP3 is listed.
5. Double click on Microsoft SQL Server, version 2000 SP3 in the right panel to display the properties dialog for this application.
6. Click on the Browse Button.
7. Click on "Only show Windows programs on the selected machine."
8. Search for a computer that you know has Microsoft SQL Desktop Engine installed and not a full version of Microsoft SQL Server.
9. Select the machine in the left panel and in the right panel find Microsoft SQL Server Desktop Engine. Select Microsoft SQL Server Desktop Engine and click OK. You will notice that the GUID field in the Application Properties dialog box is populated with a long number. Click OK.
10. Right-click on the new Microsoft SQL Server Desktop Engine entry in the right-pane (with a GUID) and select Convert to License Unit.
11. Select the new Microsoft SQL Server Desktop Engine License Unit in the left pane. In the right pane you will see Microsoft SQL Server Desktop Engine 8.00.760. Right-click it and select copy. Select the Microsoft SQL Server in the Left pane and in the right pane (anywhere) right-click and choose paste. When Microsoft SQL Server Desktop Engine 8.00.760 is pasted, double-click on it (notice that the GUID that referred to MSDE is gone as this will now reference the full version of Microsoft SQL Server, version 2000 sp3). Rename it to Microsoft SQL Server, change the version to 2000 sp3, and click OK.

Note: Microsoft SQL Desktop Engine 2000 has been broken out by GUID for reporting, however, this doesn't change the fact that both applications share the same main executable file name and size. As a result, if you drill into the specific executable and look at the Locations tab it will still show all machines for both applications. Reports use the license unit configuration information and thus will correctly reflect the machines that have Microsoft SQL Server installed and the machines that have Microsoft SQL Desktop Engine installed.

This example is unique because Microsoft SQL Server 2000 does not have a GUID associated to it. See the Express Software Manager Help topic "Differentiating similar license units" for information about configuring other applications such as Microsoft Project Professional and Standard.

Important Note: If you are running Express Software Manager version 7.6, this procedure requires that you apply a SQL script. Download 7.6SP2_Hotfixes.zip and review 7.6SP2_Hotfixes_Readme.txt for installation instructions. Also note that in version 7.6, the fact that two license units share the same application means that the version number will be the same for the application in both.