Updated Act! 2013 and cannot upgrade database with error "Could not find stored procedure 'master.dbo.PRC_MAINT_CONNECTEDHOSTS'

[ChambersIT]

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.

[bclark]

Usually I find that this happens when there is an issue with one of the SQL passwords.  Try following this article:

http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28169/kw/Could%20not%20find%20stored%20proc...

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.