As soon as the shiny new SQL Server 2008 R2 BPA has been released, I’ve downloaded it and tried to install it immediatly on my Virtual Machine, which is not joined to any domain.
Unfortunately I had a bad surprise, since the installation failed with a very anonymous error. Some more detailed error appears in a pop-up console, but it closes just too fast to be read. Armed with patience and Camtasia, I recorded the installation and found the error:
I’ve tried to run the command manually (using an Administrative account), but still no luck. After having reported the error, Adam Saxton came to the rescue :
http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx
So, to summarize, if you want to install in a stand-alone machine, do the following:
- Open a PowerShell 2.0 command prompt, using an administrative account
- Enable Powershell Remoting using the command Enable-PSRemoting
- Launch BPA installation using the command msiexec /i "SQL2008R2BPA_Setup64.msi" SKIPCA=1
Done :-)
UPDATE
You can find a detailed post on possibile installation errors (and their resolution) here:
http://blogs.msdn.com/b/psssql/archive/2010/06/21/known-issues-installing-sql-2008-r2-bpa-relating-to-remoting.aspx
PS
You can find Microsoft® SQL Server® 2008 R2 Best Practices Analyzer here
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
and the required Microsoft Baseline Configuration Analyzer 2.0 here
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=1b6e9026-f505-403e-84c3-a5dea704ec67