Invoking Connection Test: OK failed A database exception occurred.

Question

New install; have tried both a dedicated MSSQL server and embedded Express with no difference. I can use Management Studio and access the DB just fine using both trusted credentials and sa u/p, from both localhost and remotely so connectivity not an issue. Database connection also tests fine within Management Center's options. I have already made the server an SGN server and have installed the server .msi package that includes the correct machine certificate.

This thread was automatically locked due to age.

FormerMember · Answer

Hi Erik, 
 Set the SGNSRV-Pool Identity to a dedicated Domain Admin (something like SGNSQL) and ensure they're part of the: 
 
 IIS_IUSR group 
 IIS_WPG group 
 
 Create this login in the SafeGuard database and grant db_datareader and db_datawriter permissions to the SafeGuard Database. Restart IIS once you're done then run an invoke test.

MichaelMcLannahan · Answer

Hi Pat - Yes it's in the best practices guide. 
 This can be found here for your version 
 https://www.sophos.com/en-us/medialibrary/PDFs/documentation/sgn_7_bpg_eng_installation_best_practice.pdf

Invoking Connection Test: <Dataroot><WebService>OK</WebService> <DBAuth>failed</DBAuth> <Error>A database exception occurred.</Error></string>