25112
asked on
service account needs a login?
should the sql server service account be given a login in syslogins?
ASKER
no, I am asking if there is a need for service account be to be in syslogins (regardless of sa privilege or not). is there any pros/cons to it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Login failed for <domain user (service account)>. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
why may service account trying to login?