MSDE and SQL Enterprise Manager

Question

MSDE and SQL Enterprise Manager

Joseph Sylvester

SSC Enthusiast

Points: 100
More actions
August 22, 2004 at 10:22 pm

#109217

Hi,
I want to know, What is MSDE? How is it different from SQL Enterprise Manager? and Can I use it as Back-End for my ASP pages
Thanks
Sylvester

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Ashworth Grasshopper Points: 14 More actions · Answer 1

MSDE is a free version of SQL server. A workload governor severely throttles the engine beyond 5? concurrent connections, so it is very limited. It is fine for running a back-end for applications with very few concurrent connections.

Enterprise Manager is simply a client tool for managing your SQL servers. It will connect to and manage MSDE servers, but I'm not entirely clear on the licensing issues surrounding doing so.

Henk Kok SSC Eights! Points: 849 More actions · Answer 2

Hi Joseph,

In addition to Chris' answer: I think the Enterprise Manager tool requires a separate license. You can manage the MSDE without Enterprise Manager, but a lot of tasks that can be performed with simple point and click actions in Enterprise Manager are a lot more complicated when you have to use osql, a command line sql tool, that is included with MSDE. Maybe you want to take a look at the beta 2 of SQL Server 2005 Express, the successor of MSDE. I haven't had the time to look at it myself, but it looks very promising and it includes a free lightweigth management and query editing tool. Be one of the first to have your site running on SQL Server 2005! It is still in beta, so don't use it on mission critical sites. As Chris also pointed out: don't use it either if you're expecting a high traffic load on the database.

Cheers,

Henk