Desktop Server

1. Today I've installed webmatrix andMSDE200Aand followed this instruction

"Select 'SQL2kdesksp3.exe' and save it to your computer.

Double-click on theSQL2kdesksp3.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."

then I restarted my comp. I've tried to connect to database but it did not work.

I need the reply ASAP!!!!

2.What are the different among MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?

Fahrisal:

then I restarted my comp. I've tried to connect to database but it did not work.

Please explain "did not work".

Fahrisal:

What are the different among MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?

FromMicrosoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A andMicrosoft SQL Server 2000 Service Pack 3a I have learned:

MSDE2000A.exe is the desktop engine for SQL Server (MSDE) and includes the Service Pack 3a patch - this is all you need