I downloaded the new SQL Express SP2 CTP, then ran the SQLEXPR.exe. Chose
my instance and specified "SQL Server Authentication", supplied 'sa' and my
password. I get the messsage:

"SQL Server Setup cannot upgrade the specified instance by using SQL Server
credentials. You must use Windows Authentication credentials for the
upgrade."

Problem is, I've removed Builtin\Administrators group and the instance
requires SQL Server authentication.

Is this simply a CTP "bug"?

--

Bill Blakey

So I set the "User Instances" to disabled as noted in the Readme file
(sp_configure 'user instances enabled', 0, stopped and re-started the
named instance. Ran the SQLEXPR again, same results. Verified that the
run_value matches the config_value for the option (0 - disabled).

What else to check?

--

Bill Blakey

"Bill Blakey" <bill.blakey@sage.com> wrote in message
news:O2Vp7hOBHHA.4024@TK2MSFTNGP04.phx.gbl...
>I downloaded the new SQL Express SP2 CTP, then ran the SQLEXPR.exe. Chose
>my instance and specified "SQL Server Authentication", supplied 'sa' and my
>password. I get the messsage:
>
> "SQL Server Setup cannot upgrade the specified instance by using SQL
> Server credentials. You must use Windows Authentication credentials for
> the upgrade."
>
> Problem is, I've removed Builtin\Administrators group and the instance
> requires SQL Server authentication.
>
> Is this simply a CTP "bug"?
>
> --
>
> Bill Blakey
>
>