Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jul 2, 2004

Microsoft SQL Server 2000 Desktop Engine MSDE - Page 2

By Don Schlichting


Once the installation is complete, the SQL Server Service Manager will appear in the task bar showing the green SQL Server running symbol. However, that will be the only familiar SQL GUI. There will not be any applications or shortcuts on the menu to help manage MSDE. This seems to be why many of the questions on the MSDE newsgroup appear. Now that the Desktop Engine is installed, how do I use it? A common way to manage MSDE is from a remote machine running the full SQL Server product. In this example, we will assume a desktop with a full SQL Sever install wants to manage the Desktop Engine on some remote server machine. The first step in remote management is to ensure that TCP/IP is running the MSDE server. Navigate to the "Microsoft SQL Server\80\Tools\Binn" directory. From there, execute SVRNETCN.EXE. This will bring up the SQL Server Network Utility. Add TCP/IP to the enabled protocols.

Return to the desktop machine and launch SQL Server Enterprise Manager. We are going to add the MSDE server into the Enterprise Manager, just like any other SQL Server edition. Right click the "SQL Server Group," and select "New SQL Server Registration," then click Next. Enter in your instance name, in my case, the MSDE instance is called "test."

On the next screen, select your Authorization method, and next. Select a Group then finish. There should be a success message:

From here, expand the Group, and your MSDE server will appear. It now can be managed remotely like any other SQL Server version. Query analyzer will also function.

Local Management

There are many third party tools for local management of MSDE. Microsoft also offers a free web based admin tool "SQL Server Web Data Administrator" at http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en .


The Microsoft SQL Server Desktop Engine can be an effective, low cost replacement for Access based low volume applications. Remember, it's SQL Server, so either the user will have to install MSDE, or an install script will be needed. MSDE is not a flat file that can be shipped with your application like Access can. In spite of the added installation requirements, MSDE offers true transactions, with the same TSQL language used on every other SQL Server variation.

» See All Articles by Columnist Don Schlichting

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM