2 Replies Latest reply on Sep 28, 2018 12:04 AM by pratikmehta003

    No database connection - Server 2016 issue?

    mcrummett

      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