creating a sql installer domain account

Hi folks,

I was looking to create a SQL installer domain account.  This account is dedicated to installing SQL and its other services (SSRS, SSAS, SSIS, DB ENGINE).  I remember reading somewhere that this type of account would need elevated privileges in AD but don't recall what it is.

Does anyone have any insight to this information?

Thanks.

July 22nd, 2015 8:23pm

If its standalone that no AD level permissions are needed. Here are the permission as per books online for service account. https://msdn.microsoft.com/en-us/library/ms143504.aspx#Windows  

In case of cluster, the cluster virtual computer object should have permission on SQL Network Name Virtual computer object.

Installation account should be a Local Admin on the machine where you are installing SQL.

Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2015 8:56pm

I Guess you are after sql service accounts. to install sql server on any machine you need installation permissions on that machine. as part of installation you will be creating some registery enties which require admin privileges. THats way Balamukund recommended local admin privileges.

In some cases even though you install with admin privileges your databases may not accessible. in that case if you run your sql services with AD account prevent such kind of access related issues.

well every scenario is different. 

July 22nd, 2015 10:35pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics