07-16-2013 03:12 PM
Title says it all. After updating Act! 2013 it prompts to upgrade my database after re-launching Act is asks to backup the database which completes successfully but also has the error
Could not find stored procedure 'master.dbo.PRC_MAINT_CONNECTEDHOSTS'
Then is prompts to upgrade the databse and kick the same error.
Any ideas?
Much appreciated.
07-26-2013 01:09 PM
Usually I find that this happens when there is an issue with one of the SQL passwords. Try following this article:
After running through this, test the database.
If that does not work, download the RESETSQL.BAT attachment on this article:
http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28879/kw/resetsql.bat
Run that file, and it will ask you two questions. Type Y for both of them. The box should disappear eventually.
Try the database again. Let us know if you have any problems.