Posted by Erland Sommarskog on 02/10/07 16:43

KR (kraman@bastyr.edu) writes:
> We are running a test upgrade form sql 2000 standard edition to sql
> 2005 developer edition. Followed through all the steps and specified
> the account(SA priveleges and currently used by the 2000 version) and
> is the local admin on the box for the services and the setup seemed to
> move fine, except for when it got to the point of installing database
> services - This is the error message that I got:
> MSSQLServer could not be started. Verify you have sufficient
> priveleges to start system services. The was no choice but to hit
> cancel and then the set up progressed with a final message of 'SEtup
> failed'.

I have very little idea what may be the problem; setup problems are
awfully difficult to diagnose on a distance.

But an alternative may be to install new instance side by side, and
then migrate databases with backup/restore or attach/detach. You
would have to migrate logins manually, and use sp_change_users_login
to restore the user-login mapping.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]