Installing SQL Server 2008 R2 with a command line through a bootstrapper
Aug3Written by:
8/3/2010 4:25 PM
Installing SQL Server can be a tricky thing. Especially when you're doing it through a command line interface, and using an install bootstrapper to call the SQL bootstrapper.
Are you getting this error upon installation?
Overall summary:
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal): -2068578304
Exit facility code: 1204
Exit error code: 0
Exit message: The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service.
Start time: 2010-08-04 10:03:59
End time: 2010-08-04 10:04:31
Requested action: Install
Check the command line you're sending to the SQL Server installer. You may find that you need to escape the backslash characters in the SQL Server command line in your bootstrapper code for the accounts.
For example, notice the double backslashes?
/SQLSYSADMINACCOUNTS=\"BUILTIN\\Administrators\" /SQLSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\"
Using LUA script.
Hope this helps someone.