Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL upgrade fails MSDE to 2005 express - installer confused? Expand / Collapse
Posted Wednesday, November 3, 2010 4:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 3, 2010 6:43 AM
Points: 1, Visits: 3
Server is running 2003 SP2.
Database is for our antivirus product sophos.

There is only one instance on the server called FP6\sophos.

I have set a strong SA password & upgraded the instance to MSDE sp4.

When I try and run SQLEXPR.EXE (Microsoft SQL 2005 Server Express Edition v9.0.1399.6)
I untick the hide advanced options so I can target the sophos instance.

Whe it gets to the point where I choose the instance it reports the details as:
MS SQL Server Desktop Engine (Sophos)
Desktop Engine.

I proceed and choose windows authentication.

I then encounter the following ERROR:


TITLE: Microsoft SQL Server Setup

UpgradeAdvisor returned -1 .
Error message:

For help, click:





The link suggests that:

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 ^).

I did the following earlier at a command prompt:
C:\Documents and Settings\sadmin>osql -E -S .\sophos
1> sp_password @old = null, @new = 'MyStrongpassword123', @loginame ='sa'
2> go
Password changed.

I am very confused.
Please help

Post #1015115
Posted Wednesday, November 3, 2010 6:42 AM



Group: General Forum Members
Last Login: Yesterday @ 2:49 AM
Points: 1,618, Visits: 21,011
While trying to upgrade to SQL Server 2005, the "Upgrade Advisor" is failing. Check if this discussion helps.

Pradeep Adiga
Twitter: @pradeepadiga
Post #1015166
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse