Probably a silly question, but... does the service account SQL database and integration services run need access SQL?

Posted on 2011-10-05
Last Modified: 2012-05-12
We host a sql 2008R2 server cluster for a customer, and he's removed the service account SQL database and integration services run on from the list of authorised SQL logins.
Should the service account have access to SQL or can it be left like this?
Question by:mr_nadger
    LVL 17

    Accepted Solution

    No, it's not needed for the SQL Service account to be an SQL Administrator :)  I have many SQL Servers running, and the service account is a local administrator only - and is not linked to any of the SQL Logins.
    LVL 7

    Author Comment

    thanks, saves us a big argument (they hadn't told us they'd done this, and we were looking at mirroring a db on there with that account, we'll have to get a different one)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 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

    15 Experts available now in Live!

    Get 1:1 Help Now