We are having issues with PassagePoint always losing its connectivity to the database.

This could be caused because the user PassagePoint uses to connect to SQL server either does not have privileges or that the database doesn't exist correctly anymore.

Have your DBA (database administrator) verify the PassagePoint database, as well as the user used to connect to SQL server.

If the DBA doesn't know who the user is, you can get it from going to:
file->configure->enterprise database->click the dropdown, change it to local, then change back to ODBC...you'll see the user. 

Do not save though, just hit cancel after this.