•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 361,899 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,407 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 10755 | Replies: 2
 |
•
•
Join Date: Jan 2005
Posts: 33
Reputation: 
Rep Power: 4
Solved Threads: 0
Light Poster
Intro
Here is how to set up Microsofts MSDE for personal development.
Getting started
Download the MSDE from:
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Select 'SQL2kdesksp3.exe' and save it to your computer.
Double-click on the SQL2kdesksp3.exe you downloaded.
Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.
Start > Run > cmd
Navigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.
The default is C:\sql2ksp3
Type Setup SAPWD=(Some password) SecurityMode=SQL
Example:
c:\sql2ksp3> Setup SAPWD=password SecurityMode=SQL
After that gets done running, MSDE is installed.
Start services
To get the SQL Server running and the SQL Agent we need start the services.
right click My Computer > manage > services
Double click the following and set to Automatic.
MSSQLSERVER
SQLSERVERAGENT
Make sure both are on automatic.
Next get MSDE Manager free here: (Only free if used for personal use not corporate use.)
http://www.whitebearconsulting.com/Utilities.htm
Make the folder:
C:\Program Files\MSDE Manager
Extract files to that folder.
Open the folder and Oppsite click the mouse and drag to the desktop and select create shortcut here.
Restart your computer.
You should now have MSDE running and ready to go to start using. Use the MSDE Manager to do your basic SQL Server things.
Here is how to set up Microsofts MSDE for personal development.
Getting started
Download the MSDE from:
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Select 'SQL2kdesksp3.exe' and save it to your computer.
Double-click on the SQL2kdesksp3.exe you downloaded.
Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.
Start > Run > cmd
Navigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.
The default is C:\sql2ksp3
Type Setup SAPWD=(Some password) SecurityMode=SQL
Example:
c:\sql2ksp3> Setup SAPWD=password SecurityMode=SQL
After that gets done running, MSDE is installed.
Start services
To get the SQL Server running and the SQL Agent we need start the services.
right click My Computer > manage > services
Double click the following and set to Automatic.
MSSQLSERVER
SQLSERVERAGENT
Make sure both are on automatic.
Next get MSDE Manager free here: (Only free if used for personal use not corporate use.)
http://www.whitebearconsulting.com/Utilities.htm
Make the folder:
C:\Program Files\MSDE Manager
Extract files to that folder.
Open the folder and Oppsite click the mouse and drag to the desktop and select create shortcut here.
Restart your computer.
You should now have MSDE running and ready to go to start using. Use the MSDE Manager to do your basic SQL Server things.
Last edited by happygeek : Oct 28th, 2006 at 9:11 am. Reason: Formatting
•
•
Join Date: Jul 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
This one's real handy for new recruits at my place. Thanks. It would be useful if you could include examples for instance name and other commonly used options. There are a couple of kids in the place I work who always seeem to mess that up.
•
•
Join Date: Oct 2006
Location: Arizona, USA
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
The white bear MSDE manager has great functionality for administering the SQL Server agent (jobs and scheduling) but is is definitely lacking when it comes to general database administration.
I would highly recommend dbaMgr2K. It's quite close in functionality to SQL Server's Enterprise Manager, but free for any use. The only place it truly has shortcomings is on job scheduling, where the white bear product excels.
In addition, a good general purpose query tool is beneficial. I can highly recomend Query Express. It can connect to Oracle and SQL Server databases (as well as others via ODBC.) It is also free of charge.
Finally, users may also wish to view Deploying MSDE (Microsoft.TechNet) Class
I would highly recommend dbaMgr2K. It's quite close in functionality to SQL Server's Enterprise Manager, but free for any use. The only place it truly has shortcomings is on job scheduling, where the white bear product excels.
In addition, a good general purpose query tool is beneficial. I can highly recomend Query Express. It can connect to Oracle and SQL Server databases (as well as others via ODBC.) It is also free of charge.
Finally, users may also wish to view Deploying MSDE (Microsoft.TechNet) Class
Last edited by loquin : Oct 11th, 2006 at 2:44 pm.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- Cannot run setup for NetGear WGR614 router (Networking Hardware Configuration)
- Script wont run on different computer (Python)
- need to make setup with msde (C#)
- need a tutorial on how to setup a forum (PHP)
- ARGH!!! I need help!!! (Windows NT / 2000 / XP / 2003)
Other Threads in the MS SQL Forum
- Previous Thread: Question 9 is the only one correct, rest of them coming up syntax errors..help me
- Next Thread: Retrieve information
