• State Not Answered
  • Replies 2 replies
  • Subscribers 17 subscribers
  • Views 564 views
  • Users 0 members are here
Options
Related

SolarWinds servers and SQL 2022 - server account login

sredmond

We have 2 SolarWinds servers and a newly upgraded SQL 2022 server. In SQL Logs, we are seeing logon errors: 

Logon,Unknown,Login failed for user 'DOMAIN\SolarWindsServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: SolarWinds IP]
Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.

My question: Does SQL need a logon for the SolarWinds server in addition to the login for the service account? SQL has a login for the service account but it doesn't have one for the server. 

I don't see the computer login in our SolarWinds lab. Why is SQL 2022 posting errors about not having this login? SolarWinds has been running without major issue but we did have a disconnect to it the other day and we are seeing these logon errors. 

Any comments would be appreciated. 

Thank you

Parents
  • 0

    We have this issue on 2023.3 too, and I *think* it's because SW will attempt a logon with the machine account before trying the account it was configured for when you ran the Config Wizard. Like most folk (I think) we use a single windows account for SQL access from all pollers and web servers, but we still get 18456 errors for all servers in the SQL log. As everything is working as expected I've not been looking into it too much. Even a brand new install of 2024.4 does it.

    Checking the security event log does show matching logon attempts with the failure, but not the reason why. I'll have a trawl of the logs when I get a few minutes.

Reply
  • 0

    We have this issue on 2023.3 too, and I *think* it's because SW will attempt a logon with the machine account before trying the account it was configured for when you ran the Config Wizard. Like most folk (I think) we use a single windows account for SQL access from all pollers and web servers, but we still get 18456 errors for all servers in the SQL log. As everything is working as expected I've not been looking into it too much. Even a brand new install of 2024.4 does it.

    Checking the security event log does show matching logon attempts with the failure, but not the reason why. I'll have a trawl of the logs when I get a few minutes.

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.