Installing Service Pack 3a for MSDE

If you are using Aurea List Manager with MSDE, Lyris Technologies recommends that you install Microsoft SQL Server 2000 Service Pack 3a for MSDE so that your server is not compromised by the Slammer Worm.

To install Microsoft SQL Server 2000 Service Pack 3a for MSDE

1.  Shut down ListManager and MSDE.
2. Backup your database. View backup instructions.
3. Download MSDE2000A.exe from http://www.microsoft.com/downloads .
4. You will be prompted to create a SQL2KSP3a folder on your c: drive.
5. After the files are extracted in the SQL2KSP3a directory, use the command line to change to the SQL2KSP3a/MSDE directory.
6. From the command prompt, run the following command:
   • setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=yourpasswd
   • * Keep in mind this might take several minutes to update.
7. Restart MSDE and ListManager.
8. If ListManager has problems connecting to MSDE, run the SQL Server Network Utility to enable TCP/IP and Named Pipes for the enabled protocols. To do so:
• Click Start
• Click Run
• Enter SVRNETCN.EXE, and click Ok.
• Add TCP/IP and Named Pipes for the Enabled Protocols.

If you are running a version of MSDE other than the version bundled with ListManager, you should contact the vendor who distributed your version of MSDE for upgrade and patching instructions.