Tuesday, June 23, 2015

Could not find stored procedure 'dbo.PRC_UTIL_DBFILEINUSE'

http://kb.swiftpage.com/app/answers/detail/a_id/28169/kw/could%20not%20find%20the%20stored%20procedure%20'dbo.prc_util_dbfileinuse'

  1. Close Sage ACT!.
  2. Click on Windows® Start button.
    • For Windows XP® select Run.
    • For Windows Vista® and Windows® 7, use the Search field.
  3. Enter the command Actdiag and press the Enter key.
  4. Within the Actdiag program, select Server on the menu bar.
  5. From the menu, select option Server Security.
  6. Click on the Reset SQL Password button. Click OK to continue when prompted (do not attempt to enter a password).
  7. Message Reset SQL Password will appear, click OK to complete the process.
  8. Close Actdiag.
  9. Click on the Windows Start button and select Run. For Windows Vista and Windows 7, enter the command Run into the Search field and press the Enter key.
  10. In the RUN window, enter the command Net Stop MSSQL$ACT7 and press the Enter key.
  11. Return to the RUN window, enter the command Net Start MSSQL$ACT7 and press the Enter key.
  12. Launch Sage ACT! and update the database.