Geekpedia Tutorials Home

Building a C# Chat Client and Server

Building a C# Chat Client and ServerA step by step tutorial teaching you how to create your own chat client and chat server easily in C#, for local networks or the Internet.

in C# Programming Tutorials

Getting Hard Drive Information

Getting Hard Drive InformationA C# tutorial showing you how to make use of WMI to extract information on disk drives, such as model, capacity, sectors and serial number.

in C# Programming Tutorials

UPS Shipping Calculator

UPS Shipping CalculatorThis tutorial will teach you how to calculate the shipping cost based on the weight, height, length and depth of the box, the distance and the UPS service type.

in PHP Programming Tutorials

Create Your Own Rich Text Editor

Create Your Own Rich Text EditorCreating a Rich Text Editor using JavaScript is easier to do than you might think, thanks to the support of modern browsers; this tutorial will walk you through it.

in JavaScript Programming Tutorials
Search
Tutorials
Programming Tutorials
IT Jobs
From CareerBuilder

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
Advertisement
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 Digg It!     Del.icio.us Del.icio.us     Reddit Reddit     StumbleUpon StumbleIt     Newsvine Newsvine     Furl Furl     BlinkList BlinkList

Rate Rate this tutorial
Comment 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

by Patrick de Ruijter on Friday, June 13th 2008 at 03:42 AM

Even in 2008 this was helpfull for me, thanks.

by SATISH on Thursday, September 4th 2008 at 06:27 AM

MSDERelA

by Howie on Wednesday, October 29th 2008 at 08:31 PM

You are a lifesaver! I would have been lost without this tutorial and the one for setting up ASP .NET 1.1. Thank you.

by kara on Sunday, January 3rd 2010 at 03:22 AM

404 at the link to download web data administrator :(

by Bibin on Sunday, July 4th 2010 at 04:17 AM

Thanks very helpfull

by Shahriar Nour Khondokar on Tuesday, July 6th 2010 at 09:01 AM

Check this article ( http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html ) for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.

Shahriar Nour Khondokar: http://www.shahriarnk.com/

by Shahriar Nour Khondokar on Tuesday, July 6th 2010 at 09:01 AM

Check this article ( http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html ) for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.

Shahriar Nour Khondokar: http://www.shahriarnk.com/

by wesley wood on Sunday, July 18th 2010 at 05:17 PM

vcry good tutorial

by love poems on Saturday, August 13th 2011 at 03:57 PM

Nonsense is everything, so we pauperism to sure that there are values on what we are sex to fact our subscribers participating. Trait them vexed is one perception we moldiness connectedness do!

by retirement wishes on Monday, August 15th 2011 at 04:22 AM

I rale enjoyed this ringing leger. Savor existing them event. Greets !This is a in fact certain see for me, Unoriginality mate that you are earthborn presuppose of the incomparable bloggers I e'er saw. Thanks for similarity this consultive article.

by poems on Tuesday, August 16th 2011 at 02:00 AM

I accept your website perfect for my needs. It contains wonderful and assistive posts. I circumvolve strongbox most of them and got a lot from them. To me, you are doing the towering upshot. Disseminate on this. employ at come In the end, I would corresponding to add you for making donated a presentable website

by Il barbiere di siviglia tickets on Monday, September 5th 2011 at 03:55 AM

I found this useful and attractive blog i think its very obliging and information able.I would like to thank you for the pains you have made in writing this editorial.

by shane on Thursday, October 6th 2011 at 03:28 AM

It was very well authored and easy to understand. Unlike additional blogs I have read which are really not that good.Rec to rec companies Hong Kong

by Rec to rec companies Hong Kong on Thursday, October 6th 2011 at 03:29 AM

great post

by be yourself quotes on Sunday, November 6th 2011 at 02:11 PM

Such a wonderful thing for you to do, for providing that link to microsoft. Now I can setting up MS SQL Server without problems!

by counter strike online on Sunday, November 13th 2011 at 02:27 PM

This version of MSQL server is a bit outdated but I can't see any difference between new one. Hopefully this technology evolve into something more advanced

by magazine subscriptions to United Kingdom on Monday, December 12th 2011 at 04:51 AM

thank u for providing me information on List View.
I want to know how i can display data in datalist in Newsletter layout and Thank you so much, this is easy to understand and fun to continue along with. I am a migrating VB.NET/C# Developer looking for an insight into VC .NET. I've found the VC tutorials on many sites to be confusing, and the navigation around the sites to be near impossible to use! Thanks once again.

by Florarie on Thursday, December 22nd 2011 at 09:09 AM

You need to start another tutorial, for newer versions of MS SQL Server.

by Addison on Monday, January 9th 2012 at 05:28 AM

Once you have recreated the problem and captured these steps, you can save them to a file and send it to your support person, who can then open it up and view

by Marco Island Luxury Homes on Sunday, February 5th 2012 at 10:30 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 vocab answers on Wednesday, February 22nd 2012 at 12:11 PM

This is old version of MS SQL server but all the installing process still remain the same

by Solar Power Ontario on Friday, February 24th 2012 at 05:24 AM

I am very thankful to the people who post this blog and also I have noticed that there are more people who are good in posting here.

Ontario Solar Power

by coursework help on Wednesday, March 7th 2012 at 01:15 PM

Once you have recreated the problem and captured these steps, you can save them to a file and send it to your support person, who can then open it up and view

by Teeth Whitening on Wednesday, March 21st 2012 at 10:12 AM

what a good post, I am visiting this site first time

by Teeth Whitening on Wednesday, March 21st 2012 at 10:12 AM

what a good post, I am visiting this site first time

by local seo services on Tuesday, March 27th 2012 at 05:11 AM

I've heard reports of early adopter focused sites whose social referral traffic has started to matter. But it certainly doesn't seem to be a mainstream phenomenon.

by funny april fool text jokes on Wednesday, March 28th 2012 at 10:52 AM

"you can stop eating if you don't give in to it." Please note she only said this after I told her I was losing weight.

by Term paper writing service on Wednesday, March 28th 2012 at 01:14 PM

You need to start another tutorial, for newer versions of MS SQL Server.

by Natox on Wednesday, March 28th 2012 at 07:16 PM

I've been absent for some time, but now I remember why I used to love this web site. Thank you, I will try and check back more frequently. How frequently you update your web site?

by Acne Treatments That Work on Wednesday, March 28th 2012 at 07:19 PM

I've been absent for some time, but now I remember why I used to love this web site. Thank you, I will try and check back more frequently. How frequently you update your web site?

by ClearPores on Wednesday, March 28th 2012 at 07:33 PM

I've been absent for some time, but now I remember why I used to love this web site. Thank you, I will try and check back more frequently. How frequently you update your web site?

by Pergolas Sydney on Thursday, April 5th 2012 at 07:21 AM

I really liked your article and I shared with my friends in my facebook account . Pergolas Sydney

by cheap 10 man tents on Thursday, April 12th 2012 at 05:45 AM

Incredible contribution,It is my opinion you could have unquestionably put together a site I wish to check back on on the regular basis. Keep it up.

by make money online on Friday, April 20th 2012 at 09:05 AM

I've heard reports of early adopter focused sites whose social referral traffic has started to matter. But it certainly doesn't seem to be a mainstream phenomenon.

by manchester signs on Saturday, April 21st 2012 at 09:07 AM

But it certainly doesn't seem to be a mainstream phenomenon.

by Natural gas investing on Tuesday, April 24th 2012 at 11:07 AM

I tried most of the MSQL version, and I must say... they are pretty difficult to use. The help section is not that helpful either. Quite poor, I might say...

by Cheap Cloud Server on Tuesday, May 1st 2012 at 10:16 AM

MSQL is not acually that difficult. Once you learn the basics, it's quite smooth running. You just need to always keep up to date with the updates. :)

by cell phones for sale on Wednesday, May 2nd 2012 at 09:16 AM

MySQL has a very ambitious schedule for getting its high price-performance databases up to enterprise standards. Note I did say databases. But MySQL's price-performance advantage may well hit a wall at the topend as more advanced computing through Web Services, distributed systems, and asynchronous processing in SOA and BPM workflows just demands a much higher standard of database engine.

by custom thesis on Friday, June 8th 2012 at 10:13 AM

Great blog article about the Great blog article about this topic, I have been lately in your blog once or twice now. I just wanted to say hi and show my thanks for the information provided.

by 78617 Homes on Tuesday, June 12th 2012 at 05:34 AM

This site has a lot good information on it, I check on it whenever I’m online. I wish other sites spent as much time as this one does making information clearer to readers like myself.78617 homes

by 78617 Homes on Tuesday, June 12th 2012 at 05:34 AM

This site has a lot good information on it, I check on it whenever I’m online. I wish other sites spent as much time as this one does making information clearer to readers like myself.78617 homes

by online sms messages on Friday, June 22nd 2012 at 05:54 AM

I've found the VC tutorials on many sites to be confusing, and the navigation around the sites to be near impossible to use! Thanks once again.

by auto repair brampton on Saturday, June 23rd 2012 at 01:07 AM

This is a in fact certain see for me, Unoriginality mate that you are earthborn presuppose of the incomparable bloggers I e'er saw. Thanks for similarity this consultive article.

by mississauga condos on Saturday, June 23rd 2012 at 01:09 AM

.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.

by 78617 Homes on Friday, July 6th 2012 at 03:30 AM

78617 homes
Good!This post is creative,you'll find a lot of new idea,it gives me inspiration.I believe I will also inspired by you and feel about extra new ideas.thanks

by 78617 homes on Friday, July 6th 2012 at 03:31 AM

he following time I read a weblog, I hope that it doesnt disappoint me as a lot as this one. I mean, I know it was my choice to read, however I actually thought youd have one thing interesting to say

by Eid Messages on Thursday, August 9th 2012 at 01:43 PM

the loss of retirement life as a possible choice for most, in addition to developing aggravation for many who function throughout substantial companies, this is a developing development.

by eid sms messages on Thursday, August 16th 2012 at 01:01 AM

The defeat of retreat life as a possible plectrum for most, in addition to aging frustration for dozens who role throughout substantial companies, this is a maturing development.

by Louis Vuitton Purses on Friday, August 17th 2012 at 10:31 PM

http://www.louisvuittonpursebags.org/ Louis Vuitton Purses
http://www.louisvuittonsonlineshop.org/ Louis Vuitton Outlet
http://www.greatlouisvuittonsbags.com/ louis vuitton outlet
http://www.cheap-suprashoe.net/ supra shoes
http://www.officiallouisvuittonzones.net/ louis vuitton outlet
http://www.hermesoutletsus.net/ hermes bags

by Background For desktop on Friday, August 24th 2012 at 10:33 AM

Begin just about any design diary presently together with you might be sure to identify

by Background For desktop on Friday, August 24th 2012 at 10:34 AM

Begin just about any design diary presently together with you might be sure to identify

by Background For desktop on Friday, August 24th 2012 at 10:34 AM

Begin just about any design diary presently together with you might be sure to identify

by Background For desktop on Friday, August 24th 2012 at 10:36 AM

Begin just about any design diary presently together with you might be sure to identify

by Background For desktop on Friday, August 24th 2012 at 10:36 AM

Begin just about any design diary presently together with you might be sure to identify

by Background For desktop on Friday, August 24th 2012 at 10:36 AM

Begin just about any design diary presently together with you might be sure to identify

by Background For desktop on Friday, August 24th 2012 at 10:36 AM

Begin just about any design diary presently together with you might be sure to identify

by Backlink Builder on Monday, September 10th 2012 at 07:20 AM

This is great post. I actually searched for this type of post. Thus i am here. I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post. pokies android

by Seo on Thursday, September 13th 2012 at 10:33 AM

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo

by Seo on Thursday, September 13th 2012 at 10:33 AM

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo

by Seo on Thursday, September 13th 2012 at 10:33 AM

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo

by Seo on Thursday, September 13th 2012 at 10:33 AM

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo

by Seo on Thursday, September 13th 2012 at 10:33 AM

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it….. Seo

by e urdu point on Friday, September 21st 2012 at 09:35 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point

by e urdu point on Friday, September 21st 2012 at 09:35 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point

by e urdu point on Friday, September 21st 2012 at 09:35 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point

by e urdu point on Friday, September 21st 2012 at 09:35 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point

by e urdu point on Friday, September 21st 2012 at 09:35 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point

by e urdu point on Friday, September 21st 2012 at 09:35 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point

by e urdu point on Friday, September 21st 2012 at 09:36 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post.e urdu point

by ipad apps for kids on Tuesday, October 2nd 2012 at 03:24 AM

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

by torrent downloads on Tuesday, October 9th 2012 at 04:40 AM

I'm glad that I had the fortune to stumble across your blog. It’s definitely an important issue that not enough people are talking about and I'm glad that I got the chance to see all the angles.

by Restposten Ebay on Tuesday, October 9th 2012 at 06:36 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post http://www.nulleurocent.de

by Restposten Ebay on Tuesday, October 9th 2012 at 06:36 AM

I read the post and amused to see its content. This is really a helpful post. Thanks for sharing this kind of informative post http://www.nulleurocent.de

by food storage recipes on Thursday, October 25th 2012 at 03:28 AM

This is really a helpful post. Thanks for sharing this kind of informative post http://www.nulleurocent.de

by emergency kit checklist on Thursday, November 1st 2012 at 05:18 AM

This is really a helpful post. Thanks for sharing this kind

by top resume writing services on Friday, November 2nd 2012 at 09:27 AM

Loads of excellent writing here. It was indeed very helpful and insightful while being straight forward and to the point. Thanks for the posting.

by electric dog fence installation cost on Saturday, November 3rd 2012 at 06:16 AM

I want to know more about how to use it for a website.

by where can i watch free movies online on Sunday, November 4th 2012 at 03:52 AM

I want to know more about how to use it for a website.

by on Monday, November 5th 2012 at 12:22 AM

free version database for developing purposes. Perfect for learning at localhost . This guide shows you how to set it up on Windows

by charmingdate on Monday, November 19th 2012 at 02:59 AM

Nice to be here and see your post! So appreciate! charming date


Comment Comment on this tutorial
Name: Email:
Message:
Comment Related Tutorials
There are no related tutorials.

Comment Related Source Code
There is no related source code.

Jobs SQL Job Search
My skills include:
Enter a City:

Select a State:


Advanced Search >>
Ads

From the creators of Geekpedia, a revolutionary new coupon website!

BargainEZ has coupons codes, printable coupons, bargains and it is the leading source of Passbook coupons for iPhone and iPod touch devices.

Coupons
Discover Geekpedia
Other Resources