1 00:00:00,660 --> 00:00:03,774 Now lets look at installing SQL Server 2012. 2 00:00:03,774 --> 00:00:06,730 Here, I've opened up the folder where the file was downloaded. 3 00:00:08,345 --> 00:00:09,810 Double-clicking on it takes me to a 4 00:00:09,810 --> 00:00:12,540 directory that has, amongst other options, setup. 5 00:00:12,540 --> 00:00:14,650 I am interested in the setup option. 6 00:00:14,650 --> 00:00:15,660 I'll double-click on that. 7 00:00:17,920 --> 00:00:20,630 In the options to the left, I see one for installation. 8 00:00:20,630 --> 00:00:22,590 I'll click on that. 9 00:00:22,590 --> 00:00:25,170 And now, here, on the right, I'm presented with four options. 10 00:00:25,170 --> 00:00:29,542 I'm interested in the one at the top, a new SQL Server stand-alone installation. 11 00:00:33,984 --> 00:00:38,000 The installation wizard ran a check for support rules. 12 00:00:38,000 --> 00:00:39,260 It ran nine tests. 13 00:00:39,260 --> 00:00:40,400 I passed all of them. 14 00:00:40,400 --> 00:00:43,230 So, I'll click OK. 15 00:00:43,230 --> 00:00:45,430 It looks like the installation wizard has found 16 00:00:45,430 --> 00:00:47,380 an update it would like me to install. 17 00:00:47,380 --> 00:00:49,653 I'll go ahead and do that now, by clicking Next. 18 00:00:54,460 --> 00:00:57,341 So, the wizard has, again, run some tests to make 19 00:00:57,341 --> 00:01:00,759 sure my machine is capable of handling SQL Server 2012. 20 00:01:00,759 --> 00:01:03,150 It ran seven tests, I passed all of them. 21 00:01:03,150 --> 00:01:04,060 I'll click Next. 22 00:01:05,310 --> 00:01:08,340 Here, I have the option to enter a product key or just 23 00:01:08,340 --> 00:01:14,220 specify the evaluation edition, which will give me a 180-day evaluation edition. 24 00:01:14,220 --> 00:01:14,980 Click Next. 25 00:01:16,390 --> 00:01:18,270 I'll need to accept the license terms. 26 00:01:19,960 --> 00:01:21,560 Here, I have three choices. 27 00:01:21,560 --> 00:01:23,670 The top one allows me to install SQL 28 00:01:23,670 --> 00:01:26,260 Server and choose what features I would like, 29 00:01:26,260 --> 00:01:29,960 the second one installs tools specifically for SharePoint, 30 00:01:29,960 --> 00:01:32,980 and the third one installs all features with defaults. 31 00:01:34,010 --> 00:01:36,980 You could go through and do all features with defaults. 32 00:01:36,980 --> 00:01:40,215 I'd like to customize a few things, so I'm going to select the top one. 33 00:01:40,215 --> 00:01:42,740 That'll let me choose the different options. 34 00:01:44,090 --> 00:01:45,900 So, there's four main things I'm going to need. 35 00:01:45,900 --> 00:01:51,040 I need the Database Engine, I need Analysis Services, 36 00:01:51,040 --> 00:01:55,688 I need Reporting Services, and I need Integration Services. 37 00:01:55,688 --> 00:01:59,370 The Database Engine will be used to store our data, then Analysis 38 00:01:59,370 --> 00:02:02,490 Services, Reporting Services, and Integration Services, 39 00:02:02,490 --> 00:02:04,165 are all part of a data warehouse. 40 00:02:04,165 --> 00:02:07,190 There's a few other tools I'm interested in 41 00:02:07,190 --> 00:02:10,915 that will help me in my data warehouse development. 42 00:02:10,915 --> 00:02:13,690 I'm interested in Data Quality Services. 43 00:02:13,690 --> 00:02:14,930 The Data Quality Client. 44 00:02:17,330 --> 00:02:18,982 SQL Server Data Tools. 45 00:02:18,982 --> 00:02:21,630 I'll need Client Tools to connect. 46 00:02:23,300 --> 00:02:25,530 I like the complete set of Management Tools. 47 00:02:27,170 --> 00:02:31,410 And, last but not least, I will need the Master Data Services. 48 00:02:31,410 --> 00:02:33,830 We'll be using all of these in different sections of the course, 49 00:02:33,830 --> 00:02:37,300 and we'll get into detail on each of them at the appropriate time. 50 00:02:39,230 --> 00:02:41,160 Here, the machine has run another set of checks, 51 00:02:41,160 --> 00:02:44,530 making sure it can install the items I've selected. 52 00:02:44,530 --> 00:02:46,599 It ran four tests, I passed all of them. 53 00:02:47,700 --> 00:02:50,720 Here, it's asking me to name the instance of SQL Server. 54 00:02:50,720 --> 00:02:53,030 Because this is the first instance installed on 55 00:02:53,030 --> 00:02:55,990 the machine, I can name it almost anything. 56 00:02:55,990 --> 00:02:59,620 It is suggesting the name, MSSQL SERVER. 57 00:02:59,620 --> 00:03:05,260 I like that, but I'd also like to specify that this is, in fact, the 2012 version. 58 00:03:07,390 --> 00:03:10,697 So, I'm going to change the name to SQL SERVER 2012. 59 00:03:14,022 --> 00:03:16,939 It's asking for a default directory. 60 00:03:16,939 --> 00:03:20,711 On a production server, I would probably move that to a 61 00:03:20,711 --> 00:03:25,165 different set of drives, but for testing, the C drive is fine. 62 00:03:25,165 --> 00:03:27,410 It checked for available disk space. 63 00:03:27,410 --> 00:03:28,240 Everything looks good. 64 00:03:29,700 --> 00:03:32,040 Here, it's asking me what account name and password 65 00:03:32,040 --> 00:03:34,429 we'd like to use for each of the different services. 66 00:03:34,429 --> 00:03:36,550 I'm going to go ahead and accept all of the defaults. 67 00:03:37,790 --> 00:03:39,752 Here, it's asking me about security. 68 00:03:39,752 --> 00:03:43,950 Are we going to authenticate via Windows or via Mixed Mode. 69 00:03:43,950 --> 00:03:47,690 I typically go with Mixed Mode, particularly in a testing environment. 70 00:03:47,690 --> 00:03:50,760 Microsoft is pretty clear that using only Windows 71 00:03:50,760 --> 00:03:53,640 authentication will lead to a more secure environment. 72 00:03:53,640 --> 00:03:56,280 So, in production, you might want to go with just Windows 73 00:03:56,280 --> 00:04:00,820 authentication, but in testing, it's fairly common to have Mixed Mode. 74 00:04:00,820 --> 00:04:06,046 If we specify Mixed Mode, we'll need to create a password for the SA account. 75 00:04:09,018 --> 00:04:13,480 At the bottom, we also have the option to specify SQL Server Administrators. 76 00:04:13,480 --> 00:04:17,120 You certainly want to specify at least one at this point. 77 00:04:17,120 --> 00:04:20,440 They have a button for you to quickly and easily add the current user. 78 00:04:24,240 --> 00:04:25,250 Here, it's asking us for 79 00:04:25,250 --> 00:04:28,395 some configuration options for Analysis Services. 80 00:04:28,395 --> 00:04:29,510 I'm going to go ahead and select 81 00:04:29,510 --> 00:04:33,080 the default of Multidimensional with Data Mining. 82 00:04:33,080 --> 00:04:34,640 We also need to add at least one 83 00:04:34,640 --> 00:04:37,779 administrator, and again, I'm going to use the current user. 84 00:04:41,100 --> 00:04:46,220 For Reporting Services, we will accept the default of Install and Configure. 85 00:04:46,220 --> 00:04:48,190 For Error Reporting, I am going to choose to 86 00:04:48,190 --> 00:04:51,240 not send my errors to Microsoft, that is the default. 87 00:04:52,850 --> 00:04:54,440 Again, the machine is running some tests to 88 00:04:54,440 --> 00:04:57,195 make sure the configuration I've selection is valid. 89 00:04:57,195 --> 00:04:59,547 I passed all the tests. 90 00:04:59,547 --> 00:05:01,899 It gives me a summary of everything, and I have the 91 00:05:01,899 --> 00:05:04,858 option to go back, but I'm going to go ahead and click Install. 92 00:05:09,136 --> 00:05:12,016 Great, we have lots of green check marks, 93 00:05:12,016 --> 00:05:17,287 signifying we have successfully installed Microsoft SQL Server 2012.