We have just upgraded from 18.104.22.1688 to 22.214.171.1240 and out SQL sensors have stopped working - actually all except one.
We have sensors added for our two SQL servers (2008 R2) that run a small SQL script, and they were all working perfectly until we upgraded. On one server we simply get "Timeout PE018" (single instance, multiple databases), but on the other server (multiple instances, multiple databases), one instance is working, the others all fail with messages similar to "Cannot open database "Holdiary" requested by the login. The login failed. Login failed for user 'redacted'.(Connectionstring: Data Source=redacted,1433;Initial Catalog=Holdiary;Integrated Security=True;Password=)".
With a colleague we have discovered the reason, only one instance is on port 1433, the others are dynamic - the sensor is now only using the fixed port for all the instances, so in the last example above it always connects to the same instance regardless of what we define in the sensor and therefore fails. Before the upgrade the sensor was connecting correctly, now it doesn't.
How can we fix this?