Project Server users with MSDE 2000 installed may be vulnerable to the Slammer worm (814046)
The information in this article applies to:
- Microsoft Project Server 2002
SUMMARYWhen you install Microsoft Project Server 2002, you may
select to install SQL Server Desktop Engine (also known as MSDE 2000).
Computers with MSDE 2000 installed may be vulnerable to the Slammer
worm.
NOTE: When you install Microsoft Project Server 2002, if you click
Custom (the default option) in the Choose the type of
installation you need dialog box, MSDE 2000 is not installed. MSDE
2000 is only installed if you click or install now in the
Choose the type of installation you need dialog
box.
This article describes how Microsoft Project Server 2002 users
who installed MSDE 2000 during the Microsoft Project Server 2002 setup can help
protect their computers from the Slammer worm.MORE INFORMATIONTo help protect your computer from the Slammer worm in the
scenario where MSDE 2000 was installed during the Microsoft Project Server 2002
setup , use one of the following methods. NOTE: If Microsoft Project Server 2002 is configured to use SQL, or if
MSDE 2000 is installed on your computer, but Microsoft Project Server 2002 is
not configured to use MSDE 2000, do not use the steps in Method 2. Instead, use
the steps in Method 1, or see the "General Information About SQL Service Packs
and Updates" section of this article for information about how to apply
Microsoft SQL Server 2000 Service Pack 3 (SP3) to your installation of MSDE
2000 or Microsoft SQL Server 2000. Method 1: Install SQL 2000 Critical Update Wizard For more information, click the following article
number to view the article in the Microsoft Knowledge Base: 814372
Overview of the SQL 2000 Critical Update Wizard
Method 2: Install SQL Server 2000 SP3 Detach your Microsoft Project Server 2002 database from MSDE
2000, remove Microsoft Project Server 2002, install SQL Server 2000 SP3, and
then re-install Microsoft Project Server 2002. Use the following
steps to install SQL Server 2000 SP3 when Microsoft Project Server 2002 is
configured to use MSDE 2000:
- Detach your Microsoft Project Server 2002 database from
MSDE
To do this:
- Click Start, click
Run, type osql -U sa in the
Open box, and then click OK.
This
connects you to the local, default instance of MSDE 2000 by using the System
Administrator (SA) account. - At the Password prompt, enter the SA password, and then
press ENTER.
- Retrieve the names of the database (.MDF) and log
(.LDF) files for the Microsoft Project Server 2002 database by typing the
following text on separate lines, and then pressing ENTER after each line of
text:
select a.filename as Filename from sysaltfiles a,
sysdatabases b where a.dbid = b.dbid and b.name = N'ProjectServer'
go
This will return two rows,
one that ends in ".MDF" (without quotation marks) indicating the full path of
the database file, and one that ends in ".LDF" (without quotation marks)
indicating the full path of the log file. - Close any running transactions, detach the database,
and then detach the log files by typing the following text on separate lines
and pressing ENTER after each line:
EXEC sp_detach_db
N'ProjectServer', N'true' go
NOTE: There may be a long delay after running this command.
- After the database has been detached, move the .MDF
file and the .LDF file from the directories that were identified in step 1c to
an alternate directory.
- Remove Microsoft Project Server 2002
IMPORTANT: Before you follow these steps, verify that you have followed the
proceeding steps and backed up your .MDF file and .LDF file to a safe
location.
To do this:
- Click Start, click Control
Panel, and then click Add or Remove
Programs.
- In the Add or Remove Programs box,
click Microsoft Project Server 2002, and then click
Remove.
- Follow the onscreen prompts to remove Microsoft Project
Server 2002.
- Restart your computer regardless of whether or not you
are prompted to do so.
- Install SQL Server 2000 Service Pack 3.
To do
this:
- Visit the following Microsoft Web site:
- Select the language that matches your version of
Microsoft Project Server 2002 from the Full Download box on
the right side of your screen, and then click Go.
- Locate the download link to the SQL2KDeskSP3.exe file ,
and then click the download link to start the download.
NOTE: Non-English versions of the download will be listed as language_SQL2KDeskSP3.exe.
Where language represents
language version of the download. - When prompted, save the file to your Windows
Desktop.
- In Windows Explorer, double click the file that you
previously saved to your desktop.
- Click I Agree, to accept the License
Agreement.
- In the Installation Folder box, type
C:\sql2ksp3, and then click
Continue.
- Click Start, click
Run, and then type the following command in the Open
box
C:\sql2ksp3\msde\setup.exe
sapwd="strong_pwd"
securitymode=sql
where
strong_pwd is your System Administrator (SA)
password. - Click OK.
- Attach your Microsoft Project Server 2002 databases to the
MSDE 2000 that you previously updated with SQL Server 2000 Service Pack
3.
To do this:
- Click Start, click
Run, type osql -U sa in the
Open box, and then click OK.
This
connects you to the local, default instance of MSDE 2000 by using the SA
account. - At the Password prompt, enter the SA password that you
previously set in step 3h, and then press ENTER.
- Attach the Project Server .MDF and .LDF files by typing
the following text on separate lines, and then pressing ENTER after each line
EXEC sp_attach_db @dbname=N'ProjectServer', @filename1=N'
mdf_path',@filename2=N'ldf_path' go
where mdf_path and
ldf_path are the paths to the MDF file and the LDF
file that you previously backed up to a safe location in step 1e.
NOTE: There may be a long delay after running this command.
- Create the MSProjectUser and MSProjectServerUser SQL
logins. To do this, type the following text on separate lines, and then press
ENTER after each line
EXEC sp_addlogin
N'MSProjectServerUser', N'newpassword1',
N'ProjectServer' EXEC sp_addlogin N'MSProjectUser',
N'newpassword2',
N'ProjectServer' go
where
newpassword1 is the new password for the
MSProjectServerUser account, and where newpassword2
is the new password for the MSProjectUser account. - Add the MSProjectServerUser account and the MSProjectUser
account to the MSProjectRole role and MSProjectServerRole role by typing the
following text on separate lines, and then pressing ENTER after each
line:
USE
ProjectServer go EXEC
sp_dropuser N'MSProjectServerUser' EXEC sp_dropuser
N'MSProjectUser' go EXEC
sp_adduser N'MSProjectServerUser', N'MSProjectServerUser',
N'MSProjectServerRole' EXEC sp_adduser
N'MSProjectUser', N'MSProjectUser', N'MSProjectRole'
go quit - Install Microsoft Project Server 2002, and then connect to
the existing MSDE 2000 database.
NOTE: The following steps will set the server up exactly as you had
configured it so long as you click the Enter this information
later option when prompted during installation. If you customized
server settings in the Administration pages of Project Web Access, those
settings will be persisted.
- Insert your Microsoft Project Server 2002 CD-ROM in
your CD-ROM drive, and let Setup autorun to start the setup process.
- In the Microsoft Project Server 2002
Setup dialog box, click Server
installation.
- In the Type of installation dialog
box, click Custom, and then click
Next.
- In the Enter Database server
information dialog box, click Connect to an existing
database.
- In the Database server box, enter the
name of your computer.
- In the Database name box, type
ProjectServer, and then click Next.
This will open the Enter database account
information dialog box. - In the first Logon name box, enter
MSProjectServerUser. The MSProjectServerUser account is
the account that you previously specified to be a member of the
MSProjectServerRole role.
- In the Password box, enter the
password for the MSProjectServerUser account.
NOTE: This would be the password previously listed in Step 5 as
newpassword1. - In the second Logon name box, enter
MSProjectUser. The MSProjectUser account is the account
that you previously specified to be a member of the MSProjectRole
role.
- In the Password box, enter the
password for the MSProjectUser account.
NOTE: This would be the password previously listed in Step 5 as
newpassword2. - Click Next.
- In the Enter Analysis Services connect
information dialog box, click Enter this information
later, and then click Next.
- In the Select a Web site dialog box,
click Default Web Site, and then click
Next.
- In the Enter Web server information
dialog box, click Enter this information later, and then click
Next.
- In the Enter SMTP mail server
information dialog box, click Enter this information
later, and then click Next.
- In the Connect to a Web server running
SharePoint Team Services dialog box, click Enter this
information later, and then click Next.
- In the Choose a version of Microsoft
Project dialog box , click Microsoft Project Standard 2002
and/or Microsoft Project 2000, and then click Next.
This will take you to the Enter administrator password
information dialog box.
- In the Password box, enter an
administrator password. In the Confirm Password text box, re-enter your
administrator password, and then click Next.
- In the Begin installation dialog box,
click install.
This will start the installation
process.
General Information About SQL Service Packs and UpdatesHow to Obtain the SQL Server 2000 Service Pack 3 (SP3) SQL Server 2000 Service Pack 3 (SP3) is available from the
following Microsoft Web site: List of Bugs Fixed by SQL Server 2000 Service Packs
For more information, click the following
article number to view the article in the Microsoft Knowledge Base: 306908
List of bugs fixed by SQL Server 2000 service packs
The SQL Server 2000 Service Pack 3 (SP3) ReadMeThe SQL Server 2000 Service Pack 3 (SP3) ReadMe Addendum For more information, click the following
article number to view the article in the Microsoft Knowledge Base: 330022
SQL Server 2000 Service Pack 3 Readme.htm additions
REFERENCESFor additional information about how to install SQL Server
2000 SP3, view the SP3ReadMe.htm file. To access this file, download SQL Server
2000 SP3, double-click the download, allow Setup to copy the update files to
your local disk, and then locate the following folder and double-click the SP3ReadMe.htm file: For more
information about how to manage the SQL Server Desktop Engine (MSDE 2000),
click the following article number to view the article in the Microsoft
Knowledge Base: 325003
How to manage the SQL Server Desktop Engine (MSDE 2000) by using the Osql utility
Modification Type: | Major | Last Reviewed: | 8/7/2006 |
---|
Keywords: | kbvirus kbhowto KB814046 |
---|
|