1. HOW TO INSTALL SQL SERVER? OPTIONAL FOR OUR COURSE. WE HAVE 24 X 7 LIVE ONLINE SERVER.
VERSION SUPPORTED OPERATING SYSTEM PROCESSOR TYPE
————————————————————————————————————–
SQL SERVER 2017 WINDOWS 8 / 8.1 / 10 or LINUX 64bit
SQL SERVER 2016 WINDOWS 8 / 8.1 / 10 64bit
SQL SERVER 2014 WINDOWS 7 / 8 / 8.1 / 10 32bit / 64bit
SQL SERVER 2012 WINDOWS 7 / 8 / 8.1 / 10 32bit / 64bit
INSTALLATION PRE-REQUISITES (S/W REQUIREMENTS):
1. WMI : AUTO INSTALLED WITH WINDOWS OS.
WINDOWS MANAGEMENT INSTRUMENTATION. A WINDOWS COMPONENT FOR MANAGING SQL SERVER
2. XML PARSER : MSXML PARSER. AUTO INSTALLED WITH SQL SERVER. USED FOR SERVER COMMUNICATION.
3. MDAC : MICROSOFT DATA ACCESS COMPONENT.
AUTO INSTALLED WITH SQL SERVER. USED FOR REMOTE CONNECTIONS TO YOUR SQL SERVER.
4. .NET FRAMEWORK: AUTO INSTALLED WITH WINDOWS OS. USED FOR GUI COMPONENTS OF SQL SERVER.
FIREWALL : A WINDOWS PROGRAM USED TO SECURELY IDENTIFY AND PROVIDE ACCES CONTROL TO SQL SERVER CONNECTIONS. DURING SQL SERVER INSTALLATION, WE WOULD SEE FIREWALL WARNINGS. NEED TO RESOLVE THEM AFTER INSTALLATION.
INSTALLATION PROCESS (MANUAL PROCESS):
STEP 1: DOWNLOAD SQL SERVER SOFTWARE FROM : http://sqlschool.com/downloads/SQL-Server-Installation.html . EXTRACT.
STEP 2: DOUBLE CLICK @ SETUP APPLICATION FILE > THIS GIVES ONE WINDOW : “SQL SERVER INSTALLATION CENTER”
INSTALLATION PAGE (LEFT SIDE) >> NEW INSTALLATION (RIGHT SIDE) [2 : 1] > THIS GIVES SECOND WINDOW “SETUP SCREEN”
STEP 3: SELECT “EVALUATION” EDITION > ACCEPT LICENSING TERMS > SELECT “DATABASE ENGINE” : REPLICATION, FULL TEXT SEARCH
SCROLL DOWN THE FEATURES SELECTION PAGE : SELECT “INTEGRATION SERVICES”.
ATTENDEES FOR SQL DBA TRAINING : PLAN B = SELECY “POLYBASE”.
SPECIFY “INSTANCE” NAME OR SELECT DEFAULT INSTANCE > ADD CURRENT USER + SELECT MIXED MODE AUTHENTICATION
STEP 4: INSTALL
2. HOW TO INSTALL SSMS (SQL SERVER MANAGEMENT STUDIO) TOOL ?
APPLICABLE FOR WINDOWS OS ONLY.
APPLICABLE FOR SQL SERVER 2016 & 2017 VERSIONS ONLY. FOR OLDER VERSIONS: THIS SSMS TOOL IS AUTO INSTALLED.
***** TOOLS ARE GUI [GRAPHICAL USER INTERFACE] : USED TO CONNECT, OPERATE WITH SQL SERVER.
EXAMPLE : CREATE DATABASE, STORE DATA, PROVIDE USER DATA ACCESS TO END USERS.
STEP 1: DOWNLOAD SQL SERVER SOFTWARE FROM : http://sqlschool.com/downloads/SQL-Server-Tools.html
STEP 2: DOUBLE CLICK @ “SSMS-SETUP-ENU” FILE > CLICK @ “INSTALL”
STEP 3: RESTART YOUR COMPUTER.
3. HOW TO VERIFY THE PORT NUMBER?
PORTS ARE UNIQUE COMMUNICATION CHANNELS : TO ESTABLISH COMMUNICATION TO SQL SERVER (INSTANCE).
THESE PORTS ARE AUTO ASSIGNED DURING SQL SERVER INSTALLATION, CAN BE MODIFIED LATER.
DEFAULT PORT FOR DEFAULT INSTANCE IS 1433
FOR NAMED INSTANCES, THE PORT IS AUTO CONFIGURED TO A DYNAMIC VALUE.
WITH SQL SERVER INSTALLATION, A TOOL CALLED “SQL SERVER CONFIGURATION MANAGER” IS AUTO INSTALLED.
WINDOWS APPS > “CONFIGURATION MANAGER” > CLICK @ SQL SERVER CONFIGURATION MANAGER > SQL SERVER NETWORK CONFIGURATION >
PROTOCOLS FOR REQUIRED INSTANCE > SELECT > RIGHT CLICK > PROPERTIES > TCP / IP > IP ADDRESSES TAB > SCROLL TO LAST.
TYPES OF PROTOCOLS:
1. SHARED MEMORY – USED FOR CLIENT – SERVER COMMUNICATION WITHIN SAME COMPUTER
EX: SSMS TOOL & SQL SERVER INSTANCE INSTALLED IN YOUR LAPTOP
2. NAMED PIPES – USED FOR CLIENT – SERVER COMMUNCIATION WITHIN A NETWORK.
3. TCP / IP – USED FOR CLIENT – SERVER COMMUNCIATION OVER INTERNET.
EX: CONNECTION TO OUR ONLINE LAB
4. WHAT IS FIREWALL? WHAT IS THE IMPORTANCE ? HOW TO ADDRESS THE FIREWALL WARNINGS WE RECEIVED DURING INSTALLATION ?
On the Start menu, click Run, type ” WF.msc ” , and then click OK.
In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, click New Rule
Select PORT > Specify the port from above > Select the type of Access to your SQL Server:
1. Domain
2. Private
3. Public
Specify a Name > Finish.
firewall is a windows program used to secure and enable the remote connections to SQL Server
Repeat the above proces of Firewall Configuration for Outboud Rules also.
EX 1: 1433 EX2: 1433,1434 EX3: 1433-1434
5. HOW TO USE THE SSMS TOOL ? SQL SERVER MANAGEMENT STUDIO TOOL? HOW TO TEST SERVER CONNECTIVITY?
WINDOWS APPS > SEARCH > “SSMS” > WE SEE SQL SERVER MANAGEMENT STUDIO.
CLICK.
THIS PROMPTS FOR A SERVER NAME.
SPECIFY THE SERVER NAME > CONNECT.
TO GET THE SERVER NAME:
CLICK @ SERVER NAME > DROP DOWN > BROWSE FOR MORE > EXPAND DTABASE ENGINE > SELECT REQUIRIED SERVER > OK