- Close Sage ACT!.
- Click on Windows® Start button.
- For Windows XP® select Run.
- For Windows Vista® and Windows® 7, use the Search field.
- Enter the command Actdiag and press the Enter key.
- Within the Actdiag program, select Server on the menu bar.
- From the menu, select option Server Security.
- Click on the Reset SQL Password button. Click OK to continue when prompted (do not attempt to enter a password).
- Message Reset SQL Password will appear, click OK to complete the process.
- Close Actdiag.
- 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.
- In the RUN window, enter the command Net Stop MSSQL$ACT7 and press the Enter key.
- Return to the RUN window, enter the command Net Start MSSQL$ACT7 and press the Enter key.
- Launch Sage ACT! and update the database.
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'
Subscribe to:
Posts (Atom)