1. Open up Setup.exe for SQL Server 2019.
  2. In the popup, go to “Installation” and select “New SQL Server stand-alone installation or add features to an existing installation.

Tips

  • Use system default to install. Once SQL Server is installed, then go back to change the service accounts. If the setup service accounts don’t have proper permissions, they will cause problems with the install.
  • Don’t install “Machine Learning” or “PolyBase” features. They require extra files during install.
  • Install all system files on D: drive. Don’t install on C: drive where the OS files are.
  • Select “Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service” option. By default, it is not selected.
  • Leave system directories as is. Use D: drive instead of C: drive.
  • Select a TempDB directory. We can always move it later to another drive.
  • After successfully SQL Server install, go to “SQL Server Confirmation Manager” to configure the database server.
  • Make sure “TCP/IP” and “Named Pipe” are enabled if you want to connect to the database remotely.
  • The account login used to install the SQL Server needs to have admin rights on the server.
Last modified: March 10, 2021

Author

Comments

Write a Reply or Comment