+ Post New Thread
Results 1 to 6 of 6
Windows Thread, Sophos upgrade need SQL help first to u/g MSDE to Sql 2005 in Technical; We are on Enterprise Console 3 and are looking to u/g to 4.5. One of the prerequisites is upgrading from ...
  1. #1
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,286
    Thank Post
    80
    Thanked 45 Times in 31 Posts
    Rep Power
    31

    Sophos upgrade need SQL help first to u/g MSDE to Sql 2005

    We are on Enterprise Console 3 and are looking to u/g to 4.5.
    One of the prerequisites is upgrading from the MSDE version to SQL 2005.

    When I try and run the SQL 2005 setup program it finds the Sophos database but it is reporting it as:
    MSDE Version 8.00.1100

    it then fails with :
    Name: Microsoft SQL Server Desktop Engine (SOPHOS)
    Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

    Edition check:
    Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.




    From C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\LOG
    2010-11-02 12:56:19.93 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
    May 3 2005 23:18:38
    Copyright (c) 1988-2003 Microsoft Corporation
    Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)

    2010-11-02 12:56:19.95 server Copyright (C) 1988-2002 Microsoft Corporation.
    2010-11-02 12:56:19.95 server All rights reserved.
    2010-11-02 12:56:19.95 server Server Process ID is 1436.
    2010-11-02 12:56:19.95 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\LOG\ERRORLOG'.
    2010-11-02 12:56:19.96 server SQL Server is starting at priority class 'normal'(1 CPU detected).
    2010-11-02 12:56:20.39 server SQL Server configured for thread mode processing.
    2010-11-02 12:56:20.40 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
    2010-11-02 12:56:20.62 spid3 Starting up database 'master'.
    2010-11-02 12:56:20.89 spid3 0 transactions rolled back in database 'master' (1).
    2010-11-02 12:56:20.89 spid3 Recovery is checkpointing database 'master' (1)
    2010-11-02 12:56:20.93 server Using 'SSNETLIB.DLL' version '8.0.2039'.
    2010-11-02 12:56:20.93 spid5 Starting up database 'model'.
    2010-11-02 12:56:20.93 spid3 Server name is 'FP6\SOPHOS'.
    2010-11-02 12:56:20.93 spid3 Skipping startup of clean database id 4
    2010-11-02 12:56:20.93 spid3 Skipping startup of clean database id 5
    2010-11-02 12:56:21.00 spid5 Clearing tempdb database.
    2010-11-02 12:56:21.14 server SQL server listening on 10.7.43.156: 1767.
    2010-11-02 12:56:21.14 server SQL server listening on 127.0.0.1: 1767.
    2010-11-02 12:56:21.32 server SQL server listening on TCP, Shared Memory, Named Pipes.
    2010-11-02 12:56:21.32 server SQL Server is ready for client connections
    2010-11-02 12:56:21.34 spid5 Starting up database 'tempdb'.
    2010-11-02 12:56:21.37 spid3 Recovery complete.
    2010-11-02 12:56:21.37 spid3 SQL global counter collection task is created.
    2010-11-02 12:56:25.23 spid51 Starting up database 'SOPHOS3'.


    Please help as I do not know what to do now

  2. #2
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,286
    Thank Post
    80
    Thanked 45 Times in 31 Posts
    Rep Power
    31
    I am now getting this error:

    Details
    Product: SQL Server
    ID: SQLSetup90
    Source: setup.rll
    Version: 9.00.1291.00
    Component: SQL Server Setup
    Message: To continue you must provide a strong sa password.

    Explanation
    You selected Mixed Mode authentication, but did not provide a strong password.


    User Action
    Mixed Mode authentication requires that you enter a strong sa password before you can continue to the next page of the Installation Wizard. A strong password must contain six or more characters, including at least one from three of the following categories: uppercase letters, lowercase letters, numbers, and non-alphanumeric characters (such as #, %, or ^). A strong password cannot be a reserved keyword, cannot include the computer name, and cannot include the username of the person logged onto the computer. For additional information on setting strong passwords, see the "Authentication Mode" topic in Books Online.

  3. #3
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,286
    Thank Post
    80
    Thanked 45 Times in 31 Posts
    Rep Power
    31
    Any SQL expert out there?

    I've now rolled back the server to before I started and successfully installed Microsoft SQL Server Desktop Engine SP4.

    Going to ring sophos support in the morning - see if they can help!

  4. #4
    AyatollahPies's Avatar
    Join Date
    Jan 2008
    Location
    Earth
    Posts
    900
    Thank Post
    48
    Thanked 105 Times in 95 Posts
    Rep Power
    42
    Had plenty of fun upgrading Sophos to 4.5 from 3.0 at various sites myself recently.

    Can't help with your specific error, but I recommend removing all traces of Sophos, including the SQL instances, then installing the lot again from fresh. However, there is a certain order in which components need to be un-installed.

    Can't remember it off the top of my head, but will be able to tell you in the morning.

    You certainly shouldn't be having to mess around with SQL. The installer should be taking care of all of that for you.

    Should you contact Sophos, I'd phone them as they won't respond to an email or online fault log. Not in my experience anyway.

  5. #5
    AyatollahPies's Avatar
    Join Date
    Jan 2008
    Location
    Earth
    Posts
    900
    Thank Post
    48
    Thanked 105 Times in 95 Posts
    Rep Power
    42
    Ok, try removing it all in this order:

    1) EM LIbrary
    2) Enterprise Console
    3) SQL 2005 Instance (SOPHOS)
    4) Sophos Auto Update
    5) Sophos Anti-Virus
    6) Sophos RMS

    4, 5 and 6 are the client on the server, but I recommend removing them too.

    Hope this helps.

  6. #6
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,286
    Thank Post
    80
    Thanked 45 Times in 31 Posts
    Rep Power
    31
    I've emailed my database files to sophos for them to see if they can upgrade them to SQL 2005 express with a view to then me uninstalling sophos and all SQL and doing a new install.

    I've also posted my query in depth here:
    SQL upgrade fails MSDE to 2005 express - installer confused?

    for anyone who might encounter this issue and/or can offer further advice after reading my post there.

    Cheers.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 9
    Last Post: 29th September 2010, 08:47 AM
  2. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  3. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 08:46 AM
  4. Replies: 12
    Last Post: 22nd October 2007, 07:15 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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