1
00:00:00,000 --> 00:00:01,010

2
00:00:01,010 --> 00:00:04,900
Installing SQL Server 2012.

3
00:00:04,900 --> 00:00:06,330
So in this Nugget, we're going
to walk through an

4
00:00:06,330 --> 00:00:08,310
installation of SQL
Server 2012.

5
00:00:08,310 --> 00:00:10,780
We'll start with some
pre-installation tasks.

6
00:00:10,780 --> 00:00:12,760
We'll take a look at some
post-installation tasks.

7
00:00:12,760 --> 00:00:14,980
And I'll show you some things to
look out for along the way

8
00:00:14,980 --> 00:00:16,219
during the installation.

9
00:00:16,219 --> 00:00:18,470
So checking out the Nugget
overview, these are also the

10
00:00:18,470 --> 00:00:21,620
exam objectives for this
Nugget 470-462.

11
00:00:21,620 --> 00:00:24,150
We're going to start with the
pre-installation task of

12
00:00:24,150 --> 00:00:26,380
configuring the operating
system disk.

13
00:00:26,380 --> 00:00:29,150
Just some little things we need
to make sure are in order

14
00:00:29,150 --> 00:00:31,290
before we install SQL Server.

15
00:00:31,290 --> 00:00:33,580
I mean things like ensuring we
have enough hard disk space,

16
00:00:33,580 --> 00:00:35,350
ensuring that the operating
system is updated with the

17
00:00:35,350 --> 00:00:37,490
latest service packs, things
of that nature.

18
00:00:37,490 --> 00:00:40,300
Then we'll head over to the
virtual Nugget lab and install

19
00:00:40,300 --> 00:00:42,240
SQL Server 2012.

20
00:00:42,240 --> 00:00:43,970
So we're going to spend a lot of
time in the virtual Nugget

21
00:00:43,970 --> 00:00:45,760
lab throughout this series.

22
00:00:45,760 --> 00:00:48,790
The perfect place to start is
getting SQL Server up and

23
00:00:48,790 --> 00:00:49,290
running on us.

24
00:00:49,290 --> 00:00:51,160
So we'll get an instance up
and running over there.

25
00:00:51,160 --> 00:00:54,520
And we'll install the database
engine and get the client

26
00:00:54,520 --> 00:00:56,410
tools and the things that we'll
need to work with the

27
00:00:56,410 --> 00:00:58,110
database engine up and
running first.

28
00:00:58,110 --> 00:01:00,700
Then we'll take a look at how
to get an extra component

29
00:01:00,700 --> 00:01:03,500
installed, SQL Server
Integration Services, an

30
00:01:03,500 --> 00:01:06,980
amazing tool for doing things
such as importing or exporting

31
00:01:06,980 --> 00:01:10,410
data, automating tasks and
processes inside or even

32
00:01:10,410 --> 00:01:11,480
outside of SQL Servers.

33
00:01:11,480 --> 00:01:12,980
So we'll take a look
at how to get that

34
00:01:12,980 --> 00:01:14,170
component up and running.

35
00:01:14,170 --> 00:01:17,740
We'll then take a look at how to
enable and disable features

36
00:01:17,740 --> 00:01:20,560
by going back through the set
up, choosing what instance we

37
00:01:20,560 --> 00:01:22,920
want to work with, and then we
can turn features on and off

38
00:01:22,920 --> 00:01:24,660
pretty easily.

39
00:01:24,660 --> 00:01:25,800
Towards the end of this Nugget,
I also want to show

40
00:01:25,800 --> 00:01:29,340
you how we can install using
a configuration file.

41
00:01:29,340 --> 00:01:32,410
And this is a great way to
standardize your installation

42
00:01:32,410 --> 00:01:34,620
process, especially if you're
going to install SQL Server

43
00:01:34,620 --> 00:01:37,730
2012 in many places across
the enterprise.

44
00:01:37,730 --> 00:01:40,690
And you want a standard install
for them or even just

45
00:01:40,690 --> 00:01:44,440
a base install, something that
is common across all

46
00:01:44,440 --> 00:01:45,360
installations.

47
00:01:45,360 --> 00:01:47,570
Although you may tweak some
specific installations, at

48
00:01:47,570 --> 00:01:49,650
least you can kind of get
a base install going.

49
00:01:49,650 --> 00:01:51,780
So the configuration file
allows us to do that.

50
00:01:51,780 --> 00:01:54,590
It basically allows us to walk
through an install and then

51
00:01:54,590 --> 00:01:58,280
take a snapshot of how we want
that install to look, save to

52
00:01:58,280 --> 00:02:00,680
a configuration file that we
can then run through the

53
00:02:00,680 --> 00:02:02,190
command line for future
installs.

54
00:02:02,190 --> 00:02:03,550
And that's a cool thing that
you can run it through the

55
00:02:03,550 --> 00:02:05,370
command line because
then you got it.

56
00:02:05,370 --> 00:02:08,539
We can match it out, script it
out, so we can even start

57
00:02:08,539 --> 00:02:10,070
automating these installs.

58
00:02:10,070 --> 00:02:11,900
And at the very end here, we'll
take a look at how to

59
00:02:11,900 --> 00:02:12,820
test connectivity.

60
00:02:12,820 --> 00:02:15,230
I'll show you a couple of ways
that we can test connectivity.

61
00:02:15,230 --> 00:02:17,390
Using things like SQL Server
Management Studio, we'll test

62
00:02:17,390 --> 00:02:19,130
connectivity to the
database engine.

63
00:02:19,130 --> 00:02:21,090
And I'll show you how we can
test our connectivity to

64
00:02:21,090 --> 00:02:23,100
integration services.

65
00:02:23,100 --> 00:02:25,070
So we've got plenty to
do in this Nugget.

66
00:02:25,070 --> 00:02:27,040
Let's start with those
pre-installation tasks and get

67
00:02:27,040 --> 00:02:28,460
familiar with how we
can configure an

68
00:02:28,460 --> 00:02:30,720
operating system disk.

69
00:02:30,720 --> 00:02:32,750
So some pretty simple
pre-installation tasks here.

70
00:02:32,750 --> 00:02:36,380
The first one is ensure that
you have six gigabytes of

71
00:02:36,380 --> 00:02:38,770
space available on your
system volume.

72
00:02:38,770 --> 00:02:43,010
So if your C volume is your
system volume, then ensure

73
00:02:43,010 --> 00:02:44,200
that you have six
gigabytes on it.

74
00:02:44,200 --> 00:02:47,600
Even if you install SQL Server
on a different volume that

75
00:02:47,600 --> 00:02:49,890
isn't your system volume, you're
still going to use six

76
00:02:49,890 --> 00:02:51,800
gigabytes of free space on your
system volume because

77
00:02:51,800 --> 00:02:54,640
it's going to extract
all the set up files

78
00:02:54,640 --> 00:02:56,890
onto your system drive.

79
00:02:56,890 --> 00:02:59,180
So that's one big one
to be aware of.

80
00:02:59,180 --> 00:03:02,300
Another one here is update the
operating system with the

81
00:03:02,300 --> 00:03:03,280
latest service packs.

82
00:03:03,280 --> 00:03:04,940
That should be a no brainer
by now right?

83
00:03:04,940 --> 00:03:09,340
Also ensure that .NET Framework
3.5.1 is installed.

84
00:03:09,340 --> 00:03:11,240
And if it didn't come
pre-installed, then on the

85
00:03:11,240 --> 00:03:14,450
client versions of Windows,
you can install it in the

86
00:03:14,450 --> 00:03:16,390
Control Panel, Programs
And Features.

87
00:03:16,390 --> 00:03:17,720
You can turn the features
on and off.

88
00:03:17,720 --> 00:03:19,550
So that's where you'll find it
on that framework in the

89
00:03:19,550 --> 00:03:20,800
client version of Windows.

90
00:03:20,800 --> 00:03:23,370
On the server version of
Windows, you can find it

91
00:03:23,370 --> 00:03:25,620
inside the Server Manager
Features area.

92
00:03:25,620 --> 00:03:27,100
So you can turn it on
and off in there.

93
00:03:27,100 --> 00:03:30,450
Also in a really big one here,
it's always a good idea to get

94
00:03:30,450 --> 00:03:33,430
a RAID 1 mirror going on the
operating system disk just in

95
00:03:33,430 --> 00:03:37,130
case the installation goes sour,
and it somehow screws up

96
00:03:37,130 --> 00:03:38,020
our volume.

97
00:03:38,020 --> 00:03:39,420
We don't want that happening.

98
00:03:39,420 --> 00:03:41,820
So that's always a good backup
plan to make sure that we have

99
00:03:41,820 --> 00:03:45,030
a little fault tolerance there
on our system disk.

100
00:03:45,030 --> 00:03:47,960
So from here, let's head over to
our Virtual Nugget Lab and

101
00:03:47,960 --> 00:03:50,250
get the database engine
up and running.

102
00:03:50,250 --> 00:03:52,230
So we made it over to our
Virtual Nugget Lab instance.

103
00:03:52,230 --> 00:03:54,280
And a few things I want to point
out before we get into

104
00:03:54,280 --> 00:03:57,210
the insulation is number one,
the Virtual Nugget Lab.

105
00:03:57,210 --> 00:04:00,000
If you have access to the
Virtual Nugget Lab, this is a

106
00:04:00,000 --> 00:04:00,780
starting point.

107
00:04:00,780 --> 00:04:03,060
You will be exactly where I am
now when you log in for the

108
00:04:03,060 --> 00:04:04,390
first time.

109
00:04:04,390 --> 00:04:06,820
So what that means is you'll
follow along and do an

110
00:04:06,820 --> 00:04:10,100
installation of SQL Server
Express, and I'll show you, as

111
00:04:10,100 --> 00:04:12,880
well, we're actually going to do
an installation of the full

112
00:04:12,880 --> 00:04:15,820
Enterprise Edition SQL Server in
evaluation mode to showcase

113
00:04:15,820 --> 00:04:17,130
some of the advanced features.

114
00:04:17,130 --> 00:04:17,980
But this is where you'll be.

115
00:04:17,980 --> 00:04:20,329
It's a fresh, clean installation
of SQL Server

116
00:04:20,329 --> 00:04:23,550
2008 Data Center Edition with
Service Pack Two on it.

117
00:04:23,550 --> 00:04:25,080
So let me go into the
file system here.

118
00:04:25,080 --> 00:04:27,400
Right click on the Start
menu, hit Explore.

119
00:04:27,400 --> 00:04:29,490
We'll head up to the C drive.

120
00:04:29,490 --> 00:04:32,440
I also created a folder here
called 70-462 support files.

121
00:04:32,440 --> 00:04:34,330
This will be a nice centralized
place where we'll

122
00:04:34,330 --> 00:04:37,560
put any files that we reference
and use throughout

123
00:04:37,560 --> 00:04:38,390
this series.

124
00:04:38,390 --> 00:04:39,850
And you can see I have
two setups in here.

125
00:04:39,850 --> 00:04:42,680
We have one for Express and
one for Enterprise.

126
00:04:42,680 --> 00:04:45,050
So first we're going to install
the Express Edition.

127
00:04:45,050 --> 00:04:47,100
And then we'll install the
Enterprise Edition in

128
00:04:47,100 --> 00:04:48,230
evaluation mode.

129
00:04:48,230 --> 00:04:50,240
And the reason we need the
Enterprise Edition is for some

130
00:04:50,240 --> 00:04:53,680
of those advanced features that
you can't get using SQL

131
00:04:53,680 --> 00:04:55,740
Server 2012 Express.

132
00:04:55,740 --> 00:04:57,910
And this Nugget is actually
a good example of that.

133
00:04:57,910 --> 00:05:00,070
We need to install integration
services.

134
00:05:00,070 --> 00:05:00,760
Well, guess what?

135
00:05:00,760 --> 00:05:03,590
There are no integration
services with SQL Server 2012

136
00:05:03,590 --> 00:05:05,630
Express Edition, so
that's why we have

137
00:05:05,630 --> 00:05:06,570
the Enterprise Edition.

138
00:05:06,570 --> 00:05:08,340
And the beauty of this is if
you do have access to the

139
00:05:08,340 --> 00:05:11,830
Virtual Nugget Lab, then when
you install it, you'll have

140
00:05:11,830 --> 00:05:13,670
six months from the point that
you install it just like I'm

141
00:05:13,670 --> 00:05:16,900
going to have six months from
now, the point when we're

142
00:05:16,900 --> 00:05:18,820
installing it.

143
00:05:18,820 --> 00:05:20,350
And you'll notice that we
actually have a sample

144
00:05:20,350 --> 00:05:21,470
database in here as well.

145
00:05:21,470 --> 00:05:24,500
The AdventureWorks 2012
sample database that

146
00:05:24,500 --> 00:05:25,320
we're working with.

147
00:05:25,320 --> 00:05:28,310
And we will get this into SQL
Server when we deal with

148
00:05:28,310 --> 00:05:31,420
attaching, and detaching, and
restoring, and talk about

149
00:05:31,420 --> 00:05:34,400
migration here in
a future Nugget.

150
00:05:34,400 --> 00:05:35,390
All right, let's get
the database

151
00:05:35,390 --> 00:05:36,210
engine up and running.

152
00:05:36,210 --> 00:05:37,600
So we're going to do this
using SQL Server

153
00:05:37,600 --> 00:05:39,180
2012 Express Edition.

154
00:05:39,180 --> 00:05:41,705
If we go into this folder, we
have an exe in here that I'm

155
00:05:41,705 --> 00:05:42,440
going to double click.

156
00:05:42,440 --> 00:05:45,560
And this I downloaded this
directly from Microsoft site

157
00:05:45,560 --> 00:05:48,430
that gives us SQL Server
Express with advanced

158
00:05:48,430 --> 00:05:49,700
services, or advanced tools.

159
00:05:49,700 --> 00:05:52,030
And this is the edition that
gives you the most features

160
00:05:52,030 --> 00:05:54,690
and functionality, the edition
of SQL Server Express that is.

161
00:05:54,690 --> 00:05:56,580
So once we run it, we
can hit Run here.

162
00:05:56,580 --> 00:05:59,130
It's going to unpack it into
a random directory into our

163
00:05:59,130 --> 00:06:00,410
system drive.

164
00:06:00,410 --> 00:06:02,930
And then when it's done, it's
going to ask us for

165
00:06:02,930 --> 00:06:03,780
permission.

166
00:06:03,780 --> 00:06:05,730
And then it's going to launch
into the installation centers.

167
00:06:05,730 --> 00:06:07,590
So what I'm going to do here is
I'm going to spare you from

168
00:06:07,590 --> 00:06:09,750
all of the loading screens, and
progress bars, and wait

169
00:06:09,750 --> 00:06:11,710
screens, and all that because
there's plenty of that in your

170
00:06:11,710 --> 00:06:14,260
future with SQL Server and
other things I'm sure.

171
00:06:14,260 --> 00:06:16,110
So let me pause the video.

172
00:06:16,110 --> 00:06:18,950
And what we're going to do then
is rather than wait every

173
00:06:18,950 --> 00:06:20,990
time we click Next through the
Wizard, you'll just see this

174
00:06:20,990 --> 00:06:23,980
screen step by step.

175
00:06:23,980 --> 00:06:26,960
So once you're done unpacking,
it takes us to the

176
00:06:26,960 --> 00:06:27,900
installation center.

177
00:06:27,900 --> 00:06:30,020
And here really it's going
to take us right into the

178
00:06:30,020 --> 00:06:32,000
Installation tab where we can
either do a new installation,

179
00:06:32,000 --> 00:06:34,320
or we can upgrade an existing
installation.

180
00:06:34,320 --> 00:06:37,680
Also the Planning tab has
some useful links on it.

181
00:06:37,680 --> 00:06:39,815
We'll take you out to MSDN and
give you like the hardware and

182
00:06:39,815 --> 00:06:42,760
software requirements and some
other good information.

183
00:06:42,760 --> 00:06:45,850
The Maintenance tab here is
for upgrading an edition.

184
00:06:45,850 --> 00:06:49,970
So you can upgrade what we call
an intra edition upgrade

185
00:06:49,970 --> 00:06:53,060
if you want to upgrade from a
specific edition in the same

186
00:06:53,060 --> 00:06:54,500
version to another edition.

187
00:06:54,500 --> 00:06:56,730
Repair and then you can launch
for product updates.

188
00:06:56,730 --> 00:06:57,820
We have some tools in here.

189
00:06:57,820 --> 00:06:59,720
The System Configuration
Checker.

190
00:06:59,720 --> 00:07:00,830
The Discovery Report.

191
00:07:00,830 --> 00:07:01,800
This is a really cool one.

192
00:07:01,800 --> 00:07:03,910
I'll actually show you this
when we're done installing

193
00:07:03,910 --> 00:07:06,760
because this will give us
information on what is

194
00:07:06,760 --> 00:07:08,100
installed on this server.

195
00:07:08,100 --> 00:07:09,850
So super handy link there.

196
00:07:09,850 --> 00:07:11,300
And you got some other
resources in here.

197
00:07:11,300 --> 00:07:13,090
Just MSDN documentation.

198
00:07:13,090 --> 00:07:14,930
So we're going to go to
the Installation tab.

199
00:07:14,930 --> 00:07:17,990
And we're going to install a
brand new standalone instance

200
00:07:17,990 --> 00:07:20,370
or add features to an
existing insulation.

201
00:07:20,370 --> 00:07:22,030
So that's right, when it comes
time to add or remove

202
00:07:22,030 --> 00:07:24,510
features, we'll just come right
back into here so we can

203
00:07:24,510 --> 00:07:26,710
modify what we did
or didn't do.

204
00:07:26,710 --> 00:07:34,200

205
00:07:34,200 --> 00:07:37,150
So here is technically the
second screen of the Wizard.

206
00:07:37,150 --> 00:07:38,820
Now the reason it skipped
the first screen is

207
00:07:38,820 --> 00:07:40,220
because we were OK.

208
00:07:40,220 --> 00:07:41,530
We didn't have any
errors generated.

209
00:07:41,530 --> 00:07:43,520
But you'll always want to go
back just to make sure you

210
00:07:43,520 --> 00:07:44,800
also don't have any warnings.

211
00:07:44,800 --> 00:07:46,180
And you can see we do have
a warning because Windows

212
00:07:46,180 --> 00:07:47,840
Firewall is enabled
on this machine.

213
00:07:47,840 --> 00:07:50,680
Now if we wanted outside clients
or anybody to remotely

214
00:07:50,680 --> 00:07:53,620
connect to our SQL Server, then
we'll need to generate an

215
00:07:53,620 --> 00:07:55,930
exception or rule
in the firewall.

216
00:07:55,930 --> 00:07:58,150
And you can do that against the
exe that SQL Server, the

217
00:07:58,150 --> 00:08:01,510
actual service, runs under
and also set up some

218
00:08:01,510 --> 00:08:02,460
port rules and such.

219
00:08:02,460 --> 00:08:05,220
So you may want to configure
that if you want remote access

220
00:08:05,220 --> 00:08:07,530
into the SQL Server
on this machine.

221
00:08:07,530 --> 00:08:08,800
Everything else is OK.

222
00:08:08,800 --> 00:08:10,220
So we'll hit Next here.

223
00:08:10,220 --> 00:08:12,140
And from here, we'll just want
to accept the license terms.

224
00:08:12,140 --> 00:08:13,400
We'll hit Next here.

225
00:08:13,400 --> 00:08:16,470
And now it's going to take us
into the feature selection,

226
00:08:16,470 --> 00:08:16,930
the big one.

227
00:08:16,930 --> 00:08:18,130
What features do we install?

228
00:08:18,130 --> 00:08:20,310
And for this first install,
let's just keep it nice, and

229
00:08:20,310 --> 00:08:21,740
simple, and basic here.

230
00:08:21,740 --> 00:08:25,100
And I just want to install
the database engine.

231
00:08:25,100 --> 00:08:27,230
So the database engine, all by
itself, you can choose here

232
00:08:27,230 --> 00:08:28,780
where the shared features
are going to go.

233
00:08:28,780 --> 00:08:30,760
And by the way, if you'll
notice, here are the instance

234
00:08:30,760 --> 00:08:31,410
features up here.

235
00:08:31,410 --> 00:08:32,980
So you'll always
get a service.

236
00:08:32,980 --> 00:08:36,460
Every time you run a set up on
this machine, you'll get a new

237
00:08:36,460 --> 00:08:39,340
service specific to that
instance inside of here for

238
00:08:39,340 --> 00:08:41,490
these areas in the instance
features.

239
00:08:41,490 --> 00:08:43,000
And then these you only
have to install once.

240
00:08:43,000 --> 00:08:44,970
And you'll be able to use
them across all of

241
00:08:44,970 --> 00:08:45,810
the different instances.

242
00:08:45,810 --> 00:08:47,750
That's why they're called
shared features.

243
00:08:47,750 --> 00:08:49,440
So that's where the shared
feature directory comes from

244
00:08:49,440 --> 00:08:52,250
down here and also for
the x86 architecture.

245
00:08:52,250 --> 00:08:53,990
So we're just going to choose
the database engine.

246
00:08:53,990 --> 00:08:56,890
And we'll hit Next.

247
00:08:56,890 --> 00:08:59,460
Now this is another area where
the Wizard will skip right

248
00:08:59,460 --> 00:09:03,050
over this step if you pass
the installation

249
00:09:03,050 --> 00:09:03,770
rules, which we do.

250
00:09:03,770 --> 00:09:05,970
And this is going to check for
Service Pack One of the .NET

251
00:09:05,970 --> 00:09:07,230
Framework 3.5.

252
00:09:07,230 --> 00:09:08,810
So hence 3.51.

253
00:09:08,810 --> 00:09:09,410
So it checked for that.

254
00:09:09,410 --> 00:09:10,790
It was good, and it
skipped over it.

255
00:09:10,790 --> 00:09:12,020
Let's hit Next here.

256
00:09:12,020 --> 00:09:14,040
And now the instance
configuration.

257
00:09:14,040 --> 00:09:16,910
Do you want a default instance
or a named instance.

258
00:09:16,910 --> 00:09:18,690
If you choose a default
instance, you can only one of

259
00:09:18,690 --> 00:09:19,720
these per machine.

260
00:09:19,720 --> 00:09:21,720
And it's going to assume the
name of the computer.

261
00:09:21,720 --> 00:09:24,810
If you use an instance, we'll
access it using the name of

262
00:09:24,810 --> 00:09:26,910
the computer backslash
name of the instance.

263
00:09:26,910 --> 00:09:28,970
I always like to name
the instances.

264
00:09:28,970 --> 00:09:30,670
That way it's clear
cut what kind of

265
00:09:30,670 --> 00:09:31,460
server you're accessing.

266
00:09:31,460 --> 00:09:34,200
You can give it meaningful
information about what kind of

267
00:09:34,200 --> 00:09:35,120
server it is as well.

268
00:09:35,120 --> 00:09:37,250
If it's production, is it
development, what is it?

269
00:09:37,250 --> 00:09:39,310
For this one, though, since
we're going to have multiple

270
00:09:39,310 --> 00:09:43,340
versions of SQL on here, we're
going to call this one how

271
00:09:43,340 --> 00:09:51,250
about SQL 2012 XP Express.

272
00:09:51,250 --> 00:09:52,020
There we go.

273
00:09:52,020 --> 00:09:54,220
And if you click down here, it
will also take that as the

274
00:09:54,220 --> 00:09:58,400
instance ID, which means the
Data Director will be named

275
00:09:58,400 --> 00:10:01,200
the name of the version that
we're on. msSQL11--

276
00:10:01,200 --> 00:10:02,420
the underlying version--

277
00:10:02,420 --> 00:10:04,380
dot name of the instance.

278
00:10:04,380 --> 00:10:05,790
And also the instance
root directory

279
00:10:05,790 --> 00:10:06,820
then will go in here.

280
00:10:06,820 --> 00:10:09,770
So it's just going to pend the
ID onto the root directory

281
00:10:09,770 --> 00:10:12,260
with the internal version
of SQL Server on here.

282
00:10:12,260 --> 00:10:13,750
So this is where all the
data files gets stored.

283
00:10:13,750 --> 00:10:14,870
Any time you do a backup, it'll

284
00:10:14,870 --> 00:10:16,110
be the default directory.

285
00:10:16,110 --> 00:10:18,720
So it's pretty much just a
collection of everything that

286
00:10:18,720 --> 00:10:21,610
we do on this instance will get
stored somewhere in one of

287
00:10:21,610 --> 00:10:22,820
the folders inside of there.

288
00:10:22,820 --> 00:10:25,610
Also if you had any previous
versions installed in this

289
00:10:25,610 --> 00:10:29,130
machine, like we will this one
when we run the evaluation

290
00:10:29,130 --> 00:10:31,370
install, they'll show up
in here with some good

291
00:10:31,370 --> 00:10:32,420
information about it.

292
00:10:32,420 --> 00:10:32,980
So we're down here.

293
00:10:32,980 --> 00:10:35,960
Let's hit next.

294
00:10:35,960 --> 00:10:37,600
Now the Wizard will
do the same thing.

295
00:10:37,600 --> 00:10:39,770
If we meet the disk space
requirements, it'll jump right

296
00:10:39,770 --> 00:10:42,020
over and take us into the server
configuration where we

297
00:10:42,020 --> 00:10:43,900
can configure the service
accounts.

298
00:10:43,900 --> 00:10:45,400
Let me just hit Back
for a second her.

299
00:10:45,400 --> 00:10:47,340
Just to show you it gives you
a summary of the disk space

300
00:10:47,340 --> 00:10:49,300
requirements and where it's
going to put things.

301
00:10:49,300 --> 00:10:52,470
So it's going to require about
a gig of space for the

302
00:10:52,470 --> 00:10:54,560
database engine and
nothing more.

303
00:10:54,560 --> 00:10:58,010
You can see we have about 24
gigs of space on the actual

304
00:10:58,010 --> 00:10:59,030
drive that we're installing
it on.

305
00:10:59,030 --> 00:11:00,240
So it's a system drive.

306
00:11:00,240 --> 00:11:03,380
It's going to take up 167
megabytes, not too bad.

307
00:11:03,380 --> 00:11:05,880
The shared installation
directory is zero because we

308
00:11:05,880 --> 00:11:07,890
didn't have any shared
features installed.

309
00:11:07,890 --> 00:11:10,720
And our instance directory's
going to take up 864 megs.

310
00:11:10,720 --> 00:11:11,260
So we're good there.

311
00:11:11,260 --> 00:11:12,180
Let's hit Next.

312
00:11:12,180 --> 00:11:13,815
And now comes time to configure
the services.

313
00:11:13,815 --> 00:11:16,370

314
00:11:16,370 --> 00:11:19,600
And this is really going to come
down to configuring the

315
00:11:19,600 --> 00:11:20,370
database engine.

316
00:11:20,370 --> 00:11:23,520
The SQL Server browser service,
this is irrelevant

317
00:11:23,520 --> 00:11:26,490
unless you have multiple
instances of SQL Server

318
00:11:26,490 --> 00:11:27,340
installed, which we will.

319
00:11:27,340 --> 00:11:28,250
So it'll become relevant.

320
00:11:28,250 --> 00:11:31,190
And this is just really
a helper service.

321
00:11:31,190 --> 00:11:34,120
When incoming connections come
in, and you have multiple

322
00:11:34,120 --> 00:11:36,910
instances on a box, it's going
to be the one that figures out

323
00:11:36,910 --> 00:11:39,600
which instance the incoming
connection really needs to and

324
00:11:39,600 --> 00:11:40,880
then route it to it.

325
00:11:40,880 --> 00:11:43,450
So this is disabled because
there's only one instance on

326
00:11:43,450 --> 00:11:44,600
this machine.

327
00:11:44,600 --> 00:11:47,550
It will become enabled when we
get into installing the next

328
00:11:47,550 --> 00:11:49,370
version here, the evaluation
edition.

329
00:11:49,370 --> 00:11:51,070
The other thing to really think
about is what service

330
00:11:51,070 --> 00:11:52,480
accounts you're going
to run under.

331
00:11:52,480 --> 00:11:54,400
So MSA accounts.

332
00:11:54,400 --> 00:11:56,760
The general rule is your
MSA accounts, your

333
00:11:56,760 --> 00:11:58,000
Managed Service Accounts.

334
00:11:58,000 --> 00:11:59,870
Those are the ones with the
dollar sign in the name.

335
00:11:59,870 --> 00:12:02,680
Those are good if your service,
your database engine,

336
00:12:02,680 --> 00:12:05,090
for instance, needs
network access.

337
00:12:05,090 --> 00:12:07,160
So that's where you'll use that
because again, it's an

338
00:12:07,160 --> 00:12:08,690
account that's managed
by the domain.

339
00:12:08,690 --> 00:12:09,640
The SPNs are managed.

340
00:12:09,640 --> 00:12:11,030
The passwords are managed.

341
00:12:11,030 --> 00:12:12,120
And it's a good account
because it can

342
00:12:12,120 --> 00:12:13,770
have network access.

343
00:12:13,770 --> 00:12:16,170
These virtual accounts have
no network access.

344
00:12:16,170 --> 00:12:19,620
So if your service will never
need to go outside the local

345
00:12:19,620 --> 00:12:22,050
machine, then you're OK with
setting them as virtual

346
00:12:22,050 --> 00:12:24,560
accounts, which are also nice
because, again, the password

347
00:12:24,560 --> 00:12:26,140
is managed for us.

348
00:12:26,140 --> 00:12:27,340
So we'll leave these
with the default.

349
00:12:27,340 --> 00:12:29,610
And also, by the way, if you
do want to use a domain

350
00:12:29,610 --> 00:12:32,250
account for whatever reason,
you can drop this down and

351
00:12:32,250 --> 00:12:33,860
browse the Active Directory.

352
00:12:33,860 --> 00:12:36,650
And you can also give it the
password that it needs.

353
00:12:36,650 --> 00:12:39,220
So when the service starts up,
it'll login under that account

354
00:12:39,220 --> 00:12:41,720
and be running under
that account as far

355
00:12:41,720 --> 00:12:43,970
as credentials go.

356
00:12:43,970 --> 00:12:46,120
So let's use the virtual account
for our services.

357
00:12:46,120 --> 00:12:47,370
And we'll leave that as it is.

358
00:12:47,370 --> 00:12:49,020
You can also specify
a collation.

359
00:12:49,020 --> 00:12:52,110
A collation determines the code
pages, which are going to

360
00:12:52,110 --> 00:12:54,950
determine the character sets
that are supported as far as

361
00:12:54,950 --> 00:12:56,390
data goes in SQL Server
and how it's

362
00:12:56,390 --> 00:12:58,530
physically stored on disk.

363
00:12:58,530 --> 00:13:00,410
So that's it for the service
configuration.

364
00:13:00,410 --> 00:13:03,920
Now if we hit Next, it's going
to take us into the Database

365
00:13:03,920 --> 00:13:05,200
Engine Configuration
where we can

366
00:13:05,200 --> 00:13:07,790
configure things like security.

367
00:13:07,790 --> 00:13:11,190
The first tab here is really
about what kind of

368
00:13:11,190 --> 00:13:14,220
authentication mode are we going
to use, just plain old

369
00:13:14,220 --> 00:13:17,050
Windows authentication, or are
we going to allow mixed mode

370
00:13:17,050 --> 00:13:21,050
where we can use SQL Server
created logins and SQL Server

371
00:13:21,050 --> 00:13:24,920
security while also supporting
Windows authentication and

372
00:13:24,920 --> 00:13:25,920
Windows security.

373
00:13:25,920 --> 00:13:27,950
So I'll leave this as Windows
authentication mode for now.

374
00:13:27,950 --> 00:13:30,710
I'll show you when we get into
instance management how you

375
00:13:30,710 --> 00:13:34,290
can flip this back to mixed mode
and assign the password

376
00:13:34,290 --> 00:13:36,840
to the SA account, the System
Administrator account, which

377
00:13:36,840 --> 00:13:41,960
is, again, the major SQL Server
authentication account.

378
00:13:41,960 --> 00:13:44,110
Also it's going to add the
current user in as an

379
00:13:44,110 --> 00:13:44,700
administrator.

380
00:13:44,700 --> 00:13:46,830
That way we can administrate
it.

381
00:13:46,830 --> 00:13:48,320
And we're on the Nugget
user account

382
00:13:48,320 --> 00:13:49,670
inside of this instance.

383
00:13:49,670 --> 00:13:51,810
You can also specify your
data directories.

384
00:13:51,810 --> 00:13:53,490
So we have the Data
Root Directory.

385
00:13:53,490 --> 00:13:56,820
And then all of these as far as
the database directory goes

386
00:13:56,820 --> 00:13:59,560
are all going to point to the
data directory here within our

387
00:13:59,560 --> 00:14:02,530
instance folder.

388
00:14:02,530 --> 00:14:04,020
So same with all the
way down except to

389
00:14:04,020 --> 00:14:04,750
the back of the directory.

390
00:14:04,750 --> 00:14:05,910
That's the only one
that's different.

391
00:14:05,910 --> 00:14:07,900
So all of these are going to be
where the data is stored,

392
00:14:07,900 --> 00:14:11,020
temp db, user database, the
actual directory itself for

393
00:14:11,020 --> 00:14:14,410
the database, the MDF files,
or NDF files, or log files.

394
00:14:14,410 --> 00:14:16,470
These are just going to
be all the defaults.

395
00:14:16,470 --> 00:14:20,355
And you can override these when
we create our database.

396
00:14:20,355 --> 00:14:23,370

397
00:14:23,370 --> 00:14:24,900
The last two tabs we're going
to worry about now.

398
00:14:24,900 --> 00:14:27,190
User Instances I wouldn't worry
about because it's going

399
00:14:27,190 --> 00:14:28,770
to be deprecated in
a future version.

400
00:14:28,770 --> 00:14:31,690
They've already announced that
it will be going away and that

401
00:14:31,690 --> 00:14:35,850
you should migrate off of it if
you use it in any sort of

402
00:14:35,850 --> 00:14:36,980
production manner.

403
00:14:36,980 --> 00:14:40,300
Also file streams are great for
working with unstructured

404
00:14:40,300 --> 00:14:43,540
data and storing unstructured
data inside and outside of SQL

405
00:14:43,540 --> 00:14:46,490
Server and unstructured meaning
like image data or

406
00:14:46,490 --> 00:14:47,860
binary data.

407
00:14:47,860 --> 00:14:51,060
So once we're done with this
screen here, we can hit Next.

408
00:14:51,060 --> 00:14:55,130
So once we hit Next, it's going
to take us right to our

409
00:14:55,130 --> 00:14:55,820
installation.

410
00:14:55,820 --> 00:14:57,880
It's going to physically do
the installation here.

411
00:14:57,880 --> 00:15:00,230
It skipped over error reporting
and the installation

412
00:15:00,230 --> 00:15:02,660
configuration rules because
there were no errors and we

413
00:15:02,660 --> 00:15:03,620
met all the rules.

414
00:15:03,620 --> 00:15:04,590
So we're good to go.

415
00:15:04,590 --> 00:15:05,240
I'm going to let this install.

416
00:15:05,240 --> 00:15:08,520
I'll be back when
it's completed.

417
00:15:08,520 --> 00:15:10,990
So we made it to the final
screen here in the Wizard.

418
00:15:10,990 --> 00:15:11,530
We're done.

419
00:15:11,530 --> 00:15:12,530
Everything is successful.

420
00:15:12,530 --> 00:15:13,730
So where we go from here?

421
00:15:13,730 --> 00:15:16,240
Well, let's close out
of set up here.

422
00:15:16,240 --> 00:15:18,530
And we'll close out of the
installation server for SQL

423
00:15:18,530 --> 00:15:20,750
Server Express.

424
00:15:20,750 --> 00:15:22,130
So the first place we
want to look here is

425
00:15:22,130 --> 00:15:23,060
just the Start menu.

426
00:15:23,060 --> 00:15:25,410
If we go to the Start menu,
All Programs, we have

427
00:15:25,410 --> 00:15:27,286
Microsoft SQL Server 2012.

428
00:15:27,286 --> 00:15:29,440
If we open it up here,
we have the Import

429
00:15:29,440 --> 00:15:31,010
and Export Data Wizard.

430
00:15:31,010 --> 00:15:33,940
We have Configuration Manager,
which I'll take you to in a

431
00:15:33,940 --> 00:15:35,820
little bit here, Error
and Usage Reporting.

432
00:15:35,820 --> 00:15:37,730
And then there is our
Installation Center again.

433
00:15:37,730 --> 00:15:39,510
So if we wanted to click on the
Installation Center, we

434
00:15:39,510 --> 00:15:42,680
could get right back to where
we were very easily.

435
00:15:42,680 --> 00:15:45,590

436
00:15:45,590 --> 00:15:47,610
Now the next thing I want to
show you is the file system.

437
00:15:47,610 --> 00:15:48,810
So let's head over to
Windows Explorer.

438
00:15:48,810 --> 00:15:50,730
Let's collapse a few nodes
and head into our

439
00:15:50,730 --> 00:15:52,500
Program Files directory.

440
00:15:52,500 --> 00:15:54,650
And in here, we'll have a
SQL Server directory.

441
00:15:54,650 --> 00:15:58,120
And you can see these are
directories for previous

442
00:15:58,120 --> 00:16:00,780
editions of SQL, even though
they were installed with this.

443
00:16:00,780 --> 00:16:04,230
And the reason they do that is
they give the bare minimum of

444
00:16:04,230 --> 00:16:07,130
what we need or what SQL
Server 2012 needs to be

445
00:16:07,130 --> 00:16:09,570
backwards compatibility
with other versions.

446
00:16:09,570 --> 00:16:12,480
So you'll see it'll have some
DLL files and things that it

447
00:16:12,480 --> 00:16:14,620
needs, again, to communicate
with prior versions.

448
00:16:14,620 --> 00:16:18,160
But this is SQL Server 2012, the
110 directory, otherwise

449
00:16:18,160 --> 00:16:20,740
known as the 11 directory,
8, 9, 10, 11.

450
00:16:20,740 --> 00:16:24,330
And this contains all of the
Program Files for SQL Server.

451
00:16:24,330 --> 00:16:26,720
This is our instance directory
that was created.

452
00:16:26,720 --> 00:16:29,810
So if we go into here, every
instance would if we were to

453
00:16:29,810 --> 00:16:31,490
install another instance, it's
going to have all of these in

454
00:16:31,490 --> 00:16:33,960
here for a new instance,
whatever we name it.

455
00:16:33,960 --> 00:16:35,210
So you have your backup
directory,

456
00:16:35,210 --> 00:16:36,250
which we talked about.

457
00:16:36,250 --> 00:16:37,450
We have the bin directory.

458
00:16:37,450 --> 00:16:38,410
We have the data directory.

459
00:16:38,410 --> 00:16:40,310
If we go into here, you can
see anytime we make a

460
00:16:40,310 --> 00:16:42,130
database, it's going to default
into this directory

461
00:16:42,130 --> 00:16:44,150
for the data and log files.

462
00:16:44,150 --> 00:16:45,800
And these are the four
system databases that

463
00:16:45,800 --> 00:16:47,240
come with SQL Server.

464
00:16:47,240 --> 00:16:51,070
We have the master model,
MSDB and the temp DB.

465
00:16:51,070 --> 00:16:53,210
And then we have some other
things related to this

466
00:16:53,210 --> 00:16:53,850
instance as well.

467
00:16:53,850 --> 00:16:57,540
All instance specific
folders and data.

468
00:16:57,540 --> 00:17:01,190
Now if we back up a little bit
back into our SQL Server

469
00:17:01,190 --> 00:17:04,300
directory, and we go into
this 11 directory.

470
00:17:04,300 --> 00:17:07,579
Now in here, let's go into the
Tools, into the bin directory.

471
00:17:07,579 --> 00:17:10,690
And we have a command
line application

472
00:17:10,690 --> 00:17:11,890
here called SQL command.

473
00:17:11,890 --> 00:17:15,250
And this is really your window
into SQL Server from the

474
00:17:15,250 --> 00:17:16,579
command prompt.

475
00:17:16,579 --> 00:17:19,710
So think of this as like SQL
Server Management Studio for

476
00:17:19,710 --> 00:17:21,010
the command line.

477
00:17:21,010 --> 00:17:23,560
And so if you didn't install
Management Studio, or you

478
00:17:23,560 --> 00:17:26,390
don't have access to it, you
can still get it by just

479
00:17:26,390 --> 00:17:28,600
installing the core database
engine and still test

480
00:17:28,600 --> 00:17:29,390
connectivity.

481
00:17:29,390 --> 00:17:32,050
Now where this will really come
into play is if you're

482
00:17:32,050 --> 00:17:36,110
installing this on a server
core installation because

483
00:17:36,110 --> 00:17:36,890
there is no GUI.

484
00:17:36,890 --> 00:17:38,470
There is no SQL Server
Management Studio.

485
00:17:38,470 --> 00:17:42,070
So unless you have access to
Management Studio remotely,

486
00:17:42,070 --> 00:17:44,920
and you can test connectivity
that way,

487
00:17:44,920 --> 00:17:45,790
then you can do that.

488
00:17:45,790 --> 00:17:48,880
But if you need it local, and
you want to test it local

489
00:17:48,880 --> 00:17:51,840
while you're installing SQL
Server 2012 on a server core

490
00:17:51,840 --> 00:17:54,390
mode, SQL command will
be your friend.

491
00:17:54,390 --> 00:17:57,210
It'll be really your only way
to test connectivity locally

492
00:17:57,210 --> 00:18:00,090
on that server.

493
00:18:00,090 --> 00:18:01,260
And it's pretty easy
to work with.

494
00:18:01,260 --> 00:18:04,300
Let's just fire up a command
prompt really quick here.

495
00:18:04,300 --> 00:18:05,310
We'll go into here.

496
00:18:05,310 --> 00:18:07,450
I'm just going to paste
the path into here.

497
00:18:07,450 --> 00:18:08,490
Usually you can drag it in.

498
00:18:08,490 --> 00:18:11,140
But I believe my ERP session is
not going to let me do it.

499
00:18:11,140 --> 00:18:14,710
So let me just paste
in the past here.

500
00:18:14,710 --> 00:18:19,310
And we'll just do a SQL
CMD forward slash

501
00:18:19,310 --> 00:18:20,140
question mark here.

502
00:18:20,140 --> 00:18:21,950
Ooop, you know what?

503
00:18:21,950 --> 00:18:25,150
I've got to wrap everything
inside of double quotes here.

504
00:18:25,150 --> 00:18:27,120
You know how it goes, right?

505
00:18:27,120 --> 00:18:28,060
There we go.

506
00:18:28,060 --> 00:18:30,120
And get my insert key off.

507
00:18:30,120 --> 00:18:31,320
All right, now we're talking.

508
00:18:31,320 --> 00:18:31,600
There we go.

509
00:18:31,600 --> 00:18:36,130
So here is the help for all the
switches that we can use

510
00:18:36,130 --> 00:18:36,810
for SQL command.

511
00:18:36,810 --> 00:18:38,560
In fact, if we wanted to connect
to it here, we just do

512
00:18:38,560 --> 00:18:40,950
a dash s and then accept the
defaults for everything else.

513
00:18:40,950 --> 00:18:43,125
We'll be able to trust the
connection because we know the

514
00:18:43,125 --> 00:18:44,440
nugget user has access.

515
00:18:44,440 --> 00:18:45,850
Well, let's do the same thing.

516
00:18:45,850 --> 00:18:50,060
Well, let's just do a dash s,
capital S, followed by the

517
00:18:50,060 --> 00:18:55,090
name of the instance, local
host backslash SQL 2012

518
00:18:55,090 --> 00:18:57,600
underscore Express.

519
00:18:57,600 --> 00:18:59,190
And that is a good sign.

520
00:18:59,190 --> 00:19:02,140
If you see one there were we
can submit queries now.

521
00:19:02,140 --> 00:19:05,650
And I like to do this here just
to make sure that we can

522
00:19:05,650 --> 00:19:07,750
get something back
from SQL Server.

523
00:19:07,750 --> 00:19:10,280
Select and add version.

524
00:19:10,280 --> 00:19:11,040
Hit Enter.

525
00:19:11,040 --> 00:19:11,630
Type in Go.

526
00:19:11,630 --> 00:19:13,040
Hit Enter again.

527
00:19:13,040 --> 00:19:13,150
And there we go.

528
00:19:13,150 --> 00:19:14,750
We just ran a query against
SQL Server.

529
00:19:14,750 --> 00:19:18,120
And it returns to us the
version information.

530
00:19:18,120 --> 00:19:23,000
So you can see where
11.0.2100.60 on X64, it is the

531
00:19:23,000 --> 00:19:27,470
Express Edition 64-bit on
Windows NT6 and web building

532
00:19:27,470 --> 00:19:30,350
service pack we're on, Windows
Server 2008 Data Center with

533
00:19:30,350 --> 00:19:33,000
Service Pack 2.

534
00:19:33,000 --> 00:19:34,390
So I would call that
a success.

535
00:19:34,390 --> 00:19:36,070
SQL Server Express
is installed with

536
00:19:36,070 --> 00:19:37,010
just a database engine.

537
00:19:37,010 --> 00:19:38,340
We can test connectivity.

538
00:19:38,340 --> 00:19:39,870
Let's close out of this stuff.

539
00:19:39,870 --> 00:19:43,190
And let's go back up into
our support files.

540
00:19:43,190 --> 00:19:45,520
And let's get SSIS going here.

541
00:19:45,520 --> 00:19:46,910
Not only that, but
let's use the

542
00:19:46,910 --> 00:19:48,230
Enterprise Evaluation Edition.

543
00:19:48,230 --> 00:19:50,110
And I already have this unpacked
inside of here.

544
00:19:50,110 --> 00:19:51,920
So you don't have to go through
the unpacking phase.

545
00:19:51,920 --> 00:19:55,600
If we just run setup.exe
and hit Continue.

546
00:19:55,600 --> 00:19:58,580
This should take us right into
the installation center.

547
00:19:58,580 --> 00:20:00,230
So that's exactly what it's
doing here, launching the

548
00:20:00,230 --> 00:20:01,210
Installation Center.

549
00:20:01,210 --> 00:20:04,060
A lot of this is going
to be the exact same.

550
00:20:04,060 --> 00:20:06,370
So I'm not going to make you sit
through all of it again.

551
00:20:06,370 --> 00:20:08,660
What I am going to do, though,
is just show you the parts

552
00:20:08,660 --> 00:20:11,235
that really matter, such as the
features, where you select

553
00:20:11,235 --> 00:20:11,880
your features.

554
00:20:11,880 --> 00:20:13,490
We need to add SSIS.

555
00:20:13,490 --> 00:20:14,810
We need to add SQL
Server Management

556
00:20:14,810 --> 00:20:16,030
Studio, the data tools.

557
00:20:16,030 --> 00:20:18,680
We'll get everything that we
didn't install when we went

558
00:20:18,680 --> 00:20:20,990
through our express
installation.

559
00:20:20,990 --> 00:20:23,160
So here we are back in the
Installation Center.

560
00:20:23,160 --> 00:20:24,070
And we're going to do
the same thing.

561
00:20:24,070 --> 00:20:27,080
We're going to do another
install here.

562
00:20:27,080 --> 00:20:28,510
We'll add another instance
of the server.

563
00:20:28,510 --> 00:20:29,690
This time, though, we'll
add everything

564
00:20:29,690 --> 00:20:30,720
that we missed before.

565
00:20:30,720 --> 00:20:33,480
We'll add Management Studio, the
data tools, and we'll get

566
00:20:33,480 --> 00:20:36,240
Integration Services
installed as well.

567
00:20:36,240 --> 00:20:38,440
Now the thing to note about
Integration Services is you

568
00:20:38,440 --> 00:20:42,430
can only have one instance of
Integration Services installed

569
00:20:42,430 --> 00:20:42,960
per machine.

570
00:20:42,960 --> 00:20:45,960
The only exception to that rule
is if you're going across

571
00:20:45,960 --> 00:20:49,810
versions because you can have an
instance of SQL Server 2008

572
00:20:49,810 --> 00:20:51,910
Integration Services
and SQL Server

573
00:20:51,910 --> 00:20:55,000
2012 Integration Services.

574
00:20:55,000 --> 00:20:56,500
So we're good here.

575
00:20:56,500 --> 00:20:56,740
Everything looks good.

576
00:20:56,740 --> 00:20:58,490
We passed the validation
and set up rules.

577
00:20:58,490 --> 00:20:59,160
Let's hit OK.

578
00:20:59,160 --> 00:21:01,230
And now it'll launch the
true Setup Wizard.

579
00:21:01,230 --> 00:21:02,620
Again, I won't make you sit
through most of this.

580
00:21:02,620 --> 00:21:05,340
So I'm going to pause this.

581
00:21:05,340 --> 00:21:06,880
So here's the first screen.

582
00:21:06,880 --> 00:21:09,210
And it's a little bit different
because we already

583
00:21:09,210 --> 00:21:10,470
have an instance installed.

584
00:21:10,470 --> 00:21:10,990
And here it is.

585
00:21:10,990 --> 00:21:12,280
It gives us some information
about that

586
00:21:12,280 --> 00:21:13,580
instance we just installed.

587
00:21:13,580 --> 00:21:16,210
So here's where we would
add features.

588
00:21:16,210 --> 00:21:18,410
We could say add features to
an existing instance of SQL

589
00:21:18,410 --> 00:21:20,810
Server, run through, and choose
the feature selection.

590
00:21:20,810 --> 00:21:23,020
And then, it'll add those
features to the instance.

591
00:21:23,020 --> 00:21:25,330
We're going to do another brand
new installation so we

592
00:21:25,330 --> 00:21:28,110
have, again, multiple instances
running on this

593
00:21:28,110 --> 00:21:30,400
machine so we can test out some
of the advanced features

594
00:21:30,400 --> 00:21:32,480
we'll need the Evaluation
Edition for.

595
00:21:32,480 --> 00:21:34,870
And then we can still use SQL
Express for everything else.

596
00:21:34,870 --> 00:21:36,190
All right, so let's perform
a new installation.

597
00:21:36,190 --> 00:21:38,020
We'll hit Next here.

598
00:21:38,020 --> 00:21:40,490
And now it's going to ask us
you can enter a product key

599
00:21:40,490 --> 00:21:41,830
here if you have a valid
product key.

600
00:21:41,830 --> 00:21:44,600
Or you can have six months of
the Evaluation Edition, which

601
00:21:44,600 --> 00:21:45,910
is what we're going to.

602
00:21:45,910 --> 00:21:46,870
And then we'll hit Next.

603
00:21:46,870 --> 00:21:50,050
And we're back to where we
were in the previous

604
00:21:50,050 --> 00:21:50,700
installation.

605
00:21:50,700 --> 00:21:51,840
So we'll accept the licenses
and terms.

606
00:21:51,840 --> 00:21:52,960
We'll hit Next.

607
00:21:52,960 --> 00:21:56,050
And this time because, again,
we have all the features

608
00:21:56,050 --> 00:21:56,770
available to us.

609
00:21:56,770 --> 00:21:58,220
This is the full version here.

610
00:21:58,220 --> 00:22:01,350
We can choose the SQL Server
feature installation if we

611
00:22:01,350 --> 00:22:03,390
want to install the database
engine and then all of the

612
00:22:03,390 --> 00:22:04,760
extra components.

613
00:22:04,760 --> 00:22:07,300
If we want to install SQL
Server PowerPivot for

614
00:22:07,300 --> 00:22:10,640
SharePoint or all features
with the default.

615
00:22:10,640 --> 00:22:11,950
So let's just choose
SQL Server Feature

616
00:22:11,950 --> 00:22:12,690
Installation for now.

617
00:22:12,690 --> 00:22:13,780
Hit Next.

618
00:22:13,780 --> 00:22:17,500
And now we should get a really
nice list of features.

619
00:22:17,500 --> 00:22:19,880
So we've got a lot more
than we've had before.

620
00:22:19,880 --> 00:22:22,150
But we're definitely going to
install the Database Engine.

621
00:22:22,150 --> 00:22:23,930
We'll install replication,
full text.

622
00:22:23,930 --> 00:22:26,490
We're going to install
everything as far as the

623
00:22:26,490 --> 00:22:27,970
database engine goes.

624
00:22:27,970 --> 00:22:32,730
And then for shared features, we
want Integration Services.

625
00:22:32,730 --> 00:22:35,930
I'm also going to add in here
the data tools and the

626
00:22:35,930 --> 00:22:38,870
management tools complete.

627
00:22:38,870 --> 00:22:41,330
So these are the shared features
that we'll be using

628
00:22:41,330 --> 00:22:42,740
and working with.

629
00:22:42,740 --> 00:22:44,770
Everything else I think
we're good on.

630
00:22:44,770 --> 00:22:46,830
We will come back in a future
Nugget again and work with

631
00:22:46,830 --> 00:22:50,830
getting analysis services,
reporting services, and any

632
00:22:50,830 --> 00:22:52,250
other tools that we
may need to work

633
00:22:52,250 --> 00:22:53,730
with here in the future.

634
00:22:53,730 --> 00:22:54,440
But this looks good.

635
00:22:54,440 --> 00:22:57,150
Let's hit Next.

636
00:22:57,150 --> 00:22:58,410
So we chose our features.

637
00:22:58,410 --> 00:23:00,470
We passed the installation
rules, which were again just

638
00:23:00,470 --> 00:23:03,910
checking for the .NET
Framework 3.5.1.

639
00:23:03,910 --> 00:23:05,880
We have our instance
configuration next.

640
00:23:05,880 --> 00:23:11,500
And this one we're going to name
SQL 2012 underscore Eval.

641
00:23:11,500 --> 00:23:12,380
There we go.

642
00:23:12,380 --> 00:23:12,910
We're good.

643
00:23:12,910 --> 00:23:14,850
It shows us or previous
instance on here.

644
00:23:14,850 --> 00:23:18,110
Here is the new instance
directory for this instance

645
00:23:18,110 --> 00:23:19,060
we're installing.

646
00:23:19,060 --> 00:23:22,190
And now we'll hit next.

647
00:23:22,190 --> 00:23:24,640
The Disk Base Requirements
Summary Screen here just shows

648
00:23:24,640 --> 00:23:27,650
us that we're going to require
about five gigabytes on our

649
00:23:27,650 --> 00:23:29,330
installation drive this time.

650
00:23:29,330 --> 00:23:32,130
So if we hit Next here, it's
going to ask us to configure

651
00:23:32,130 --> 00:23:33,350
our services once again.

652
00:23:33,350 --> 00:23:34,190
This time we have
a little more.

653
00:23:34,190 --> 00:23:37,050
We have SQL Server Agent, which
is great for creating

654
00:23:37,050 --> 00:23:40,150
jobs and automating anything
based on a schedule inside of

655
00:23:40,150 --> 00:23:41,780
SQL Server.

656
00:23:41,780 --> 00:23:43,410
We have the database
engine once again.

657
00:23:43,410 --> 00:23:45,180
We'll leave all this stuff
with the default.

658
00:23:45,180 --> 00:23:47,170
And here is Integration
Services.

659
00:23:47,170 --> 00:23:49,500
It also runs as its
own service.

660
00:23:49,500 --> 00:23:52,210
We've got the full text file
and the SQL Server browser,

661
00:23:52,210 --> 00:23:55,490
which you see is now flipped to
automatic because we have

662
00:23:55,490 --> 00:23:56,970
multiple instances.

663
00:23:56,970 --> 00:23:58,500
So the browser is going
to help those incoming

664
00:23:58,500 --> 00:24:01,000
connections find what instance
they're looking for.

665
00:24:01,000 --> 00:24:02,200
So everything looks good here.

666
00:24:02,200 --> 00:24:04,020
Let's hit Next one more time.

667
00:24:04,020 --> 00:24:07,920
And again, here is the server
configuration screen, what

668
00:24:07,920 --> 00:24:10,780
we're going to use here
for security.

669
00:24:10,780 --> 00:24:12,110
And this time it didn't
add our user.

670
00:24:12,110 --> 00:24:15,140
So let's just add the current
user in here.

671
00:24:15,140 --> 00:24:17,760
And that should add our Nugget
user account here as an

672
00:24:17,760 --> 00:24:19,780
administrator to
this instance.

673
00:24:19,780 --> 00:24:20,590
There it is.

674
00:24:20,590 --> 00:24:21,690
Perfect.

675
00:24:21,690 --> 00:24:22,720
So we're good to go here.

676
00:24:22,720 --> 00:24:25,370
This one let's go ahead
and put mixed mode on.

677
00:24:25,370 --> 00:24:26,500
Actually why not?

678
00:24:26,500 --> 00:24:28,390
We'll take two windows
[INAUDIBLE].

679
00:24:28,390 --> 00:24:30,860
We'll change that if we
need to on the fly.

680
00:24:30,860 --> 00:24:30,940
All right.

681
00:24:30,940 --> 00:24:32,110
We'll hit Next here.

682
00:24:32,110 --> 00:24:33,430
Finally, you have some error
reporting if you

683
00:24:33,430 --> 00:24:34,830
want to send errors.

684
00:24:34,830 --> 00:24:36,940
And then comes the
installation.

685
00:24:36,940 --> 00:24:38,690
So it's going to show us some
installation rules.

686
00:24:38,690 --> 00:24:40,230
We're good here.

687
00:24:40,230 --> 00:24:41,260
And now it's going
to be installed.

688
00:24:41,260 --> 00:24:42,990
And here's one thing I
want to make note of.

689
00:24:42,990 --> 00:24:43,510
See this?

690
00:24:43,510 --> 00:24:45,460
You won't get this with
SQL Server Express.

691
00:24:45,460 --> 00:24:47,250
You'll only get this with
the full versions.

692
00:24:47,250 --> 00:24:49,060
But this is our configuration
file.

693
00:24:49,060 --> 00:24:51,990
Everything that we did inside
of here is stored in this

694
00:24:51,990 --> 00:24:53,270
configuration file.

695
00:24:53,270 --> 00:24:57,240
So we're going to need this if
we want to install based on

696
00:24:57,240 --> 00:24:58,330
this configuration file.

697
00:24:58,330 --> 00:25:00,290
So if we want to install another
instance the exact

698
00:25:00,290 --> 00:25:03,100
same way we chose this one with
the same features and

699
00:25:03,100 --> 00:25:06,590
everything, then we can copy
this and remember it.

700
00:25:06,590 --> 00:25:09,320
And I'll copy it and remember
it because I'll show you how

701
00:25:09,320 --> 00:25:12,340
you can install using this
configuration file next.

702
00:25:12,340 --> 00:25:13,610
But we're good here.

703
00:25:13,610 --> 00:25:14,960
So let's set hit the
Install button.

704
00:25:14,960 --> 00:25:16,370
We'll let this install.

705
00:25:16,370 --> 00:25:19,100
And I'll be back when
it's finished.

706
00:25:19,100 --> 00:25:20,170
And we're done.

707
00:25:20,170 --> 00:25:21,110
Installation complete.

708
00:25:21,110 --> 00:25:22,550
We've got the management
tools in there.

709
00:25:22,550 --> 00:25:24,760
We've got another instance
of the database engine.

710
00:25:24,760 --> 00:25:26,640
And we have Integration
Services installed.

711
00:25:26,640 --> 00:25:29,980
So if you close out of this.

712
00:25:29,980 --> 00:25:32,410
Let's just head back into the
Start menu for a second, into

713
00:25:32,410 --> 00:25:35,630
all programs, back into
SQL Server 2012.

714
00:25:35,630 --> 00:25:35,890
And look at this.

715
00:25:35,890 --> 00:25:37,920
We've got a lot more
to work with here.

716
00:25:37,920 --> 00:25:40,830
We've got Integration Services,
which are some extra

717
00:25:40,830 --> 00:25:44,000
tools for working with
Integration Services in here.

718
00:25:44,000 --> 00:25:46,460
Again, you won't launch anything
in here to develop

719
00:25:46,460 --> 00:25:48,100
Integration Services packages.

720
00:25:48,100 --> 00:25:51,210
You'll be doing that using
SQL Server data tools.

721
00:25:51,210 --> 00:25:53,340
We also have SQL Server
Management Studio, which is

722
00:25:53,340 --> 00:25:57,470
what we're going to use to
connect and test connectivity

723
00:25:57,470 --> 00:26:00,090
rather than SQL command to show
you another way to do it

724
00:26:00,090 --> 00:26:02,980
and just to ensure that we've
got everything up and running.

725
00:26:02,980 --> 00:26:05,500
So let's launch SQL Server
Management Studio.

726
00:26:05,500 --> 00:26:06,760
So it'll fire up for
the first time.

727
00:26:06,760 --> 00:26:07,560
It'll take a second.

728
00:26:07,560 --> 00:26:09,160
While that's launching, I'm
going to close out of the

729
00:26:09,160 --> 00:26:10,900
Installation Center.

730
00:26:10,900 --> 00:26:12,335
I'm going to minimize our
Windows Explorer.

731
00:26:12,335 --> 00:26:16,090

732
00:26:16,090 --> 00:26:16,720
And here we go.

733
00:26:16,720 --> 00:26:20,790
So let's browse for more here.

734
00:26:20,790 --> 00:26:22,140
Database engines and
check it out.

735
00:26:22,140 --> 00:26:23,740
We've got our Express
and our Eval.

736
00:26:23,740 --> 00:26:26,550
So if we just connect to our
Express just to make sure that

737
00:26:26,550 --> 00:26:29,090
it does work.

738
00:26:29,090 --> 00:26:29,860
There we go.

739
00:26:29,860 --> 00:26:31,750
And it does work.

740
00:26:31,750 --> 00:26:33,920
We've got all the system
databases.

741
00:26:33,920 --> 00:26:36,070
And this instance is running
and ready to go.

742
00:26:36,070 --> 00:26:39,180
Now let's hit Connect here to
another database engine.

743
00:26:39,180 --> 00:26:42,910
This time let's browse
for our Eval.

744
00:26:42,910 --> 00:26:44,020
Hit OK.

745
00:26:44,020 --> 00:26:45,310
Hit Connect.

746
00:26:45,310 --> 00:26:46,480
And check it out.

747
00:26:46,480 --> 00:26:47,580
Once again, another instance.

748
00:26:47,580 --> 00:26:50,160
You can already tell this
has some of the

749
00:26:50,160 --> 00:26:51,270
advanced features in it.

750
00:26:51,270 --> 00:26:53,930
It's a full featured version
of SQL Server.

751
00:26:53,930 --> 00:26:55,310
We even have SQL Server Agent.

752
00:26:55,310 --> 00:26:56,050
But it's disabled.

753
00:26:56,050 --> 00:26:57,720
I'll show you how
to enable that.

754
00:26:57,720 --> 00:27:00,510
But it's got a lot more already
inside of here than

755
00:27:00,510 --> 00:27:03,870
our instance of SQL
Express does.

756
00:27:03,870 --> 00:27:05,440
So how do we go about
testing out an

757
00:27:05,440 --> 00:27:07,200
Integration Services instance?

758
00:27:07,200 --> 00:27:10,570
Well, we can drop down the
connect button up here and

759
00:27:10,570 --> 00:27:13,950
choose any the external tools
here that is related to SQL

760
00:27:13,950 --> 00:27:15,810
Server Analysis Services,
Integration Services,

761
00:27:15,810 --> 00:27:17,460
Reporting Services,
as your storage.

762
00:27:17,460 --> 00:27:19,670
Or if you wanted to connect to
another database instance, you

763
00:27:19,670 --> 00:27:21,310
could check this right here.

764
00:27:21,310 --> 00:27:23,550
If we choose Integration
Services, it's just going to

765
00:27:23,550 --> 00:27:26,140
give us the Connect To Server
dialogue and point the server

766
00:27:26,140 --> 00:27:27,940
type to Integration Services.

767
00:27:27,940 --> 00:27:29,390
So now we could drop
down and browse.

768
00:27:29,390 --> 00:27:32,400
And you can see we only have
one instance installed.

769
00:27:32,400 --> 00:27:33,720
So it defaulted to it.

770
00:27:33,720 --> 00:27:35,130
And again, we don't have
multi instances

771
00:27:35,130 --> 00:27:36,120
with Integration Services.

772
00:27:36,120 --> 00:27:38,470
So it's just going to assume the
name of the machine that

773
00:27:38,470 --> 00:27:39,050
it's installed.

774
00:27:39,050 --> 00:27:41,050
And on this case, we're
on SQL Nugget Lab.

775
00:27:41,050 --> 00:27:42,270
So if we hit OK.

776
00:27:42,270 --> 00:27:45,280
And we hit Connect, we're
going to get yelled at.

777
00:27:45,280 --> 00:27:46,200
Access is denied.

778
00:27:46,200 --> 00:27:48,200
Now if this kind of stuff
happens in Management Studio,

779
00:27:48,200 --> 00:27:51,140
the best thing to do, at least
the first thing to do anyway,

780
00:27:51,140 --> 00:27:53,815
if we're going any
further, is--

781
00:27:53,815 --> 00:27:54,680
this always helps.

782
00:27:54,680 --> 00:27:55,400
I'm going to minimize this.

783
00:27:55,400 --> 00:27:57,070
We'll leave this one running.

784
00:27:57,070 --> 00:27:58,690
We're going to run it again
through the Start menu.

785
00:27:58,690 --> 00:28:00,135
I'll take the shortcut here.

786
00:28:00,135 --> 00:28:03,710
We'll Right Click on it and
choose Run as Administrator.

787
00:28:03,710 --> 00:28:05,080
Hit Continue.

788
00:28:05,080 --> 00:28:06,350
And that should do it.

789
00:28:06,350 --> 00:28:07,900
So running as the admin is
always a good thing,

790
00:28:07,900 --> 00:28:10,360
especially when you're working
with these external tools such

791
00:28:10,360 --> 00:28:12,340
as Analysis Services,
Integration Services from

792
00:28:12,340 --> 00:28:15,950
Management Studio because
it'll bypass

793
00:28:15,950 --> 00:28:17,040
some of those problems.

794
00:28:17,040 --> 00:28:17,700
So let's try it again.

795
00:28:17,700 --> 00:28:18,410
Same exact thing.

796
00:28:18,410 --> 00:28:20,080
It's going to default to
Integration Services since

797
00:28:20,080 --> 00:28:22,570
that's what we last
tried to use.

798
00:28:22,570 --> 00:28:23,360
SQL Nugget Lab.

799
00:28:23,360 --> 00:28:24,580
We'll hit Connect.

800
00:28:24,580 --> 00:28:25,060
And look at that.

801
00:28:25,060 --> 00:28:26,520
This time it works perfectly.

802
00:28:26,520 --> 00:28:27,140
So that was the problem.

803
00:28:27,140 --> 00:28:28,440
That was the error
in that case.

804
00:28:28,440 --> 00:28:29,820
And that'll happen sometimes.

805
00:28:29,820 --> 00:28:32,120
So it's always a good idea just
to run Management Studio

806
00:28:32,120 --> 00:28:34,580
as an administrator.

807
00:28:34,580 --> 00:28:36,450
And this is a very simple
interface for managing

808
00:28:36,450 --> 00:28:40,010
packages stored in the
Integration Services instance.

809
00:28:40,010 --> 00:28:45,310
So again, we have a database
engine installed here.

810
00:28:45,310 --> 00:28:48,030
The thing with Integration
Services, if you don't have a

811
00:28:48,030 --> 00:28:52,910
database engine installed with
Integration Services, then

812
00:28:52,910 --> 00:28:57,070
anytime a package is run from
a job, the job is actually

813
00:28:57,070 --> 00:29:01,170
going to run the package on the
machine that invoked it.

814
00:29:01,170 --> 00:29:02,700
So this can get people
in trouble.

815
00:29:02,700 --> 00:29:05,160
I've gotten in trouble a few
times here because if you

816
00:29:05,160 --> 00:29:08,530
develop a package on a machine
that has Integration Services

817
00:29:08,530 --> 00:29:12,280
on it, and you have pads that
point to files and directories

818
00:29:12,280 --> 00:29:14,780
on that machine, but you don't
have the database engine

819
00:29:14,780 --> 00:29:16,880
installed on that same machine
that Integration Services

820
00:29:16,880 --> 00:29:19,000
runs, then that package is
going to execute on the

821
00:29:19,000 --> 00:29:20,730
machine the job ran on.

822
00:29:20,730 --> 00:29:22,650
And those pads and directories
may not exist.

823
00:29:22,650 --> 00:29:24,825
So you'll get some crazy errors
that you'll be hunting

824
00:29:24,825 --> 00:29:25,790
down for days.

825
00:29:25,790 --> 00:29:28,220
So that's why it's a good idea
if you do install Integration

826
00:29:28,220 --> 00:29:30,430
Services on a machine, you
should install the database

827
00:29:30,430 --> 00:29:33,820
engine because it stores its
packages as well here in the

828
00:29:33,820 --> 00:29:37,630
MSDB database on that
database instance.

829
00:29:37,630 --> 00:29:39,690
In this case, we installed
Integration Services with our

830
00:29:39,690 --> 00:29:41,130
full e-validation.

831
00:29:41,130 --> 00:29:44,290
So if we were to deploy our
packages into the SQL Nugget

832
00:29:44,290 --> 00:29:46,660
Lab Integration Services since
they would go into the MSD

833
00:29:46,660 --> 00:29:49,180
database in our Eval instance.

834
00:29:49,180 --> 00:29:51,820

835
00:29:51,820 --> 00:29:54,620
Now if you are one that creates
Integration Services

836
00:29:54,620 --> 00:29:58,160
packages, which you'll do over
in SQL Server Data Tools, when

837
00:29:58,160 --> 00:30:00,850
it comes time to deploy them,
you will deploy them inside of

838
00:30:00,850 --> 00:30:02,110
this instance more
than likely.

839
00:30:02,110 --> 00:30:03,010
And you can do things
like this.

840
00:30:03,010 --> 00:30:05,730
You can create an organized
structure inside of MSDB here.

841
00:30:05,730 --> 00:30:08,910
We can create a folder
called My Imports.

842
00:30:08,910 --> 00:30:11,420
And then from Data Tools, when
it comes time-- and let's just

843
00:30:11,420 --> 00:30:14,280
refresh this so we can
see that folder.

844
00:30:14,280 --> 00:30:16,180
In Data Tools, when it comes
time to deploy it to this

845
00:30:16,180 --> 00:30:18,660
instance, you'll point to your
Integration Services instance,

846
00:30:18,660 --> 00:30:21,130
browse to the folder you want
to put it in, and then place

847
00:30:21,130 --> 00:30:22,780
it inside of that folder.

848
00:30:22,780 --> 00:30:25,690
And then from a database engine,
you can go into SQL

849
00:30:25,690 --> 00:30:29,780
Server Agent, create a job,
point it to this Integration

850
00:30:29,780 --> 00:30:32,470
Services server, browse to the
package, and you're off and

851
00:30:32,470 --> 00:30:37,560
running with automated
SSIS packages.

852
00:30:37,560 --> 00:30:38,460
So cool stuff there.

853
00:30:38,460 --> 00:30:39,980
All right, let's close
out of our

854
00:30:39,980 --> 00:30:42,390
Management Studio instances.

855
00:30:42,390 --> 00:30:44,270
And I want to show you where
the services are, where you

856
00:30:44,270 --> 00:30:46,570
can manage them, where we
should be managing them,

857
00:30:46,570 --> 00:30:47,390
according to Microsoft.

858
00:30:47,390 --> 00:30:49,730
First let me just show you the
standard place to find

859
00:30:49,730 --> 00:30:52,960
services, which is Start,
Administrative Tools, and the

860
00:30:52,960 --> 00:30:53,990
Services Applet.

861
00:30:53,990 --> 00:30:57,490
So this is what we're all used
to I'm sure and what we've

862
00:30:57,490 --> 00:31:00,230
become used to over the years
of managing services.

863
00:31:00,230 --> 00:31:02,450
And you can view the SQL Server
Services in here.

864
00:31:02,450 --> 00:31:04,650
So these two are the database
engines because they just say

865
00:31:04,650 --> 00:31:06,440
SQL Server followed by
the instance name.

866
00:31:06,440 --> 00:31:08,660
Here's SQL Server Agent,
each instance.

867
00:31:08,660 --> 00:31:11,530
You can see our Eval instance
came manual.

868
00:31:11,530 --> 00:31:13,380
Our Express instance
came disabled.

869
00:31:13,380 --> 00:31:15,720
And then we've got our
supporting services as well.

870
00:31:15,720 --> 00:31:19,600
So Microsoft recommends we do
not start, stop, change logins

871
00:31:19,600 --> 00:31:21,740
or start up types, or really
manage the services from here.

872
00:31:21,740 --> 00:31:23,980
Microsoft advises we
do that through the

873
00:31:23,980 --> 00:31:25,120
Configuration Manager.

874
00:31:25,120 --> 00:31:27,630
So if we go to Start, All
Programs, back into SQL Server

875
00:31:27,630 --> 00:31:31,950
2012, inside of Configuration
Tools, we have the SQL Server

876
00:31:31,950 --> 00:31:33,710
Configuration Manager.

877
00:31:33,710 --> 00:31:36,550
So if we launch this, you can
see the first node here is SQL

878
00:31:36,550 --> 00:31:38,240
Server Services.

879
00:31:38,240 --> 00:31:41,640
So they advise we start, stop,
change, and manage them

880
00:31:41,640 --> 00:31:44,320
through here because it's
through SQL Server.

881
00:31:44,320 --> 00:31:46,260
And if there are any other
dependent processes or

882
00:31:46,260 --> 00:31:48,465
services, SQL will handle
them appropriately.

883
00:31:48,465 --> 00:31:51,050

884
00:31:51,050 --> 00:31:54,810
And not only that, but we do
have extra things, extra

885
00:31:54,810 --> 00:31:57,920
properties and options we can
configure at the service level

886
00:31:57,920 --> 00:31:59,430
through Configuration Manager.

887
00:31:59,430 --> 00:32:02,790
For instance, if we double click
on our Eval database

888
00:32:02,790 --> 00:32:06,630
engines, you'll notice we have
things like always on high

889
00:32:06,630 --> 00:32:10,090
availability options,
file stream options.

890
00:32:10,090 --> 00:32:11,780
And then you have some advanced
things that are,

891
00:32:11,780 --> 00:32:14,410
again, related to SQL Server.

892
00:32:14,410 --> 00:32:17,650
So good idea to stay in here
when we're going to do things

893
00:32:17,650 --> 00:32:18,900
such as manage the services.

894
00:32:18,900 --> 00:32:21,560

895
00:32:21,560 --> 00:32:23,280
Now one more thing I do want
to mention about adding and

896
00:32:23,280 --> 00:32:24,060
removing features.

897
00:32:24,060 --> 00:32:25,550
Adding features,
piece of cake.

898
00:32:25,550 --> 00:32:27,430
We just go into Installation
Center.

899
00:32:27,430 --> 00:32:31,070
We re-run the set up and then
choose new features to add to

900
00:32:31,070 --> 00:32:32,780
an existing instance.

901
00:32:32,780 --> 00:32:34,590
Removing features is similar.

902
00:32:34,590 --> 00:32:36,930
It's just where you find it
is a little bit different.

903
00:32:36,930 --> 00:32:40,190
So in the Start menu, inside of
your Control Panel, you go

904
00:32:40,190 --> 00:32:42,560
into Programs And Features.

905
00:32:42,560 --> 00:32:45,800
In here you choose your SQL
Server 2012 Installation.

906
00:32:45,800 --> 00:32:46,950
Hit Uninstall Change.

907
00:32:46,950 --> 00:32:48,030
And continue here.

908
00:32:48,030 --> 00:32:49,910
And it's going to relaunch
us into set up.

909
00:32:49,910 --> 00:32:52,980
Here we would choose Remove.

910
00:32:52,980 --> 00:32:55,200
And it's going to launch us
back into a set up here.

911
00:32:55,200 --> 00:32:57,650
The big difference is it's
going to take us into the

912
00:32:57,650 --> 00:33:01,160
Features Selection area of the
Wizard just like when we were

913
00:33:01,160 --> 00:33:02,660
doing installation.

914
00:33:02,660 --> 00:33:06,390
Only rather than choose the
features you want to install,

915
00:33:06,390 --> 00:33:07,280
it's going to give us a list of

916
00:33:07,280 --> 00:33:08,880
features that are installed.

917
00:33:08,880 --> 00:33:11,990
And we choose the ones that we
would like to uninstall.

918
00:33:11,990 --> 00:33:15,530
That's really the only
difference between adding

919
00:33:15,530 --> 00:33:18,420
features and removing features
is where you'll find it and

920
00:33:18,420 --> 00:33:20,860
the fact that you're removing
features that already exist

921
00:33:20,860 --> 00:33:25,790
rather than add features
that don't exist.

922
00:33:25,790 --> 00:33:27,610
So you can see when we get
launched into the Wizard, we

923
00:33:27,610 --> 00:33:29,840
just drop down to what feature
or what instance we want to

924
00:33:29,840 --> 00:33:32,310
remove features from, or if we
only want to remove shared

925
00:33:32,310 --> 00:33:35,380
features, we choose our
instance, we hit Next.

926
00:33:35,380 --> 00:33:37,940
And now it'll give us a
list of those features

927
00:33:37,940 --> 00:33:38,830
that already exist.

928
00:33:38,830 --> 00:33:40,960
And it also gives you the
shared features as well.

929
00:33:40,960 --> 00:33:43,100
So if you wanted to remove
shared features, you could.

930
00:33:43,100 --> 00:33:44,980
So you just choose what you
want to remove, hit Next.

931
00:33:44,980 --> 00:33:45,890
It'll remove it.

932
00:33:45,890 --> 00:33:46,450
And you'll be done.

933
00:33:46,450 --> 00:33:49,310
So let's cancel out of this and
take a look at how we can

934
00:33:49,310 --> 00:33:54,200
install using a configuration
file, which is a great way to

935
00:33:54,200 --> 00:33:56,830
save yourself some time,
especially if you're doing

936
00:33:56,830 --> 00:33:59,880
multiple installations across
your network or enterprise.

937
00:33:59,880 --> 00:34:02,290
And it's a great way to script
out the installation.

938
00:34:02,290 --> 00:34:06,390
So the configuration.ini file
I pointed to earlier stores

939
00:34:06,390 --> 00:34:09,020
all the settings that we did
throughout the Wizard, the

940
00:34:09,020 --> 00:34:11,699
Installation Wizard, everything
that we chose.

941
00:34:11,699 --> 00:34:15,860
And it gives us an easy way to
script it out using setup.exe

942
00:34:15,860 --> 00:34:18,710
at the command line, and passing
in a switch, and then

943
00:34:18,710 --> 00:34:21,449
passing in the path to the
configuration file.

944
00:34:21,449 --> 00:34:23,620
So what's cool about this
is that, again, we

945
00:34:23,620 --> 00:34:24,480
can script it out.

946
00:34:24,480 --> 00:34:26,389
And you can then do an
unattended installation.

947
00:34:26,389 --> 00:34:28,800
I'll show you some switches
we can use to quiet the

948
00:34:28,800 --> 00:34:31,460
installation and accept the
license agreement so it can be

949
00:34:31,460 --> 00:34:32,870
completely unattended.

950
00:34:32,870 --> 00:34:35,550
And you can push this down to
whatever PCs you want using

951
00:34:35,550 --> 00:34:37,639
whatever method you'd like.

952
00:34:37,639 --> 00:34:41,040
The other side of this is if
you have an installation of

953
00:34:41,040 --> 00:34:43,110
SQL Server that's already out
there that you want to take a

954
00:34:43,110 --> 00:34:46,469
snapshot of, and maybe it was
already installed before, and

955
00:34:46,469 --> 00:34:48,859
you can't walk through the
Wizard because you don't know

956
00:34:48,859 --> 00:34:51,670
what the settings are, then sys
prep is perfect for that.

957
00:34:51,670 --> 00:34:53,620
Sys prep is a great
way to do imaging.

958
00:34:53,620 --> 00:34:56,250
So you can take an image of your
SQL Server and deploy it

959
00:34:56,250 --> 00:34:57,600
alternatively that way.

960
00:34:57,600 --> 00:34:59,000
But we're going to focus
here on how to use the

961
00:34:59,000 --> 00:35:00,870
configuration.ini file.

962
00:35:00,870 --> 00:35:03,980
And really it's just a matter of
getting access and finding

963
00:35:03,980 --> 00:35:07,800
that ini file, running through
the Wizard once, setting up

964
00:35:07,800 --> 00:35:09,760
exactly how you would want it
to look, setting up your

965
00:35:09,760 --> 00:35:13,330
service configurations and such,
and then finding that

966
00:35:13,330 --> 00:35:16,150
ini file, and then running it
through setup.exe through the

967
00:35:16,150 --> 00:35:16,750
command prompt.

968
00:35:16,750 --> 00:35:18,030
That's really all
there is to it.

969
00:35:18,030 --> 00:35:20,780
So first of all, where
do we find it?

970
00:35:20,780 --> 00:35:23,450
Well, I copied the path earlier
when we were in there.

971
00:35:23,450 --> 00:35:24,540
That's probably the
best way to do it.

972
00:35:24,540 --> 00:35:26,490
Let me show you where
it is anyway.

973
00:35:26,490 --> 00:35:29,510
If we go into Program Files, SQL
Server, it's going to be

974
00:35:29,510 --> 00:35:31,750
in the version of SQL Server
that we're currently in.

975
00:35:31,750 --> 00:35:34,610
Setup bootstrap log.

976
00:35:34,610 --> 00:35:37,210
And then in the log file, you
want to find the date that you

977
00:35:37,210 --> 00:35:38,960
ran the set up.

978
00:35:38,960 --> 00:35:45,720
So I actually ran the set
up on 8/3 at 005217.

979
00:35:45,720 --> 00:35:46,030
There it is.

980
00:35:46,030 --> 00:35:46,930
This is the one that I ran.

981
00:35:46,930 --> 00:35:48,630
So inside of here, here it is.

982
00:35:48,630 --> 00:35:50,100
Here's the one that
we ran right here.

983
00:35:50,100 --> 00:35:51,380
And if you take a look
at this here--

984
00:35:51,380 --> 00:35:53,250
I'm just going to Right
Click on it and

985
00:35:53,250 --> 00:35:54,980
open it with Notepad.

986
00:35:54,980 --> 00:35:58,470
You can see that really this is
what all the command line

987
00:35:58,470 --> 00:35:59,210
options support.

988
00:35:59,210 --> 00:36:02,390
So if we run setup.exe at the
command line and look at all

989
00:36:02,390 --> 00:36:05,870
the switches for it, these are
really all of the switches

990
00:36:05,870 --> 00:36:06,610
that are in there.

991
00:36:06,610 --> 00:36:08,570
So action equals install
or uninstall.

992
00:36:08,570 --> 00:36:10,690
And it actually shows you
what these switches do.

993
00:36:10,690 --> 00:36:12,260
So that's all the configuration
file does, just

994
00:36:12,260 --> 00:36:14,930
tracks all the settings we
chose through the Wizard.

995
00:36:14,930 --> 00:36:18,830
So what we need to do now is
head back up here to our

996
00:36:18,830 --> 00:36:19,570
Install Director.

997
00:36:19,570 --> 00:36:22,140
I'm just going to first get
a command prompt going.

998
00:36:22,140 --> 00:36:23,600
So we've got a command
prompt going.

999
00:36:23,600 --> 00:36:26,710
Now we need to get our path
to our setup.exe in here.

1000
00:36:26,710 --> 00:36:27,230
So let's do that.

1001
00:36:27,230 --> 00:36:28,930
I'm just going to
copy this path.

1002
00:36:28,930 --> 00:36:30,870
I'm going to come
down here first.

1003
00:36:30,870 --> 00:36:34,810
I'm actually going to do
an open quote here.

1004
00:36:34,810 --> 00:36:36,550
And then we'll paste
in our path.

1005
00:36:36,550 --> 00:36:40,430
Let's do a setup.exe on the
end of that, end of quote.

1006
00:36:40,430 --> 00:36:44,500
And then we're going to go
forward slash configuration

1007
00:36:44,500 --> 00:36:46,550
file equals--

1008
00:36:46,550 --> 00:36:50,300
and now this is going to be the
path to our configuration

1009
00:36:50,300 --> 00:36:52,590
file, which I just happen
to have on the

1010
00:36:52,590 --> 00:36:55,060
Clipboard as well here.

1011
00:36:55,060 --> 00:36:56,620
So let's paste it in.

1012
00:36:56,620 --> 00:36:57,870
There it is.

1013
00:36:57,870 --> 00:36:59,990

1014
00:36:59,990 --> 00:37:01,830
So if we were to run this
now, it would run

1015
00:37:01,830 --> 00:37:03,010
us through the Wizard.

1016
00:37:03,010 --> 00:37:03,760
It would launch the Wizard.

1017
00:37:03,760 --> 00:37:06,190
And it would just use
a configuration

1018
00:37:06,190 --> 00:37:06,940
file for all the settings.

1019
00:37:06,940 --> 00:37:09,530
We would still need to
click buttons and

1020
00:37:09,530 --> 00:37:10,480
watch progress bars.

1021
00:37:10,480 --> 00:37:12,345
So if we wanted to bypass
that, we could use the Q

1022
00:37:12,345 --> 00:37:14,210
switch, which stands
for quiet mode.

1023
00:37:14,210 --> 00:37:17,260
This'll bypass pretty much
everything, the entire Wizard

1024
00:37:17,260 --> 00:37:18,780
and just run it with
the settings.

1025
00:37:18,780 --> 00:37:23,420
The only other thing we really
need to do here is I accept

1026
00:37:23,420 --> 00:37:26,940
SQL Server license terms.

1027
00:37:26,940 --> 00:37:28,560
There's your license
agreement.

1028
00:37:28,560 --> 00:37:31,880
And by we can also do a QS.

1029
00:37:31,880 --> 00:37:38,040
A QS is quiet simple mode, which
will give us the Wizard

1030
00:37:38,040 --> 00:37:38,390
and the windows.

1031
00:37:38,390 --> 00:37:40,170
You'll be able to see the
progress bars, but you won't

1032
00:37:40,170 --> 00:37:41,830
need to click any buttons.

1033
00:37:41,830 --> 00:37:43,890
So Q won't show us anything.

1034
00:37:43,890 --> 00:37:47,050
It'll just do it quietly
unattended without anyone

1035
00:37:47,050 --> 00:37:48,960
knowing, the ninja install.

1036
00:37:48,960 --> 00:37:51,890
Or you can do QS, and see some
windows, and still see the

1037
00:37:51,890 --> 00:37:52,750
progress bars and such.

1038
00:37:52,750 --> 00:37:53,740
But that's it.

1039
00:37:53,740 --> 00:37:55,190
Not much too it.

1040
00:37:55,190 --> 00:37:58,140
This configuration file really
makes things a lot easier

1041
00:37:58,140 --> 00:38:00,920
because it tracks everything
we did in the Wizard.

1042
00:38:00,920 --> 00:38:03,170
And then we can reuse it for
future installs whether you

1043
00:38:03,170 --> 00:38:05,030
want to do it unattended
or not.

1044
00:38:05,030 --> 00:38:07,120
It's a great way to standardize
your installs

1045
00:38:07,120 --> 00:38:10,370
across your network
or enterprise.

1046
00:38:10,370 --> 00:38:14,460
So that's about all there is to
installing SQL Server 2012.

1047
00:38:14,460 --> 00:38:16,670
So in this Nugget we took a
look at the different ways

1048
00:38:16,670 --> 00:38:18,760
that we can install
SQL Server 2012.

1049
00:38:18,760 --> 00:38:21,570
We started off with just some
basic prerequisites there, as

1050
00:38:21,570 --> 00:38:24,070
far as hard drive space is
concerned and software

1051
00:38:24,070 --> 00:38:26,040
requirements such as
the .NET framework.

1052
00:38:26,040 --> 00:38:29,130
We also took a look there at
how to install SQL Server

1053
00:38:29,130 --> 00:38:30,050
Express Edition.

1054
00:38:30,050 --> 00:38:32,620
We started with Express, just
a basic database engine

1055
00:38:32,620 --> 00:38:33,970
install with nothing else.

1056
00:38:33,970 --> 00:38:36,330
And we saw that we could connect
to it using the SQL

1057
00:38:36,330 --> 00:38:38,130
Command Utility.

1058
00:38:38,130 --> 00:38:42,260
We then took a look at how to
do a full installation using

1059
00:38:42,260 --> 00:38:44,770
the Evaluation Edition where
we got the database engine

1060
00:38:44,770 --> 00:38:46,350
installed, some tools
up and running.

1061
00:38:46,350 --> 00:38:48,800
And we even took a look at how
to get an external component

1062
00:38:48,800 --> 00:38:50,710
in SSIS, SQL Server Integration

1063
00:38:50,710 --> 00:38:52,640
Services, up and running.

1064
00:38:52,640 --> 00:38:55,330
We took a look at how to work
with services where we can

1065
00:38:55,330 --> 00:38:57,110
configure them and work
with SQL Server

1066
00:38:57,110 --> 00:38:58,400
Configuration Manager.

1067
00:38:58,400 --> 00:39:00,540
We saw how to test connectivity
to the Database

1068
00:39:00,540 --> 00:39:03,200
Engine and Integration Services,
took a look how you

1069
00:39:03,200 --> 00:39:05,670
can enable and disable
features.

1070
00:39:05,670 --> 00:39:08,020
And at the end here, I showed
you how to install it using a

1071
00:39:08,020 --> 00:39:10,440
configuration file from
the command line.

1072
00:39:10,440 --> 00:39:11,840
I hope this has been informative
for you.

1073
00:39:11,840 --> 00:39:13,090
And I thank you for viewing.

1074
00:39:13,090 --> 00:39:14,000