Skip to main content
America's Real Estate Academy, Inc.
sales, appraisal, home inspection, and computer training - Atlanta and Woodstock GA
Real Estate Sales and Broker Courses - In Class and Online
Appraisal Courses - Registered Licensed Certified Appraiser and Continuing Education classes
Travel Agent Courses - how to become a travel agent
Home Inspection Courses, Exam Prep and Certification Classes
Real Estate Sales, Appraisal, and Home Inspection FAQs
Student News
AREA e-Learning - Real Estate Online Academy

Technical Issues

AREA will use this page to discuss solutions to technical issues that we (or our students) encounter - when we find a solution. If you have a technical issue and think we can assist, send an email to and we will let you know if we post a solution.

Wednesday, November 05 2008

On a Windows XP Professional with ACT by Sage 2009. Windows Automatic Update was not able to install the Security Update for SQL Server 2005 Service Pack 2 (KB948109). It would fail each time. Manual update also failed.

Details of the problem and a solution are offered at this SQL Server FAQ page. I found that information helpful, but it was not a complete solution for my situation. These are the steps that I used to solve my problem:

  1. Stop the SQL Server (ACT7) Service by going to Administrative Tools > Services, click on "SQL Server (ACT7)" and then click "stop".
  2. Open a "command prompt" by clicking Start > Run and typing "cmd" in the "open" box and press ENTER.
  3. Check to make sure the prompt is using the letter of the drive or partition which contains the program files - usually "C:" - if not, you can change to the correct drive by typing cd c: and press ENTER.
  4. At the prompt, type cd c:\program files\microsoft sql server\MSSQL.1\Binn press ENTER.
  5. Type Sqlservr.exe -s ACT7 -m -c to start SQL - press ENTER.
  6. Open a second command prompt - see step 2 above.
  7. In the new command prompt, type sqlcmd -S mypc\ACT7 -E where "mypc" is the name of the computer (found by "right" clicking on My Computer and going to Properties) - press ENTER.
  8. Type create login [mypc\richie] from Windows where mypc\richie is the name of the computer followed by your user login name - press ENTER.
  9. Type go and press ENTER.
  10. Type Sp_addsrvrolemember 'mypc\richie','sysadmin' substituting mypc\richie as in step 8 and press ENTER.
  11. Type go and press ENTER.
  12. Type exit and press ENTER.
  13. Return to the first command prompt - press and hold the Control key and press the "c" key.
  14. Then surf to the Windows Hot Fix at and select and RUN the download for your computer. Generally, for Windows XP/Vista 32bit system, you need to choose SQLServer2005-KB948109-x86-ENU.exe to install.
  15. Now you should be able to clear the Windows "update" icon on the task bar and complete the update.
  16. Last thing you need to do is START the service that you stopped in Step 1.
Posted by: Dick Viti AT 08:46 pm   |  Permalink   |  0 Comments  |  Email


Get Professional - Get your own URL - FREE email, FREE website and FREE blog - from just $9.99 per YEAR!

Appraisers and Home Inspectors - Accept credit cards - Online with or without a website. This company specializes in providing merchant services to small business.

Best Rates + No Cancellation Fees at

America's Real Estate Academy, Inc.
Phone: 770-591-5552 * Email:
©2002-2024 America's Real Estate Academy, Inc.