Previous Code Entry
Left Arrow
How to use SQL Server Database Connection string
Current Code Entry
Next Code Entry
Difference between UNION ALL and UNION
Right Arrow
SQL Server Core Installation Script
Article Entry Date: September 12,2022 @ 02:32:19 / Last Updated On: September 12,2022 @ 02:59:27
Using the installation script to Install SQL Server Core 2019 and other versions of SQL Server is easy when using a premade script.
Using this script to install SQL Server will name it easier and quicker than installing SQL Server Manually through its default installer program.


Using this script is demonstrated in our Windows 2016 Server Core installation instructional video.
You can easily edit the code below, then copy it into Notepad and save it as [CoreSQLInstall.ini]
Edit the following lines.
  1. Domain name change - Lines 65, 78, 92
  2. Password change - Lines 66, 79


Create the following users in your Server Domains
[Active Directory Users and Computers]
Lines
  1. 65 - sqlagent
  2. 78 - sqlengine
  3. 92 - sqlcore01

Give the users the following permission roles.
  1. Administrators
  2. Domain Admins
  3. Domain Computers
  4. Domain Controllers
  5. Domain Users
  6. IIS_IUSRS

In the Properties of the user.
Choose the [Member of] tab
Then click [Add...]
(==========[Copy and paste method]==========)
Copy the following roles, and paste them into the [Enter the object names to select]
Once pasted in, click [Check Names]
Then click [OK]
You will receive a warning if any Role already exists, like [Administrators].


Several places will need to be changed if you choose to change the [SQL Instance Name].
Lines 16, 144
(Line 144, only change the Instance name, do not remove any other character.)

Server Operators

Firewall Rules for Remote access to your SQL Server.
This will need to be applied to all Server Cores with SQL Server installed.