service account needs a login?

Posted on 2014-08-15
Last Modified: 2014-08-20
should the sql server service account be given a login in syslogins?
Question by:25112
    LVL 5

    Author Comment

    in the errlog, I see this error:

    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?
    LVL 7

    Expert Comment

    by:Pushpakumara Mahagamage
    LVL 5

    Author Comment

    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?
    LVL 7

    Accepted Solution

    I haven't seen any need. i'm using separate AD accounts for SQL Server instance and that service account does not exist in syslogins.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now