Search the Blog

Sunday, August 18, 2019

Sql Server Intstallation



SQL Server supports two types of installation: 
1 Standalone 
2 Cluster based 

Checks 
1 - Check RDP access for the server. 
2 - Check OS bit, IP, domain of server. 
3 - Check if your account is in admin group to run setup.exe file. 
4 - Software location.

Requirements 
 Which version, edition, SP and hotfix if any. 
 Service accounts for database engine, agent, SSAS, SSIS, SSRS,      if any. 
 Named instance name if any. 
 Location for binaries, system, user databases. 
 Authentication mode. 
 Collation setting. 
 List of features

Pre-requisites for 2014 
 Setup support files. 
 .net framework 4.0. 
 SQL Server native client. 
 Windows installer 4.5/later version. 

No comments:

Post a Comment

Translate