'SQL Server Setup failed to execute a command for server configuration. When you hit this error you'll get the error message
Unfortunately, the default installation path used by Steam goes over this limit. Microsoft's Knowledge Base has details here:
MSSQL Express 2005's installer has a limitation that prevents it from installing to a directory path that's longer than 58 characters.