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
Thanks for the reply. I have already done the upgrade using Windows
Authentication. I just want to know why SQL Server Authentication Mode has
problem since it is one of the option during upgrade.
Peter