Post reply

MSDE security - How do I update to SP4, or do I need to?

  • May 28, 2005 at 7:34 am

    #163843

    I run Veritas Backup Exec for windows servers, and our recent scans have stated that I do not have the most current version of SQL server. I am sure that this server runs MSDE not the full version of SQL.

    After downloading the MDSE upgrade and installing from the command line with the switches as per the help file, I received a successful installation message box. I also generated a log file with the same results.

    I re-run the MSBA scan again and it still reports it as not the latest SP installed and SP 4 should be installed.

    What am I missing?

  • May 28, 2005 at 11:07 pm

    #561625

    go ahead and download the service pack from this page;

     http://www.microsoft.com/sql/downloads/2000/sp4.mspx

    note in the middle of the article it explicitly says that it is for the MSDE, and that you need to know the instance name:

    Microsoft SQL Server 2000 Desktop Engine and SP4

    Users who have an existing instance of MSDE 2000 must know how their instance of MSDE 2000 was installed to know how to update it. In particular, you must know the original package name for your instance of MSDE 2000. To determine the original package name, see the article How to Identify Which MSI File Was Used for an Existing MSDE Installation in the Microsoft Knowledge Base.

     

    HTH

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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