Compartilhar via

XPe & Visual Studio 2005

  • Artigo

Background:
We've received reports from customers having problems installing the XP Embedded database after installing Visual Studio 2005. The default installation of Visual Studio includes a silent installation of SQL Express, which can cause problems with your XPe installation if it’s not configured in a specific way. Although it is possible to use SQL Express by changing the instance name according to Nick's blog article, it may be more straightforward to just install the version of MSDE included with XP Embedded.

The Problem:
If you try to install the embedded database directly into SQL Express without first changing the instance name, setup will fail, and you'll be given an error message with the text: "The Microsoft Data Engine (MSDE) or SQL Server, version 2000 or later, is required to be installed and running before you install or modify this product”, and looking very much like this:

Unfortunately, this error message is the same one you'll encounter if there is no SQL server installed on your machine before attempting to install the database.

The Solution:
So how do you get XP Embedded to work with Visual Studio or an already-installed version of SQL Express? Just install the version of MSDE included with XPe. This will create a second SQL instance named "MSSQLSERVER", which will allow the XP Embedded database to install and connect. Your existing "SQLEXPRESS" instance will be left intact for Visual Studio and any other applications to use.

Recommended Installation Procedure:
Here are our recommended steps to get the entire Windows XP Embedded suite installed. These steps are the same if you’ve got Visual Studio, another version of SQL Express, or no version of SQL at all previously installed on your machine.
1. Install the XPe SP1 Tools - From your Windows XP Embedded installation disk 1, or the Disk1 folder of your trial version download, launch Setup.exe and click Tools Setup. This will begin the installation process for the XP Embedded Tools SP1.
2. Install MSDE - Once the XP Embedded tools have been setup, you should install MSDE. This will create a new SQL server instance that is compatible with the XP Embedded database. This will not replace your SQL Express instance created by Visual Studio or another version of SQL Express. To install MSDE, click the Database Engine Setup link inside of the Setup.exe program on disk 1.
3. Install the XPe Database - When the XP Embedded toolset, as well as MSDE have been installed and upgraded, the Windows XP Embedded database setup can begin. From your installation disk 2, or your Disk2 folder, open Setup.exe and click the Database Setup link. The database setup program should connect to the newly created MSDE instance instead of the SQL Express instance created by Visual Studio, and setup should continue as normal.
4. Upgrade the XPe tools to SP2 - After the XP Embedded Tools SP1, MSDE, and the XPe Database SP1 have been installed, insert your installation disk 3, or go to the Disk3 folder and launch Setup.exe. Click on the Tools Update link to upgrade the XP Embedded toolset to Service Pack 2.
5. Upgrade MSDE - Once your XP Embedded tools have been upgraded to SP2, upgrade your MSDE installation to the latest version by clicking the Database Engine Upgrade link inside of Setup.exe on disk 3.
6. Upgrade the XPe Database - After the XPe tools and MSDE have been upgraded to SP2, click the Database Update link inside of Setup.exe on disk 3 to complete your installation.

That’s it! After following those installation steps, your XP Embedded development environment should be set up, and you’re ready to start creating images.

- Robert

Note: Robert is an intern on the Embedded Windows team this summer and is working with us on some Top Secret projects. Check out his bio linked above.

Comments