However, many mistakes made in installation can be resolved afterwards, likely with some tedium and outages. (More about the server level collation option later in this chapter, under the “Instance Collation” section.) For example, choosing between the default instance and a named instance, or choosing an instance collation, is not a choice you can easily reverse after installation.
#Install sql server 2014 on a domain controller windows
What to do before installing SQL Serverīefore running the SQL Server installer on your Windows Server, there are a number of factors and settings to consider, some of which you cannot easily change after installation. This chapter, however, focuses on server-level setup and settings. In Chapter 6, “Provisioning and configuring SQL Server databases,” we’ll cover the initial creation and configuration of databases inside the SQL Server instance. They are, after all, still very much the same SQL Server product that has always existed on Windows. Many recommended settings in this chapter still apply for server-based platforms of SQL Server, such as in Docker containers or SQL Server on Linux.
![install sql server 2014 on a domain controller install sql server 2014 on a domain controller](https://activedirectoryfaq.com/wp-content/uploads/2016/09/AD-Schema-Include-Server-2012-R2-DC-in-domain.png)
The installation or creation is vastly simplified for an Azure SQL Database, Azure SQL Database managed instance, SQL Server on Linux, SQL Server in Docker containers, or Azure VMs running SQL Server.
![install sql server 2014 on a domain controller install sql server 2014 on a domain controller](https://3.bp.blogspot.com/-A6BuKCXqW8k/WBvxklCUYbI/AAAAAAAAAMg/nzArFX8ywEwufCcKoRDnzvGZOuJUDU2cACLcB/s320/Mac_Repair_iMac_Macbook_aApple_Recovery-MAC-OS-X-Windows10-CS6-CS5.5-Photoshop_cc-Key-.jpg)
The SQL Server Setup tool content of this chapter mainly applies to SQL Server installations on Windows operating systems. We review a post-installation checklist for you to verify every time and, when necessary, direct you to where you can find other sources of information and details for critical steps elsewhere in this book. We pay special attention to new features introduced in SQL Server 2019, and other recent features you may not have noticed in SQL Server 2017. In this chapter, we review the process of installing and configuring a Microsoft SQL Server instance as well as the creation or migration of databases. Post-installation configuration of other features