Secret ingredients to quality software


Does your user account have SQL Server System Administrator privileges in SQL Server?

Created on 12 Aug 2015 | Last updated by Ben Cull on 12 Aug 2015 04:09 PM (over 5 years ago)

If you're upgrading TFS 2010 to 2012, we recommend that you assign sysadmin privileges to the user account that's doing the upgrade.

Some database upgrade steps involve ALTER DATABASE statements and other commands that can't be done by a normal user. If a step fails, you are likely to end up with a corrupted Configuration database (so you have to restore from backup).

We open source. This page is on GitHub