Before starting, it is recommended you ensure your computer is fully up to date via Windows update otherwise installation may fail. To do this go to Start | Control panel | Windows update. After installing updates, check again to see if there are anymore and install then, repeat this process until there are no updates left.
For a guide on how to do this, please see this knowledgebase article Licensing a new site with an SQL Database
- The first screen you will see when running the SQL Server installer is the ‘SQL Server Installation Centre’. Here you choose how to plan an install, perform an install, maintain or repair an install etc
- You want to choose the ‘Installation’ option from the list on the left:
and then ‘New SQL Server stand-alone installation or add features to an existing installation’ from the main screen.
- This will open a new window, which begins the setup wizard. The first screen prompts you to install and setup support rules:
Ideally you want to see a list of ticks as in the image above. Press OK when complete.
- The next screen prompts you for your product key. This will determine if you have ‘Standard’, ‘Developer’, ‘Enterprise’, ‘Workgroup’ etc
Press Next
- You now need to agree to the Microsoft Software Licence Terms
Tick the box and press Next
- Now SQL Server needs to setup the Support Files
- Press Install
Again, you want to see a list of ticks. If there are any failures or warnings, you will be able to view the details by clicking the link on the right.
When done, press Next
- The next screen is the ‘Feature Selection’. For SellerDeck, you only need ‘Database Engine Services’ and ‘Management Tools – Complete’.
But you can choose more options if you want. When you have selected the features, press Next
- Now we are at the point of the ‘Instance Configuration’. Each install of SQL Server is called an ‘Instance’. You can have multiple instances of SQL Server installed.
It is suggested that you use a ‘Named Instance’ rather than the default.
Choose a name and then press Next
- The next screen tells you how much disk space is required to install this new Instance of SQL Server
Press Next
- Now we come to the ‘Server Configuration’ screen. Choose an option from the ‘Account Name’ column and make sure the ‘Startup Type’ is ‘Automatic’
Press Next
- There are a few things to do on the ‘Database Engine Configuration’ screen. The first is to select ‘Mixed Mode’ in the ‘Account Provisioning’ tab.
Now choose a password for the built in SQL Server administrator account. The built in username is ‘sa’ (lowercase).
Then click the ‘Add Current User’ button to add yourself as an administrator by default.
Now click the ‘Data Directories’ tab
This is where you can set the default directories used for storing the SQL data files (i.e. the databases themselves and the log files etc) and also where the default backup directories are.
You can leave them as default, which is within the installation directory in Program Files or you can set a different location.
When you are happy, press Next
- The ‘Error and Usage Reporting’ screen is next
Choose if you want to send reports to Microsoft or not, and press Next
- Now we come to the ‘Installation Rules’ screen
Again, we want to see a list of ticks. Press Next when complete
- The ‘Ready to Install’ screen gives you a summary of your chosen options for this new instance of SQL Server
Press Install
- Again, we want to see ticks at the end of the ‘Installation Progress’
Press Next
- Your SQL Server installation is now complete
Press close to complete the wizard. You can now begin to configure SQL Server with SellerDeck
For a guide on how to do this, please see this knowledgebase article Licensing a new site with an SQL Database