Having got past the pre-installation issues in my last post I am now ready to install SQL Server 2008 Express with Advanced Services..
I ran the System Configuration Checker and got a set of green lights, except for PowerShell…
and the install won’t get past that so I am going to have to find that because it’s not part of the install (which it is with Developer, Standard, Enterprise etc.) If you are still with me you can get PowerShell here. A small but good feature is that at least I can rerun the test from here especially as this installation doesn’t require a reboot. So at last we are good to go …
If I go back to the main screen I now have an installation option so I select this and agree the license and now I get to run some (more) setup rules from which I get a warning that the firewall is on :
Now I can select which bits I want in the usual way ..
and then the instance, which is how you can have multiple or similar independent versions, of SQL Server on the same machine…
I am going with the default named instance of SQL Express. Having checked the disk space, I now have to choose the accounts and in this case I am going for NT AUTHORITY\ LOCAL SERVICE..
The next screen is important as you need to get into SQL once it has installed to I am going for mixed mode, the sa password should be as strong as your administrator and don’t forget to add yourself into the SQL Server administrators as I have done here..
I have installed advanced services which comes with reporting services so there is an extra configuration screen for this..
Finally you get the inevitable screen to participate in the program to report errors and usage, followed by the rules being rerun, followed by a confirmation of your settings.
The only good thing about this tortuous process is that it is very thorough and so if you have got this far it should all work and now I can show you what it look like.