Peter wrote:
> I'm trying to upgrade the Default Instance of MSDE 2000 Release A
> which is installed with Mixed Mode and strong password to SQL Server
> 2005 Express in a Windows 2000 Server with SP4. On the Upgrade Logon
> Information screen, if I select SQL Server Authentication Mode, it
> will give me this message:
>
> SQL Server Setup Cannot Upgrade the specified instance by using SQL
> Server Creditial. You must use Windows Authentication creditial for
> the upgrade.
>
> Thanks for any help.

"Andrea Montanari" wrote:

> hi Peter,
> Peter wrote:
> > I'm trying to upgrade the Default Instance of MSDE 2000 Release A
> > which is installed with Mixed Mode and strong password to SQL Server
> > 2005 Express in a Windows 2000 Server with SP4. On the Upgrade Logon
> > Information screen, if I select SQL Server Authentication Mode, it
> > will give me this message:
> >
> > SQL Server Setup Cannot Upgrade the specified instance by using SQL
> > Server Creditial. You must use Windows Authentication creditial for
> > the upgrade.
> >
> > Thanks for any help.
>
> I never tried an upgrade... but I do think you can "go on" with the trusted
> authentication... when you are done, just use SQL Server Management Studio
> Express
> (http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en),
> log in as a local Admin, select the server node and access the instance's
> "properties"... select the "Security" tab (ok, it's no longer a "tab", but
> hope you'll understand :D ) and set the "Server authentication" property as
> required...
> then access the Security-Logins node and access the "sa" logins properties..
> provide a strong password and verify, in the "Status" tab the login is
> "enabled"..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> --------- remove DMO to reply
>
>