Hi
We've got two, seperate Soalrwinds NPM deployments at the moment both running on Server 2016 and both have/had the same issue. The additional poller connects to the database during configuration but never again. It gives the event information:
Service was unable to open new database connection when requested.
SqlException: Login failed for user 'sa'.
Connection string - Data Source=<SWL ListenerIP;Initial Catalog=master;User ID=sa;Password=*******;Pooling=False
The thing is, the username and password IS correct and the same error occurs with a windows domain account. The database shows as having connected during the configuration wizard but never does again. One setup did this from the off and the other after working for a few months. The newer one, we resolved by creating a new database but the other is now full of nodes and config etc and it would seem the issue can occur even after it has worked for a while.
We have never had this before and are wondering if it is an issue with Server 2016 perhaps? Does anyone have any idea?
Many thanks
