Results 1 to 8 of 8

Thread: Patching MSDE

  1. 03-12-2003, 12:28 PM #1
    Mitchel
    Mitchel is offline Registered User
    Join Date
    Mar 2003
    Posts
    4

    Patching MSDE

    I am trying to determine how to patch my servers that are running MSDE. Currently all are MSDE 7 but I expect some to be upgradded to MSDE 2000 soon. When running the Microsoft basline security analyzer I get this result:
    The latest service pack for this product is not installed. The latest service pack for this product is not installed. Currently SQL Server 7.0 Gold is installed. The latest service pack is SQL Server 7.0 SP4. Now since this MSDE only, how do I go about installing this patch, verifying install? I also get this result:
    MS00-014 SQL Query Abuse Vulnerability File \\Nwnet10\C$\MSSQL7\Binn\SQLSERVR.exe has a file version [1998.11.13.0] that is less than what is expected [2000.3.1.0]. I get other results rellating to SQL 7 yet only MSDE is installed. Can anyone tell me what I really need to do to secure an installation OF MSDE?

    Thanks,

    Mitchel
    Reply With Quote Reply With Quote
  2. 03-12-2003, 12:46 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can download sp for msde from microsoft, and follow instructions in readme file.
    Reply With Quote Reply With Quote
  3. 03-12-2003, 05:16 PM #3
    Mitchel
    Mitchel is offline Registered User
    Join Date
    Mar 2003
    Posts
    4
    Thanks, I quess I'm just a little paranoid applying this to my web servers. Is there a way to determine which version of MSDE is running on a machine?
    Reply With Quote Reply With Quote
  4. 03-13-2003, 02:46 AM #4
    Markus
    Markus is offline Registered User
    Join Date
    Sep 2002
    Location
    Amsterdam
    Posts
    53
    Just run SELECT @@Version.

    I've installed SP4 on several MSDE 7.0 machines and so far no problems.
    Reply With Quote Reply With Quote
  5. 03-13-2003, 10:56 AM #5
    Mitchel
    Mitchel is offline Registered User
    Join Date
    Mar 2003
    Posts
    4
    If I am only running MSDE how do I perform the @@Version query on the server? Set up the server in Enterprise manager on another machine?
    Thanks,

    Mitchel
    Reply With Quote Reply With Quote
  6. 03-13-2003, 11:04 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can connect to msde with query analyzer or register it in em from anywhere as long as you have sql client tools on your network.
    Reply With Quote Reply With Quote
  7. 03-13-2003, 11:18 AM #7
    Mitchel
    Mitchel is offline Registered User
    Join Date
    Mar 2003
    Posts
    4

    Thumbs up

    Thanks!
    Reply With Quote Reply With Quote
  8. 03-19-2003, 02:35 PM #8
    rwendel
    rwendel is offline Registered User
    Join Date
    Mar 2003
    Location
    Jacksonville, Florida
    Posts
    52

    I use...

    I use Visual Studio .NET to manage my MSDE and run simple queries against it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules