Tutorials and Code

ActionScript (5)
ASP (7)
ASP.NET (28)
Assembly (1)
C (6)
C# (132)
C++ (33)
CSS (6)
General (4)
HTML (6)
Java (28)
JavaScript (38)
MySQL (2)
Objective C (1)
Pascal (1)
PHP (61)
Python (3)
Ruby (18)
Silverlight (1)
SQL (7)
VB.NET (5)
Visual Basic (3)

Syndication

My Account

Community Forums

Webmaster Tools

Tech Jobs

Geekpedia » SQL Tutorials » Setting up MS SQL Server 2000

Setting up MS SQL Server 2000

This guide will show you how to install the Microsoft SQL Server Desktop Engine 2000A for your localhost server.

On Sunday, June 6th 2004 at 11:02 AM

By Andrew Pociu (View Profile)

(Rated 4.2 with 30 votes)

Contextual Ads

More SQL Resources

MSDE is the free version database for developing purposes. Perfect for learning at localhost

. This guide shows you how to set it up on Windows XP (it works on other similar operating Systems - Windows 2000, Windows 2003, etc.).

Download Microsoft SQL Server Desktop Engine 2000A from Microsoft Website:

Download from Microsoft

Extract the package. Use the default path (C:\MSDERelA).

Open Command Prompt and if you are already in drive C: (if not type 'C:') enter the setup directory using 'Change Dir':

CD C:\MSDERelA

You must execute setup.exe with a parameter that specifies a password, therefore using the following in the command prompt:

setup.exe SAPWD="yourPassword"

replace yourPassword with your own password, of course

.

There are other parameters with which you can install SQL Server Desktop Engine. Consult the file named ReadmeMSDE2000A.htm for details.

After the demanded restart, look into the taskbar, it should be a icon that looks like a server, and the classic play (>) that means the server is running.

Installing Microsoft SQL Web Data Administrator

It's a great free utility provided by Microsoft for administrating your database. You can download it from here.
It has only a bit over 3 MB so it won't take much to download.
There's no trick with installing this one, after running the downloaded file (setup.msi).
Start the newly installed application from the Start menu. Press start in the window that shows up (leave the setting unchanged, by default IIS option is selected).
A browser window will open 'http://localhost/webadmin/default.aspx', the place from where you'll manage you databases.
Normally you just press the Login button and leave the fields with their default value, this should take you to the available databases.

Also some related tutorial that you might be interested in is Setting up your ASP .NET server (IIS).

Digg It!

Del.icio.us Reddit

StumbleIt

Newsvine

Furl

BlinkList

Rate this tutorial

Current Comments

by Filip on Friday, December 3rd 2004 at 06:15 AM

Thanks!

This is a short but realy great and helpful tutorial!

by Muhammad Mudassar Sa on Thursday, January 6th 2005 at 06:42 AM

i neet that tutorial

by Jon Ronnenberg on Monday, January 10th 2005 at 06:44 PM

I spend a lot of time trying to log in using Microsoft SQL Web Data Administrator in vain. But I found a post at SQL Junkies that probably could save others the headacre http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=2084

by Nayyar on Saturday, March 19th 2005 at 07:00 AM

it really comprehensive and helpful.

by turik on Tuesday, March 29th 2005 at 11:12 PM

where is the tutorial

by sharif on Friday, April 22nd 2005 at 07:52 PM

this tutorial was simple and really helped me out!

by Jake on Friday, May 13th 2005 at 09:04 AM

You folks have made the complicated simple... wish everyone thought the way you do!

by rink on Tuesday, August 2nd 2005 at 12:11 PM

i've already tried this, but my computer did not restart and there's no server icon in my taskbar. Is it because i have mySQL in my computer??

by Jon Ronnenberg on Thursday, August 11th 2005 at 11:34 AM

rink, first of all you must have SQL-Server desktop edition installed...

by Charlie on Saturday, October 22nd 2005 at 01:05 PM

wow Thank you I have been trying to get any MS SQL installed But this put it to Basics of MS

by Jackie on Saturday, October 29th 2005 at 06:43 AM

Brilliant! Simple enough to follow easily and works like a treat! Has saved me hours!

by Anonymous on Wednesday, March 8th 2006 at 06:41 AM

I'm having trouble connecting to my MSSQLServer. I want to connect to it from my PC. I can see the Server, but when I try to connect to the SQL Server to see the databases I get an error saying that the server is not found or access is denied. Any thoughts on what I might be doing wrong? I'm using MS Visual Studio.Net to connect from my pc to my server that is on my network.

by manisha on Tuesday, June 6th 2006 at 07:39 AM

how to import and export data using DTS?

by Madhu on Tuesday, June 13th 2006 at 05:22 AM

pl tell me where can i get the tutorial

by patrick on Tuesday, August 22nd 2006 at 01:41 AM

HI

Thanks for alll

Extract the package. Use the default path (C:\\MSDERelA).

Open Command Prompt and if you are already in drive C: (if not type \'C:\') enter the setup directory using \'Change Dir\':

CD C:\\MSDERelA

You must execute setup.exe with a parameter that specifies a password, therefore using the following in the command prompt:

setup.exe SAPWD=\"yourPassword\"

replace yourPassword with your own password, of course .

There are other parameters with which you can install SQL Server Desktop Engine. Consult the file named ReadmeMSDE2000A.htm for details.

After the demanded restart, look into the taskbar, it should be a icon that looks like a server, and the classic play (>) that means the server is running.

I HAVE GOT INSTALLED BUT UNABLE TO OPEN THE ENTERPRISE MANAGER

ERROR REPORTS Snap-in failes to initialize

please hep me