Running Microsoft SQL Server 2005 Express Edition SP2 on Microsoft Windows Embedded for Point of Service
This article lists supported scenarios for running Microsoft® SQL Server™ 2005 Express Edition SP2 on Microsoft Windows® Embedded for Point of Service (WEPOS) systems and describes how to include the prerequisites for SQL Server 2005 Express Edition SP2 on your WEPOS images to install and deploy SQL Server 2005 Express Edition SP2 on your WEPOS devices.
SQL Server 2005 Express Edition is the next version of Microsoft SQL Desktop Engine (MSDE) and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005.
SQL Server Express Edition includes powerful features such as SQL Server 2005 Reporting Services, a server-based platform for creating and delivering traditional and interactive reports, and a graphical management tool, SQL Server 2005 Management Studio Express, for easily managing a database.
Best of all, as your needs grow, your applications will work seamlessly with the rest of the SQL Server product family.
SQL Server 2005 Express Edition SP2 is the latest version and a suitable choice for WEPOS devices that require a lightweight database engine and might have to connect to back end database servers.
For more information about SQL Server 2005 Express Edition, see this Microsoft Web site.
The SQL Server 2005 Express Edition SP2 is officially supported on WEPOS 1.1.
Most features and scenarios for SQL Server 2005 Express Edition are supported on the WEPOS platform with the following exceptions:
External stored procedures
Common language runtime (CLR) integration
To learn more about these features in Microsoft SQL Server 2005 Express Edition Books Online, see this Microsoft Web site.
SQL Server 2005 Express Edition SP2 was tested on a WEPOS image which included the following components:
Additional code page support
Additional font support
Additional input device support
SQL Server 2005 Express Edition requires enabling a virtual memory pagefile by using the System Managed Size option.
|By default, pagefile usage is disabled on WEPOS. You can enable it exactly as you would enable it on a system running Windows XP Professional. You must be logged on with Administrator permissions to enable a virtual memory pagefile.|
Additional requirements include installing the .NET Framework 2.0 and the software update found at this Microsoft Web site.To enable pagefile usage
In Control Panel, open System and choose the Advanced tab.
Under Performance, choose Settings, and then choose the Advanced tab.
Under Virtual Memory, choose Change, and then choose System Managed Size.
Choose OK to affirm your selections.
To evaluate, test and commercially ship SQL Server 2005 Express Edition SP2 on your WEPOS images, you can download the installation package from this Microsoft Web site after accepting the redistributing EULA.