An effective and secure installation of SQL Server is a result of proper planning. In this lesson, we'll discuss the important considerations you should understand first.
- [Instructor] Prior to starting the installation of your SQL server, you should give consideration to the various options that are available. Proper planning is crucial to ensure that you're secure and you have a properly operating instance of SQL server. So in this lesson, we'll introduce you to the main considerations that will help you make your SQL server installation go much more smoothly. SQL Server works with something known as an instance, so each installation of SQL Server is considered an instance. You can install it multiple times on the same computer and SQL Server requires you to separate each one of the installations, either using a name instance or by setting it as a default instance.
Now the important thing to note here is that you can only have one default instance of SQL Server installed, and every other instance that you install after that must be named. However, I recommend that you do not use a default install. You should always use a named instance. And the reason being is because it helps to add to the security of your SQL server. By providing a named instance, any time a client wants to connect to that SQL server, they must know the computer name and the instance name to connect to it.
So in this example, we see that we have one installed instance, called GERRYSP3. This type of an installation was performed using a named instance on the computer, and in this particular case, you don't see the computer name, but you would see it if you were attempting to connect to it with SQL Server Management Studio. During your feature selection, you have the opportunity to choose the instance route directory. And in this case SQL defaults to using the program files Microsoft SQL Server directory for that install. But you have the option to change it.
Another consideration are the different service accounts that SQL server will use. It's recommended that you create a separate account for each one of the SQL Server services to aid in the security of your installation. And you should provide passwords for those accounts so that the services can start automatically if that's the option that you want to choose. SQL Server will default to having some services start automatically, and some start manually. And as you can see from the server configuration screen, a lot of these don't have passwords configured for them, and that again is by default for SQL Server's choices.
You have the option to configure passwords to increase the security for your SQL instances.
This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.
- Installation and configuration considerations
- Data storage strategies
- Configuring database instances
- Performance considerations
- Security considerations
- Managing roles and users
- Managing data
- High-availability options