Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 7 subscribers
  • Views 14138 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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

Erik Fritsch

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.
Parents
  • 0

    I changed the identity of the Application Pool that SGNSRV-Pool was running at from the default ApplicationPoolIdentity to LocalSystem (same as DB is running as by default) and I am passing the connection test now. Is this the supported method?

  • FormerMember
    0 FormerMember in reply to Erik Fritsch

    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.

  • 0 in reply to FormerMember

    Hi,

    I have a question about this.  Is using a domain account for the Application Pool what is recommended by Sophos?  Is this documented somewhere? 

    Thanks,

Reply Children
Unfiltered HTML