Set up a local DB Server (MS SQL):


Installation of your DB components should follow this sequence:

Download the server and management studio executables.
Install the server, using default settings throughout .
Make sure to use Domain authentication and enter your domain password.
Reboot.
Install the Server Service Packs.
On ‘SA Password Warning’, Select ‘Ignore the security threat’
Select ‘Upgrade Microsoft Search…’ and click Continue.
Reboot.
Install the management studio.
Reboot.
Test.

The Database component portion of environment setup is complete.