Customized Administrative user for SQL Server 2016 instead of sa

Question

Hi All,

I am trying to install SQL Server 2016 using a configuration ini file for silent installation. For testing, during manual installation, I am trying to create a custom Administrative user (Eg: MyAdmin_2016) instead of default "sa". But the wizard is showing to enter only the password for the SQL Server system administrator (sa) account like in the below mentioned image.

The password for the administrative account can be specified in the configuration ini file with parameter /SAPWD. Is there a parameter available to specify the custom SA Username in the configuration ini file, so that once the SQL Server installation is completed, I can login with the custom Administrative user?

Thanks in advance.

 

Answer 1

Is there a parameter available to specify the custom SA Username in the configuration ini file,

No, during installation you can not add SQL login with specific permissions, you can only add Windows accounts to the SysAdmin role.

After installation you can add SQL logins.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Hi DeeJay007,

Install SQL Server using a configuration file or directly from the Installation Wizard (Setup), except for selecting the Mixed Authentication Mode to enable the SA account, you cannot create any other SQL login during the installation phase.

Best regards,
Cris

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.