After assisting a client with a server migration, an issue was reported with a fixed asset integration:
The first thing we checked was to see if the stored procedure did exist, which it did. The next option was a suspicion of permissions. After checking in SQL I found that the service account did not have access to all of the company databases; we added the DYNGRP
database role to the service account and tried the integration again and found that it now ran successfully.