Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

car insurance » Upgrade for SQL Server 2008 can fail if you have renamed the ’sa’ account

Wed, 10 Sep 2008 05:44:35 GMT

PingBack from http://hoursfunnywallpaper.cn/?p=5415

Upgrade Issues When 'sa' Renamed

Strate SQL — Mon, 13 Oct 2008 19:33:25 GMT

I've not done recommended changing the sa account name at a client for quite a while. Since the account

Upgrade Issues When 'sa' Renamed

Strate SQL — Mon, 13 Oct 2008 19:33:25 GMT

I've not done recommended changing the sa account name at a client for quite a while. Since the account

Internet Beratung

Internet Beratung — Tue, 09 Dec 2008 12:18:35 GMT

Archiv aus Deutschland und aller Welt mit Informationen und Links zum Empfang von Webradio, Web-TV

re: Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

matt@strattonfinance.com.au — Wed, 18 Feb 2009 01:12:54 GMT

Hi Bob,

Quick thanks for the detailed explanation and "proper" work-around to repair a busted upgrade installation - I was the user who made the original post on SQL Server Central about this issue, and while my work-around worked for us it definitely wasn't ideal!

Cheers,

Matt

How to fix your SQL Server 2008 Setup before you run setup (Part II)....

CSS SQL Server Engineers — Tue, 17 Mar 2009 16:49:10 GMT

Last year you might have read my post where I showed you how to patch setup for RTM for SQL Server 2008

re: Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

ofrasson — Thu, 13 Aug 2009 15:18:09 GMT

Hi Bob,

Whe my install was in progress, I stopped the service of SQL 2000, because the upgrade was slowly. After any sequences the second image of this text appeared. Showing the failed error in Database Engine Service, Sql Service replication and Full Text Search. So, the upgrade not complete! I don´t know if my action caused this problem.

Do I re-run the upgrade action or repair?

Regards

Oscar

re: Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

Marcelo - Arkivus — Tue, 15 Dec 2009 18:54:20 GMT

Hello,

We had the same issue here, and we figured out taht the problem was the Services Account setting on the Server Configuration step of instalation. We solved the problem setting the accounts as SYSTEM or NETWORK SERVICES.

Hope this help.