1.Installation

 

1         Installation   -          After installation the summary file available in C:\PROGRAM FILES\Microsoft sqlserver \xxx\setup boot strap\log\summary.txt -          Find out How many instances installed? o   From Configuration Manager o   From Registry 1.1         Firewall Warning - While Installation Firewall Warning came – how to solve this? 1.2         Filestream – what is this? -            1.3         Gather Info -          Version -          Edition -          License -          Location of Binary files -          Authentication Mode -          Service account 1.4         License 1.4.1        Per Server License 1.4.2        Per CAL (Client Access License) 1.4.3        Per Client Device Access License 1.4.4        Per Processor License 1.5         Location of Binary files In general drives allocation will be C        -         Operating System D        -         SQL Server E        -         Backups I,J,K   -         mdf data files L         -         LDF files T        -         Temp db   1.6         Authentication Mode 1.6.1        Windows -          Validated in Active Directory 1.6.2        Mixed Mode -          First it validate in Active Directory, if not found checks in syslogins. 1.7         Others -          Affinity Mask and Affinity Input and Output Mask   1.7.1        Connection -          Server Type o   Database Engine / Analysis Engine / Reporting Engine / Integration Services -          Server Name o   Choose the server or provide if it is in network -          Authentication o   Windows Authentication / SQL Server Authentication   1.7.1.1         Options 1.7.1.1.1         Login 1.7.1.1.2         Connection Properties 1.7.1.1.3         Additional Connection Parameters ???   1.7.2        Parallalism??? -          Using this we increase speed of processor -          MaxDOP (Maximum degree of Parallelism) -          Cast Threshold for parallelism