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
Author
Message
Posted Wednesday, November 03, 2010 4:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, November 03, 2010 6:42 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 30, 2014 8:52 AM
Points: 1,618, Visits: 20,966
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 »

Add to briefcase

Permissions Expand / Collapse