Upgrade Issues When ‘sa’ Renamed

I’ve not done recommended changing the sa account name at a client for quite a while.  Since the account can be disabled there isn’t any good reason to rename it that I’ve been able to come up with.

But if you do and plan to upgrade to SQL Server 2008, beware of the following…

http://blogs.msdn.com/psssql/archive/2008/09/10/upgrade-for-sql-server-2008-can-fail-if-you-have-renamed-the-sa-account.aspx