Managed Service Accounts and non default instances

  • New built windows 2016 and SQL 2017 stand alone standard sql server.
    MSA's used for agent and service
    approx 5 instances per server ( political reason, business areas can have SA rights to their instance)

    I've been seeing errors where the MSA is attempting to log into the default service, and not the service it is assigned, this give errors

    Does anyone have any suggestions - on what is happening, or where to look for more detailed errors?
    SQL Server Alert System: 'Error - Severity 14 - Insufficient Permissions' occurred on \\SERVER
    Login failed for user 'DOM\SERVICE_ACC$'.Reason: Could not find a login matching the name provided. [CLIENT: <localmachine>]

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply