SQL Server 2008 RTM - Unattended installation parameters.

Question

Hello All !

I encounter some little problems with unattended SQL Server 2008 RTM installation. I use a configuration file "settings.ini". All runs ok, except 2 things:

sql server browser: in the BOL, I've found only this parameter "BROWSERSVCSTARTUPTYPE="Manual". I have a SQL Server domain account service for the browser: which syntax do I take ? "BROWSERSVCACCOUNT" and "BROWSERSVCPASSWORD" ?

in the wizard GUI, we are able to add an administrator account. For SQL Server Express, the parameter is : "ADDCURRENTUSERASSQLADMIN="True". But for the other editions (std and ent), which parameter do I include ? 

When I'm trying to connect, with SQL Server Studio connection dialog box, in Windows authentication mode with the installation domain account (admin install)... It doesn't run .... with "sa" account ...no problem.

---

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

Answer 1

 

Hello,

I have never seen a parameter to specify an account for SQL Server Browser, but that service is supposed to run with the default service account. I don’t see a reason to change the default service account.

I have installed SQL Server 2008 Standard Edition with ADDCURRENTUSERASSQLADMIN="True" and it works. You can also specify the parameter SQLSYSADMINACCOUNTS= "DOMAIN\SQLAccount" to add more accounts.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hello Alberto !

Thanks for your responses, but:

When I put this parameter ADDCURRENTUSERASSQLADMIN="True"  in my configuration file, the installation stops and in the bootstrap log I have a clear message : ADDCURRENTUSERASSQLADMIN="True" is only use for SQL Server Express and it marks like "failed" (I precise I want to install SQL Server Enterprise Edition 2008 RTM). I have made many installation attempts and it's the same thing.

If I put ADDCURRENTUSERASSQLADMIN="False", it seems to be ok.

All our SQL Server account services are located and stored in the AD, with very high SQL Server hardening, the "network services" are not authorized by the security team. So, the SQL Server Browser runs under a domain account and it runs perfectly with the agreement of MS Support.

---

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

Answer 3

 

Hello,

If you cannot used ADDCURRENTUSERASSQLADMIN, you still can use SQLSYSADMINACCOUNTS= "DOMAIN\SQLAccount" to add any account as sysadmin, specifying ADDCURRENTUSERASSQLADMIN="False", as shown on the following thread,

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/0b11835b-c0c2-44d1-a85a-dfd3e9391468/#24172ec8-6918-402b-bea7-43ded8bf142d

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

Hello Alberto !

Thanks for all these informations. My installations now works with the good settings.

---

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2