[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1534
  • Last Modified:

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\Servers\setup.exe /qb INSTANCENAME=MSS
QLSERVER ADDLOCAL=SQL_Engine SAPWD= abc123 SQLACCOUNT=MICRO\sqlserver SQLPASSWOR
D=abc123 AGTACCOUNT=MICRO\sqlserver AGTPASSWORD=abc123 SQLBROWSERACCOUNT=MICRO\s
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
0
bsharath
Asked:
bsharath
  • 10
  • 6
1 Solution
 
matrix_aashCommented:
Have you tried loging in as Admin of the domain who has sufficient previlages to install software and then use the local  account as the service account.

Aash.
0
 
bsharathAuthor Commented:
I am installing it with Admin credentials only...
This is a unattended installation.How do i specify the local account and service account.
0
 
azza_cCommented:
Sharath

Does your domain account (MICRO\sqlserver) you have specified in the unattended install script have its password set to never expire?
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
bsharathAuthor Commented:
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?
0
 
azza_cCommented:
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.
0
 
bsharathAuthor Commented:
azza_c

Thanks

Is there any way that you can add the above code with the main code...
0
 
azza_cCommented:
So try something like:

C:\>Start /wait \\dev-chen-mrd100\Sql2005\Servers\setup.exe /qb INSTANCENAME=MSS
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.
0
 
bsharathAuthor Commented:
Will this install Server version or client?
0
 
bsharathAuthor Commented:
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
------------------------------
0
 
azza_cCommented:
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\Servers\setup.exe /qb INSTANCENAME=MSS
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
0
 
bsharathAuthor Commented:
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
------------------------------
0
 
azza_cCommented:
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
0
 
bsharathAuthor Commented:
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.
0
 
azza_cCommented:
Not too sure what the question is exactly but if you run the installation with ADDLOCAL=SQL_Engine it will install the SQL Server Database Services only. If you run the installation with ADDLOCAL=All then it will install everything, SQL Server Database Services, reporting services, analysis services, notification services, integration services and client components. What you need to install depends on what you want the end user to have.
0
 
bsharathAuthor Commented:
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
------------------------------
0
 
bsharathAuthor Commented:
Any help...
0
 
bsharathAuthor Commented:
A little more help please....
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 10
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now