Best SQL Server Developer Online Training

SQL Server supports two types of installation −

  • Standalone
  • Cluster based

Checks

  • Check RDP access for the server.
  • Check OS bit, IP, domain of server.
  • Check if your account is in admin group to run setup.exe file.
  • 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 2005

  • Setup support files.
  • .net framework 2.0.
  • SQL Server native client.

Pre-requisites for 2008&2008R2

  • Setup support files.
  • .net framework 3.5 SP1.
  • SQL Server native client.
  • Windows installer 4.5/later version.

Pre-requisites for 2012&2014

  • Setup support files.
  • .net framework 4.0.
  • SQL Server native client.
  • Windows installer 4.5/later version.
  • Windows PowerShell 2.0.