Post reply

How to setup Microsoft SQL Server 2000 Desktop Engine? Please help!!!

  • May 22, 2006 at 10:16 am

    #169066

    Hi Sir,

    I had bought a ASP.net book, and the book have attach with a

    “Microsoft SQL Server 2000 Desktop Engine” CD installer, but when I install it pop out the below message:-

    - A strong SA password is request for security reasons. Please use SAPWD switch to support the same. Refer to readme for more detail. Setup will now exit.

    But I had check the whole book and CD, also cant find any ‘SA password’. Can sir/ anybody teach me how to install the “SQL Server 2000 Desktop Engine”, for my final project. Thank you!

    Regards,

    Mike

  • May 24, 2006 at 5:46 am

    #639727

    Hi,

    Just double clicking the executable doesn't do the job (unforunately).

    Check this link first:

    http://msdn.microsoft.com/library/?url=/library/en-us/distsql/distsql_84xl.asp?frame=true

    The Microsoft® SQL Server™ 2000 Desktop Engine includes a Setup.exe file that an application setup process can use to install the SQL Server 2000 Desktop Engine. You can define settings for customizing the way Setup.exe installs SQL Server 2000 Desktop Engine. These settings can be specified through either command prompt switches or an .ini file.

    The example in this section will install a new instance of MSDE 2000 that has been configured with its network connectivity enabled (DISABLENETWORKPROTOCOLS=0).

    These example install instances using the default for configuration items such as collation. The configurations can be controlled by setup parameters, such as COLLATION, DATADIR TARGETDIR and INSTANCENAME in the Setup.ini File:

    Setup.ini

    [Options]

    TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Binn\"

    DATADIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Data\"

    INSTANCENAME=NameOfyourMSDEInstance

    By the way: You can install up to 16 MSDE instances!!

    To install a default instance configured to use Mixed Mode, execute:

    setup.exe /settings C:\Users\Test\MSDE\setup.ini

    SAPWD="manager" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

    /L*v C:\Users\Test\MSDE\MSDELog.log

    Note

    Enter all in one line, when the setup has finished consult the logfile: MSDELog.log. You should see an icon in the taskbar where you can start and stop MSDE.

    Desktop Tools

    Install Desktop Tools (Enterprise Manager, Query Analyzer) from the SQL Server CD.

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

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