Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

New Member
Posts: 1
Country: Canada

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

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.

Moderator
Posts: 704
Country: USA

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

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.

Billy Clark
Swiftpage
Act! Knowledgebase: http://kb.act.com