SQL 2008 R2 Service Accounts

  • Hi All

    I've tried to find some documentation on this but I can't seem to get anywhere

    We have SQL 2008 installed on our SQL Servers, when we install, we always specify a domain account to run the SQL Services.

    I've installed 2008 R2 on a test machine and I chose again to use a domain account to run the SQL Services, I noticed that the installation has created that domain account as a login in my instance. So the domain account that runs my SQL Services is now also a Windows Authenticated Login on my instance.

    Is this normal for R2?

  • I think I know why it created a login on my instance based on service account

    We don't usually install Reporting Services but for this R3 installation, I installed Reporting Services as well, I see that the login is a user in the ReportServer database

    Reporting Services must be using the service account as a login to the SQL instance

Viewing 2 posts - 1 through 1 (of 1 total)

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