Pre – Planning for a SQL 2012 Upgrade

Items to Consider before SQL 2012 Installation

Before installing a server the company needs to consider the security issue of their system. Security is essential for any business and any product. By carrying out simple best security practices, an organization can avoid various security vulnerabilities. In this regard among the number of things the organization should consider prior to the installation include: improving physical security, using firewalls, isolating services, configuring a secure file system, disabling NetBIOS and blocking server message and finally, installing SQL on a domain controller.

Logical and physical isolation build the SQL server security foundation. To improve the SQL Server physical security, the organization should consider putting the server in a room which is only accessible to authorized individuals. The database hosting computer should also be place in a secured physical location, preferably a locked room containing supervised fire detection and flood detection or suppression systems. Databases should then be installed in a secure corporate intranet zone and not directly to the internet. The organization should also organize for an off-site location backup system.

Firewalls are essential to assist in securing the SQL Server installation. To enhance the effectiveness of the firewall, the organization should place a firewall between the internet and server and enable it. The network should then be divided into different security zone by the use of firewall. In this case all traffic should be blocked and admit selectively only what is needed. Multiple firewalls should be generated to develop subnets in a multi-tier setting. Interior firewalls should then be configured to allow authentication.

Services isolation lowers the risk that a compromised service would be utilized to compromise others. To isolate services the organization should consider running distinct SQL Server services under distinct Windows account.  Utilizing the accurate file system augments security. In this case the NTFS file system will need to be configured. This file system is preferred since it is more recoverable and stable as compared to FAT file system. It also allows security choices that include file system encryption, and directory and file access control list. In the perimeter network, servers need to have all usual protocols disabled. This includes server message block and NetBIOS. However, DNS and web servers do not need SMB or NetBIOS. On the two servers both protocols need to be disabled to lower the user enumeration threat. This should then be followed by installation of the SQL Server (Valonfeka, 2015).

SQL 2012 Editions Review

The SQL Server 2012 version comes with different versions. They include web and developer edition, express edition, enterprise edition, business edition and standard edition among others: Standard Edition is restricted to 16 scores and a RAM of 64GB. It gives the central relational engine of database and primary capabilities of business intelligence. The edition does not incorporate support for the extensive availability features or the extra powerful features of Business Intelligence. This edition does incorporate support for Always-On Failover two-node clusters. It is licensed for per server of per core.

Download full Pre – Planning for a SQL 2012 Upgrade paper or Order original paper at an affordable price.

Share with your friends
Order Unique Answer Now

Add a Comment