November 3, 2010 at 4:47 am
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
November 3, 2010 at 6:42 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply