Now lets look at installing SQL Server 2012.
Here, I've opened up the folder where the file was downloaded.
Double-clicking on it takes me to a
directory that has, amongst other options, setup.
I am interested in the setup option.
I'll double-click on that.
In the options to the left, I see one for installation.
I'll click on that.
And now, here, on the right, I'm presented with four options.
I'm interested in the one at the top, a new SQL Server stand-alone installation.
The installation wizard ran a check for support rules.
It ran nine tests.
I passed all of them.
So, I'll click OK.
It looks like the installation wizard has found
an update it would like me to install.
I'll go ahead and do that now, by clicking Next.
So, the wizard has, again, run some tests to make
sure my machine is capable of handling SQL Server 2012.
It ran seven tests, I passed all of them.
I'll click Next.
Here, I have the option to enter a product key or just
specify the evaluation edition, which will give me a 180-day evaluation edition.
Click Next.
I'll need to accept the license terms.
Here, I have three choices.
The top one allows me to install SQL
Server and choose what features I would like,
the second one installs tools specifically for SharePoint,
and the third one installs all features with defaults.
You could go through and do all features with defaults.
I'd like to customize a few things, so I'm going to select the top one.
That'll let me choose the different options.
So, there's four main things I'm going to need.
I need the Database Engine, I need Analysis Services,
I need Reporting Services, and I need Integration Services.
The Database Engine will be used to store our data, then Analysis
Services, Reporting Services, and Integration Services,
are all part of a data warehouse.
There's a few other tools I'm interested in
that will help me in my data warehouse development.
I'm interested in Data Quality Services.
The Data Quality Client.
SQL Server Data Tools.
I'll need Client Tools to connect.
I like the complete set of Management Tools.
And, last but not least, I will need the Master Data Services.
We'll be using all of these in different sections of the course,
and we'll get into detail on each of them at the appropriate time.
Here, the machine has run another set of checks,
making sure it can install the items I've selected.
It ran four tests, I passed all of them.
Here, it's asking me to name the instance of SQL Server.
Because this is the first instance installed on
the machine, I can name it almost anything.
It is suggesting the name, MSSQL SERVER.
I like that, but I'd also like to specify that this is, in fact, the 2012 version.
So, I'm going to change the name to SQL SERVER 2012.
It's asking for a default directory.
On a production server, I would probably move that to a
different set of drives, but for testing, the C drive is fine.
It checked for available disk space.
Everything looks good.
Here, it's asking me what account name and password
we'd like to use for each of the different services.
I'm going to go ahead and accept all of the defaults.
Here, it's asking me about security.
Are we going to authenticate via Windows or via Mixed Mode.
I typically go with Mixed Mode, particularly in a testing environment.
Microsoft is pretty clear that using only Windows
authentication will lead to a more secure environment.
So, in production, you might want to go with just Windows
authentication, but in testing, it's fairly common to have Mixed Mode.
If we specify Mixed Mode, we'll need to create a password for the SA account.
At the bottom, we also have the option to specify SQL Server Administrators.
You certainly want to specify at least one at this point.
They have a button for you to quickly and easily add the current user.
Here, it's asking us for
some configuration options for Analysis Services.
I'm going to go ahead and select
the default of Multidimensional with Data Mining.
We also need to add at least one
administrator, and again, I'm going to use the current user.
For Reporting Services, we will accept the default of Install and Configure.
For Error Reporting, I am going to choose to
not send my errors to Microsoft, that is the default.
Again, the machine is running some tests to
make sure the configuration I've selection is valid.
I passed all the tests.
It gives me a summary of everything, and I have the
option to go back, but I'm going to go ahead and click Install.
Great, we have lots of green check marks,
signifying we have successfully installed Microsoft SQL Server 2012.