MSDE is included with the Visual Studio .NET and the .NET Framework SDK. You must complete its setup after you run the main software installation. You do this by running the setup.exe program from the \Setup\MSDE\ subfolder under the main Visual Studio .NET or the Samples\Setup\MSDE\ directory under the main Framework SDK installation folder.
To connect to an MSDE instance, use the SQL Server provider.
Remember, MSDE is simply a client-limited version of SQL Server. The
connection string is similar but requires a slightly different
Data Source parameter. If you use MSDE on the
local machine, and you installed it with the .NET SDK, use the
following connection string:
If you installed MSDE with Visual Studio .NET, use the following instead:
You can also replace
localhost with the name of an
MSDE server. To view the MSDE service, and start, stop, or pause it,
run the Computer Management utility (from the Administrative Tools
section of the Control Panel), and browse to the Services and
Applications → Microsoft SQL Servers node (see Figure C-1).