Installing SQL Server 2012 Step By Step

Your Price $4.99



Educating Professional Developers

This Book will be E-Delivered

Book Description

This book will quickly show you step by step how to install SQL Server 2012; how to enable protocols so that SQL Server can be access by external applications; how to start, stop, pause, and restart services; how to change the properties of each SQL Server service; how to reconfigure service instance login properties. It can be used as a quick reference or a standard how to document for your development or database team. Most database administrators or developers are overloaded with many tasks and have limited time to search online and more advertisements are found in internet search results that will waste more of the little time that remains. How can one still be effective? Reduce the noise and obtain information free of it. That is our goal. These are the prerequisites for becoming a successful Microsoft Certified Professional.

Look Inside Book

Table of Contents

Installing SQL Server 2012 Step By Step. 1

Introduction. 5

Let's Get Started. 6

Installing SQL Server 2012. 6

SQL Server Installation Center. 7

Planning. 7

Installation. 11

Product Key. 13

Feature Selection. 18

Installation Rules. 20

Instance Configuration. 21

Disk Space Requirements. 22

Server Configuration. 23

Database Engine Configuration. 24

Installation Configuration Rules. 26

Ready to Install 27

Installation Progress. 27

Run SQL Server Management Studio. 28

SQL Server Must be Configured First. 31

SQL Server Configuration Manager. 31

SQL Server Network Configuration. 31

SQL Native Client 11.0 Configuration. 31

SQL Server Services. 33

Properties. 33

Summary. 36

About the Author. 37

Other Books by Author Stephen Thomas. 38

Beginning WPF 4.5 by Full Example. 38

Beginning WPF 4.5 by Full Example Vol 2. 38

Telerik Rad Grid Control for ASP.NET AJAX by Full Example. 38

Installing Visual Studio 2012 on Windows 8 Step By Step. 38

How to Setup Your Verizon FIOS Static IP with Windows Server 2008 Step by Step. 39

 


 

Introduction

This book will quickly show you step by step how to install SQL Server 2014; how to enable protocols so that SQL Server can be access by external applications; how to start, stop, pause, and restart services; how to change the properties of each SQL Server service;  how to reconfigure service instance login properties.  It can be used as a quick reference or a standard how to document for your development or database team.  Most database administrators or developers are overloaded with many tasks and have limited time to search online and more advertisements are found in internet search results that will waste more of the little time that remains.  How can one still be effective?  Reduce the noise and obtain information free of it.   That is our goal.  These are the prerequisites for becoming a successful Microsoft Certified Professional.
Let's Get Started

Grab your DVD or downloaded SQL Server installation files and let’s get started.

Installing SQL Server 2012

Insert CD into DVD drive then click the popup window below:

Figure 1.  Popup when DVD is inserted on Windows 8

The next window should open below:

Figure 2.  Popup when DVD is inserted on Windows 8

 

 Click under Install or run program from your media. Open folder to view files.  The Windows explorer popup will open below:

Figure 3.  DVD Folder with the setup.exe

 

SQL Server Installation Center

Navigate to the folder with the language version you want to install, Then select the version you want to install.  Our selection will be SQL Server 2012 Developer (which is that same and the Enterprise version except the licensing is for corporate use vs development) (English). Run the setup.exe and click Yes from the UAC to begin the installation process. 

 

Planning

The “SQL Server Installation Center” will open.  See below:

Figure 4.  SQL Server Installation Center