Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Next »

For those unfamiliar with the installation procedure for Microsoft SQL Server, below is an example of the steps to follow for installing Microsoft SQL Server 2014.  (If you are installing a different version of Microsoft SQL Server, you will need to follow the installation guide included with that version of SQL Server and configure it accordingly.)  Please note that this is only meant to be used as a general point of reference, and not a comprehensive guide to installing Microsoft SQL Server.

  1. Verify that you are logged in as a user with administrative rights, and begin the Microsoft SQL Server setup.  The starting window will display; accept the terms and click Next.



  2. Enable the option to check for updates and then click Next.



  3. Wait for the updates and setup files to be downloaded.



  4. When the Feature Selection screen appears, select the features that you wish to install.  At a minimum, please select the options shown below and click Next:



  5. In the Instance Configuration screen, enter the desired instance name and click Next.  Be sure to write down this instance name for future reference.  In this example, we will use "PRISM" for the instance name.



  6. In the Server Configuration screen, click on the Account Name dropdown for "SQL Server Database Engine" and select "<<Browse...>>".



  7. Enter "system" into the text field, and then click OK.



  8. If the Multiple Names Found screen appears, select the user named "SYSTEM" and click OK, and click OK again.



  9. Click on the Startup Type dropdown for "SQL Server Browser" and select "Automatic".



  10. Verify your screen matches the screenshot below, then click the Collation tab.



  11. Verify that the database engine's collation is set to "SQL_Latin1_General_CP1_CI_AS" and click Next.



  12. In the Database Engine Configuration screen, notice that the currently logged-in user account has already been added to the list of SQL Server administrators.  Click the Add... button.



  13. Enter "system" into the text field, and then click OK.



  14. If the Multiple Names Found screen appears, select the user named "SYSTEM" and click OK.



  15. Verify that "NT AUTHORITY\SYSTEM (SYSTEM)" is now shown in the list of SQL Server administrators, and click Next.



  16. Wait for the installation process to complete.



  • No labels