Post reply

Help reqd for MSDE 2000 Server 2000 Desktop Engine

  • March 7, 2005 at 2:42 pm

    #185481

    Hi all,

    at our college we have SQL Server 2000 installed. Students write ADO.NET apps to interact with their own databases.

    Some students want to do work at home.

    I know you can download and install the free MSDE 2000 Server 2000 Desktop Engine.

    I would like to know what 'issues' you consider important if a student wants to install and run this software at home. Or is it simply install and use and don't worry about any administration?

    BTW, I'm quite used to using SQL server databases but know very little about the administration side of the business.

    Stu

     

  • March 7, 2005 at 3:10 pm

    #545791

    With the SP3 install of MSDE 2000, the default install only communicates via shared memory, so its pretty secure in terms of outside attacks. It's only when you enable other network protocols that the standard things like firewalls, strong sa password and using windows security become an issue.

    --------------------
    Colt 45 - the original point and click interface

  • March 8, 2005 at 9:03 am

    #545897

    MSDE is a reasonable subsititue if the users don't need gui-based tools like Enterprise Manager and Query Analyzer.  OSQL is a good substitute for QA if the students know their T-SQL.  We use MSDE as the database engine for our smaller clients and they run without a problem.

    HTH

    Don

  • March 9, 2005 at 3:08 pm

    #546247

    Thanks guys

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

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