There are several important benefits for running SQL Server on Server Core. In this article you’ll see how you can install SQL Server 2016 on Windows Server Core.īenefits of Running SQL Server on Server Core You can’t install SQL Server Management Studio (SSMS) on Server so you have to manage the SQL Server instance remotely oy by using PowerShell which most DBAs are not really all that familiar with. Next, the configuration and management are different. Since Server core doesn’t support a full GUI interface you can’t use the standard SQL Server Installation Center to install SQL Server on Server Core. First, the installation process is different. Even so few businesses have chosen to implement SQL Server on Server Core and there are a few good reasons for this. Windows Server Core provides a more streamlined, efficient and secure platform than the full Windows Server implementation with the GUI. One of Microsoft’s best practices for deploying SQL Server is to install it on Windows Server Core.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |