0

I'm installing SQL on (by example FARM_DB1) server. I created SP_Farm in AD and added it as admin on machines, and I'll use it on WFE's. But what is best-practice for SQL machine? Which account to use better:

  • use SP_farm
  • create SQL_Service, add it in local admins and install from him
  • leave defaults ?

enter image description here

3

if you ask for the best practice then:

Create the SQL_Admin: The SQL Server service account is used to run SQL Server. It is the service account for the following SQL Server services: MSSQLSERVER SQLSERVERAGENT. SQL Admin on the SQL Server. it should be domain user with Local Administrator on the SQL Server.

read more about the best practice: SharePoint 2013 Service Accounts Best Practices Explained

  • Thank You! Hm, but I log in with SP_Farm in this scenario? Or log in with SQL_Admin, install SQL and then grant access to database to SP_Farm?.. – Gennady G Dec 2 '15 at 21:39
  • 1
    sql-admin should your account for sql server's box. you should install under this account, then grant permission. – Waqas Sarwar MVP Dec 2 '15 at 21:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.