Announcement

Collapse
No announcement yet.

Installing SQL Server Standard & Express 2012 for use with SellerDeck Enterprise

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Installing SQL Server Standard & Express 2012 for use with SellerDeck Enterprise

    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.
    1. 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



    2. 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.
    3. 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.
    4. The next screen prompts you for your product key. This will determine if you have ‘Standard’, ‘Developer’, ‘Enterprise’, ‘Workgroup’ etc




      Press Next
    5. You now need to agree to the Microsoft Software Licence Terms




      Tick the I accept box and press Next
    6. Now SQL Server needs confirm if you would like to include the SQL Server Product updates.



    7. The tick box should be ticked, so just click Next
    8. The next screen will download and install the product and updates



    9. Now SQL Server needs to setup the Support Files




      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
    10. Now it Checks your Product Key again just make sure it’s the same and click Next



    11. You now need to agree to the Microsoft Software Licence Terms



      Tick the I Accept box and click next
    12. The next section will ask you to select the Role of the SQL Server




      Select the Role you require and click next
    13. 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
    14. Now SQL Server will check to see if the installation process will be blocked by anything.




      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.
    15. 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
    16. The next screen tells you how much disk space is required to install this new Instance of SQL Server




      Press Next
    17. 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
    18. There are a few things to do on the ‘Database Engine Configuration’ screen. The first is to select ‘Mixed Mode’ in the ‘Server Configuration’ 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
    19. The ‘Error Reporting’ screen is next




      Choose if you want to send reports to Microsoft or not, and press Next
    20. Now we come to the ‘Installation Configuration Rules’ screen




      Again, we want to see a list of ticks. Press Next when complete
    21. The ‘Ready to Install’ screen gives you a summary of your chosen options for this new instance of SQL Server




      Press Install
    22. Again, we want to see ticks at the end of the ‘Installation Progress’



      Press Next
    23. 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
    Attached Files
Working...
X