SQL upgrade fails MSDE to 2005 express

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL upgrade fails MSDE to 2005 express -...

SQL upgrade fails MSDE to 2005 express - installer confused?

Rate Topic

Display Mode

Topic Options

Author

Message

ja 65847

Posted Wednesday, November 03, 2010 4:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 03, 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)
8.00.1100
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: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=29552

------------------------------
BUTTONS:

OK
------------------------------

*******************************

PLEASE HELP!

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.
1>

I am very confused.
Please help

Thanks

Post #1015115

Adiga

Posted Wednesday, November 03, 2010 6:42 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:05 AM
Points: 1,618, Visits: 20,899

While trying to upgrade to SQL Server 2005, the "Upgrade Advisor" is failing. Check if this discussion helps.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Post #1015166

« Prev Topic | Next Topic »

Permissions