SQL Server 2014 installation Tutorial Videos for Beginner - PowerPoint PPT Presentation

About This Presentation
Title:

SQL Server 2014 installation Tutorial Videos for Beginner

Description:

Learn SQL Server 2014 Installation through catch experts tutorials which provides a detail procedure steps included in installing SQL Server 2014 and also teach you the prerequisites that must be installed on your computer before installing SQL 2014 in brief.Catch experts also provides various online, videos, and classroom free resources of SQL Server 2014 for beginners. – PowerPoint PPT presentation

Number of Views:186

less

Transcript and Presenter's Notes

Title: SQL Server 2014 installation Tutorial Videos for Beginner


1
CATCH EXPERTS
https//www.catchexperts.com
http//www.courseing.com
2
SQL Server 2014 Installation Tutorial Videos for
Beginner by
3
Highlights
  • Installation prerequisites
  • Basic installation

4
Installation prerequisites
  • NTFS file format SQL Server 2014 is recommended
    on computers.
  • Installation on read-only, mapped, or compressed
    drives can not be done.
  • SQL Server 2014 can not be installed on 32 bit
    computers.
  • For SQL Server 2014 installation use one of the
    Windows Server 2012, Windows 8 RTM, Windows Vista
    SP2, Windows Server 2008 SP2, Windows 7 SP1,
    Windows Server 2008 R2 SP1 operating systems.
  • Hardware and software prerequisites to install
    SQL Server 2014 are as follows
  • .NET Framework

5
Installation prerequisites
  • Windows PowerShell
  • Network Software
  • Virtualization
  • Hard Disk6 GB free space
  • DVD Drive
  • MonitorSuper-VGA (800x600) or higher resolution
    monitor
  • Internet access
  • WOW64 Support
  • Server Core Support

6
Installation prerequisites
  • WOW64 stands for Windows 32-bit on Windows
    64-bit.
  • Enables 32 bit applications to run natively in 32
    bit mode on 64 bit operating system.
  • SQL Server 2014 supported on a server core
    installation.
  • SQL Server 2014 supported on following server
    core mode editions
  • Windows Server 2012 R2 Datacenter 64-bit and
    Standard 64-bit
  • Windows Server 2008 R2 SP1 Datacenter 64-bit and
    Standard 64-bit
  • Windows Server 2008 R2 SP1 Enterprise 64-bit and
    Web 64-bit

7
Basic installation
  • Microsoft SQL Server 2014 Release to
    Manufacturing(RTM) was released on 7/4/2014.
  • SQL Server 2014 available in various versions,
    they are Web Edition, Express Edition, Standard
    Edition, Developer Edition, Business
    Intelligence, Enterprise and  Enterprise Core
    Edition.
  • Installation of SQL Server 2014 is as follows
  • log on to the server as database administrator
    and right click Setup.EXE file and choose Run as
    administrator option from the drop down list.

8
Basic installation
  1. Once Prerequisites are installed restart the
    server, after the restart again run the Setup.EXE
    file.
  2. SQL Server Installation Center will open up then
    select suitable Processor Type.
  3. Select New SQL Server stand-alone installation or
    add features to an existing installation in  SQL
    Server Installation Centers .
  4. Select free edition or enter the product key.
  5. Accept the license terms.

9
Basic installation
  1. Global Rules screen identify problems, if it
    found any issues you need to fix the problems to
    continue with the installation.
  2. Install the latest SQL product updates if
    available.
  3. Install the latest Setup Files if any updates
    required.
  4. Install Rules page identifies any issues
    available, fix them to continue.
  5. On feature selection page you can select required
    features.
  6. Mention name and the instance ID on Instance
    Configuration page

10
Basic installation
  1. Mention Service Account and the Collation details
    on server configuration page.
  2. Specify authentication mode and administrators
    for the Database Engine, Data Directories and FILE
    STREAM on Database Engine Configuration screen.
  3. Specify the analysis services administrators and d
    ata directories on Analysis Services
    Configuration page.
  4. Select install only on Reporting Services
    Configuration page.
  5. Specify the Controller Name, Working
    Directory and Result Directory Locations on
    Distributed Replay Client Configuration page.
  6. In Feature Configuration Rules screen the setup
    will run rules to determine if the installation
    process will be blocked. Finally click on
    install.

11
Feedback
Like It ? Hate It?
We would love to hear from you whatever you think
about the course.
Click HERE to share what you think!
12
Thank you
Thank You for Watching SQL Server 2014
Installation Tutorial Videos for Beginner by
http//www.courseing.com
Write a Comment
User Comments (0)
About PowerShow.com