Member Avatar for RonR

I am ready to start using MSDE.

When I run the setup for MSDE it tells me I need to set the password. I have read the "help" on the MS web site but it is still not clear to me how I setup the password or anything else so I can get started.

I have found 3rd party Client tools that I can get a free trial. Do I need to get the Client tools BEFORE running the MSDE setup program??

  • 2 Contributors
  • 2 Replies
  • 128 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by RonR

Dani AI

Generated

Short answer for : the MSDE installer only forces you to enter a SQL Server password when you choose SQL (mixed) authentication. If you pick Windows authentication only, you won’t be prompted. Many applications expect a SQL login (the sa account), so choosing mixed mode and entering a strong, recorded password is common. For unattended installs you provide the password in the installer answer file/command line (check the MSDE/SQ L Server silent‑install docs).

You do not need client tools before installing MSDE. MSDE is just the database engine; management GUIs (Enterprise Manager/Query Analyzer or third‑party tools) can be installed later or run from another machine. Use client tools that are compatible with SQL Server 2000/MSDE to avoid version mismatches.

Quick post‑install checklist and tips:

  • Verify the SQL Server service is running and configure it to start automatically if required.
  • Confirm authentication mode and test both Windows auth and the sa login if you set one.
  • If you need remote connections, enable the server network protocols and open the server port in any firewall.
  • Create at least one Windows account or SQL login in the sysadmin role so you aren’t locked out of administration.
  • Install the latest service packs/patches and put a backup schedule in place.
  • Keep in mind MSDE is intended for small workloads (it includes a performance governor); plan to upgrade if you expect significant concurrency.

Troubleshooting pointers: run setup with administrative rights, check the setup logs and Event Viewer for errors, and if the sa password is lost you can recover it by starting the server in single‑user mode and resetting the account. As noted, checking the service status after install is a good first step.

Recommended Answers

All 2 Replies

Member Avatar for percent20

Here is how to set it up.
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

Then you must go into services and start

MSSQLSERVER
SQLSERVERAGENT

Make sure both are on automatic.

The get MSDE Manager free here:

andyou are ready to go.

Member Avatar for RonR

thanks for the info!!

I will give it a try.

RonR

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.