Error:
Error: “SQL Server Setup has determined that the following account properties are not specified: “AGTACCOUNT”. 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.”
Error Message:
Causes:
- Due to improper SQL uninstallations, your registry is not clean and might be corrupted.
- SQL Server setup is failing to meet password policy.
- This occurs because the browser service is installed on that node. So SQL setup detects the existence of the browser service and does not prompt you for the credentials for all these services, only for SQL Server and SQL Agent leaving out the SQL Browser. You will then see the above error.
Workaround 1:
Disable Password must meet complexity requirements and Configure Minimum password length to Zero
Let the error message be on the screen
Control Panel | Administrative Tools |Local Security Settings | Account Policies | Password Policy
Configure “Minimum password length” to zero and
“Password must meet complexity requirements” to be Disabled.
Go to SQL Installation window and press “Retry”.
After installation successfully done, revert back the changes.
Workaround 2:
Remove SQL Server 2005 completely from Control panel
The second workaround is to remove one node from the virtual server (SQL instance), which removes the SQL Browser Service, and then run the new install.
Control Panel | Add or Remove Programs | Microsoft SQL Server 2005
Select Instance and remove and do the same for below components.
Microsoft SQL Server Native client
Microsoft SQL Server Setup support files
Microsoft SQL Server VSS writer
Workaround 3:
To install SQL Server from the command line you can try to use the command line options.
Workaround 4:
Extract SQLEXPR.EXE file
Open the template.ini file with Notepad.
Look for the following section within this file:
SQLBROWSERACCOUNT=
SQLBROWSERPASSWORD=
SQLACCOUNT=
SQLPASSWORD=
AGTACCOUNT=
AGTPASSWORD=
ASACCOUNT=
ASPASSWORD=
RSACCOUNT=
RSPASSWORD=
Look at section where it has, “AGTACCOUNT”. If this section is blank after the = sign, type in “NT AUTHORITY\NETWORK SERVICE” and save the file.
Attempt to reinstall.
