Unattended Sql server installation
Hi,
From this website
http://www.databasejournal.com/features/mssql/article.php/3614471
i am using this code
C:\>Start /wait \\dev-chen-mrd100\Sql2005\
QLSERVER ADDLOCAL=SQL_Engine SAPWD= abc123 SQLACCOUNT=MICRO\sqlserver
D=abc123 AGTACCOUNT=MICRO\sqlserver
qlserver SQLBROWSERPASSWORD=abc123 SECURITYMODE=SQL
To install Sql 2005 unattended.
I get this message while installation.
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28075&EvtType=sqlca%5cservicedlg.cpp%40Validate_ServiceAccounts%40ServiceAccountValidate%3a%3aValidateAccount%40x6dab
--------------------------
BUTTONS:
&Retry
Cancel
--------------------------
Can anyone help...
Regards
Sharath
From this website
http://www.databasejournal.com/features/mssql/article.php/3614471
i am using this code
C:\>Start /wait \\dev-chen-mrd100\Sql2005\
QLSERVER ADDLOCAL=SQL_Engine SAPWD= abc123 SQLACCOUNT=MICRO\sqlserver
D=abc123 AGTACCOUNT=MICRO\sqlserver
qlserver SQLBROWSERPASSWORD=abc123 SECURITYMODE=SQL
To install Sql 2005 unattended.
I get this message while installation.
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28075&EvtType=sqlca%5cservicedlg.cpp%40Validate_ServiceAccounts%40ServiceAccountValidate%3a%3aValidateAccount%40x6dab
--------------------------
BUTTONS:
&Retry
Cancel
--------------------------
Can anyone help...
Regards
Sharath
ASKER
I am installing it with Admin credentials only...
This is a unattended installation.How do i specify the local account and service account.
This is a unattended installation.How do i specify the local account and service account.
Sharath
Does your domain account (MICRO\sqlserver) you have specified in the unattended install script have its password set to never expire?
Does your domain account (MICRO\sqlserver) you have specified in the unattended install script have its password set to never expire?
ASKER
Sorry i have no knowledge about Sql..
I just am trying to create an unattended installation.
I have taken the code from the above mentioned website.
MICRO\sqlserver i have no idea.Should i create a user as Sqlserver in my Domain?
I just am trying to create an unattended installation.
I have taken the code from the above mentioned website.
MICRO\sqlserver i have no idea.Should i create a user as Sqlserver in my Domain?
Ahhh...
Right-o - I think the account settings specified in the script are specific to the author of that document's computer environment.
Maybe have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx#sqlaccount1 which is the Microsoft documentation on how to install from the command prompt.
Just as a thought - if you remove the following parameters out of the script SQLACCOUNT SQLPASSWORD AGTACCOUNT AGTPASSWORD SQLBROWSERACCOUNT SQLBROWSERPASSWORD then the setup will default to using specific built in machine accounts of the operating system (NT AUTHORITY or NT AUTHORITY\SYSTEM) and you may then be able to perform the unattended install fine.
Hope that helps.
Right-o - I think the account settings specified in the script are specific to the author of that document's computer environment.
Maybe have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx#sqlaccount1 which is the Microsoft documentation on how to install from the command prompt.
Just as a thought - if you remove the following parameters out of the script SQLACCOUNT SQLPASSWORD AGTACCOUNT AGTPASSWORD SQLBROWSERACCOUNT SQLBROWSERPASSWORD then the setup will default to using specific built in machine accounts of the operating system (NT AUTHORITY or NT AUTHORITY\SYSTEM) and you may then be able to perform the unattended install fine.
Hope that helps.
ASKER
azza_c
Thanks
Is there any way that you can add the above code with the main code...
Thanks
Is there any way that you can add the above code with the main code...
So try something like:
C:\>Start /wait \\dev-chen-mrd100\Sql2005\
QLSERVER ADDLOCAL=SQL_Engine SAPWD= abc123 SECURITYMODE=SQL
Leave out all of the account stuff - that way the setup will by default use the built in machine accounts to perform the installation and hopefully you have an unattended install that works.
C:\>Start /wait \\dev-chen-mrd100\Sql2005\
QLSERVER ADDLOCAL=SQL_Engine SAPWD= abc123 SECURITYMODE=SQL
Leave out all of the account stuff - that way the setup will by default use the built in machine accounts to perform the installation and hopefully you have an unattended install that works.
ASKER
Will this install Server version or client?
ASKER
I get this now...
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT, SQLACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66
--------------------------
BUTTONS:
OK
--------------------------
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT, SQLACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66
--------------------------
BUTTONS:
OK
--------------------------
Sorry, my mistake - you can leave out the account stuff for SQL Server 2005 Express edition only otherwise it is required. How about trying:
C:\>Start /wait \\dev-chen-mrd100\Sql2005\
QLSERVER ADDLOCAL=SQL_Engine SAPWD= abc123 SQLACCOUNT="NT AUTHORITY\SYSTEM" SQLPASSWORD= AGTACCOUNT="NT AUTHORITY\SYSTEM" AGTPASSWORD= SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERPASSWORD= SECURITYMODE=SQL
To answer your previous comment:
The ADDLOCAL specifies which components are installed. In the above case it is the SQL_Engine only. If you want to install everything change this to ADDLOCAL=All - if you want to pick and chose what is installed then see the table and examples here --> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#addlocal
C:\>Start /wait \\dev-chen-mrd100\Sql2005\
QLSERVER ADDLOCAL=SQL_Engine SAPWD= abc123 SQLACCOUNT="NT AUTHORITY\SYSTEM" SQLPASSWORD= AGTACCOUNT="NT AUTHORITY\SYSTEM" AGTPASSWORD= SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERPASSWORD= SECURITYMODE=SQL
To answer your previous comment:
The ADDLOCAL specifies which components are installed. In the above case it is the SQL_Engine only. If you want to install everything change this to ADDLOCAL=All - if you want to pick and chose what is installed then see the table and examples here --> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#addlocal
ASKER
I get this...
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28001&EvtType=sqlca%5csqlcax.cpp%40SAPasswordPolicyCheck%40SAPasswordPolicyCheck%40x6d61
--------------------------
BUTTONS:
&Retry
Cancel
--------------------------
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28001&EvtType=sqlca%5csqlcax.cpp%40SAPasswordPolicyCheck%40SAPasswordPolicyCheck%40x6d61
--------------------------
BUTTONS:
&Retry
Cancel
--------------------------
Right - the SAPWD needs to be a strong password - so if you change SAPWD from abc123 to something like AbcD1234 then it should not give you that error.
Information regarding strong passwords can be found here --> http://msdn2.microsoft.com/en-us/library/ms161962.aspx
Information regarding strong passwords can be found here --> http://msdn2.microsoft.com/en-us/library/ms161962.aspx
ASKER
So now after installation what is the details that i need to give the end user with...
When i run the installation with this.
ADDLOCAL=SQL_Engine what all will install.
and when i install like this
ADDLOCAL=All what all will install.
When i run the installation with this.
ADDLOCAL=SQL_Engine what all will install.
and when i install like this
ADDLOCAL=All what all will install.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for this,
I get this now...
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
SQL Server Setup has determined that the following account properties are not specified: 'ASACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66
--------------------------
BUTTONS:
OK
--------------------------
I get this now...
TITLE: Microsoft SQL Server 2005 Setup
--------------------------
SQL Server Setup has determined that the following account properties are not specified: 'ASACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66
--------------------------
BUTTONS:
OK
--------------------------
ASKER
Any help...
ASKER
A little more help please....
Aash.