question

pits avatar image
pits asked

2008 upgrade fail

ALTER LOGIN statement in SQL Server 2005 allows to disable the sa account and rename it as one of the security measure. But if sa account is renamed the sql 2008 upgrade will fail,can you please advice how to handle this scenario? Rgds,
sql-server-2008upgrade
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
Here is the KB article from Microsoft telling you what to do: [KB: 960781][1] Basically: 1. Start SQL Server with the switch /f /T3608 2. Rename sa back to 'sa' 3. Stop SQL Server 4. Run Setup and choose "Repair" 5. Finish Setup & Start SQL Server 6. Rename sa back to something you choose [1]: http://support.microsoft.com/kb/960781
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.