Today I had the task of installing SQL Server 2008 on some new Windows Server 2008 Boxes. At first things seemed to go fine, installing updates here and there, but when it came to installing SQL Server there seemed to be a problem:
System Configuration Checker had this error:
Windows PowerShell is not installed. To continue,
please install Windows PowerShell
Windows Server 2008 is supposed to come with PowerShell, why would this server not have it? It turns out that Windows Server 2008 has PowerShell built-in, but it's not installed yet (at least not for me).
This is what i had to do to get it working:
%windir%\system32\servermanagercmd.exe -install powershell
The next snag was caused by us not having a good enough password set, fixed by using a better password.
Here is the next error:
The specified sa password does not meet strong password requirements. For more information about strong password requirements, see "Database Engine Configuration - Account Provisioning" in Setup Help or in SQL Server 2008 Books Online.
After these small issues installation went fine and everything is now working.