0 1 00:00:01,300 --> 00:00:04,680 And welcome back to back Space Academy. In this lab. 1 2 00:00:04,690 --> 00:00:08,020 We're going to again look at another RDS database engine. 2 3 00:00:08,020 --> 00:00:14,290 This time it will be the Microsoft SQL server engine. We will launch an instance again and we will connect in 3 4 00:00:14,290 --> 00:00:19,840 to that instance using the Microsoft SQL Server Management Studio. 4 5 00:00:19,870 --> 00:00:24,550 Now back in the RDS dashboard again we launch a DB instance and we will make sure that we 5 6 00:00:24,550 --> 00:00:31,900 have free tier eligible only selected because SQL server is available on the free tier if you choose 6 7 00:00:32,170 --> 00:00:34,660 SQL Server Express Edition. 7 8 00:00:34,660 --> 00:00:35,870 So that's what we'll do. 8 9 00:00:35,940 --> 00:00:38,010 We'll select the SQL Server Express Edition. 9 10 00:00:40,480 --> 00:00:47,020 And we'll leave it license included and we'll leave it db t2.micro, we won't worry about time zone and 10 11 00:00:47,020 --> 00:00:48,990 we're going to put in an instance identifier 11 12 00:00:51,890 --> 00:00:55,690 and I'll just use backspace-rds-ms-sql-server. 12 13 00:00:55,970 --> 00:00:59,700 And again we put in a username and password. 13 14 00:01:00,930 --> 00:01:03,610 And once we've got that in there we'll just click on the next step. 14 15 00:01:05,730 --> 00:01:11,400 And I will leave create new security group because there's not one there already set up for us. 15 16 00:01:11,400 --> 00:01:16,530 I will create one but all that is going to do is create a security group again with inbound rules for 16 17 00:01:17,100 --> 00:01:21,840 access on port 1433. 17 18 00:01:22,020 --> 00:01:27,700 We will ignore Microsoft SQL server windows authentication because what that does is if you've 18 19 00:01:27,700 --> 00:01:35,920 got Microsoft active directory on your enterprise you can use your Microsoft active directory to authenticate 19 20 00:01:35,920 --> 00:01:37,640 users to this database. 20 21 00:01:37,720 --> 00:01:40,340 But we won't do that. 21 22 00:01:40,370 --> 00:01:47,480 We'll leave those database options as they are except that we will change backup to zero days, so that we don't have 22 23 00:01:47,480 --> 00:01:52,400 any backups being done or automatic backups being done for us. We'll launch that DB instance. 23 24 00:01:56,060 --> 00:02:00,710 Again after a short amount of time it will go from creating to available and then we'll look at 24 25 00:02:00,710 --> 00:02:07,020 connecting into our DB instance using the Microsoft SQL Server management studio. 25 26 00:02:09,070 --> 00:02:15,310 Now after quite a bit of time you'll find that your SQL Server Express instance will be up and running 26 27 00:02:15,340 --> 00:02:16,040 and available. 27 28 00:02:16,040 --> 00:02:22,510 So then you need to go to the Microsoft Web site and download the SQL Server management studio 28 29 00:02:22,540 --> 00:02:26,710 and a link to that is in the lab notes. 29 30 00:02:26,820 --> 00:02:33,990 Now the quickest and easiest way to connect into your Microsoft SQL Server instance is to do it through the command 30 31 00:02:33,990 --> 00:02:34,750 line. 31 32 00:02:34,800 --> 00:02:39,080 And so I'm just going to copy from the lab notes. 32 33 00:02:39,090 --> 00:02:42,880 There is a command that we use to connect in through SQL command 33 34 00:02:52,650 --> 00:02:57,690 and the first thing we need to do is we need to replace where it says the RDS endpoint goes here 34 35 00:02:57,780 --> 00:03:00,740 and put our RDS endpoint from the RDS 35 36 00:03:00,760 --> 00:03:01,030 console. 36 37 00:03:10,440 --> 00:03:15,210 Again we need to take off that colon (:) and the port number 1433 off the end of that 37 38 00:03:15,420 --> 00:03:20,220 endpoint. Next we put in our username which will be admin 38 39 00:03:24,670 --> 00:03:25,810 and then our password 39 40 00:03:31,970 --> 00:03:32,570 and enter 40 41 00:03:36,790 --> 00:03:37,450 and there we have it. 41 42 00:03:37,450 --> 00:03:44,800 So we've successfully connected in through the command line to our SQL server and we can 42 43 00:03:44,890 --> 00:03:47,630 issue the SQL commands from here if we'd like. 43 44 00:03:50,050 --> 00:03:50,500 OK. 44 45 00:03:50,510 --> 00:03:56,210 Now the final thing that we're going to do is go into connecting to our audience instance this time 45 46 00:03:56,210 --> 00:03:59,810 using the SQL Server Management Studio. 46 47 00:03:59,810 --> 00:04:01,790 So what we do is we connect. 47 48 00:04:01,790 --> 00:04:07,070 We click on this connect icon here or we can go into file and then connect. 48 49 00:04:07,070 --> 00:04:13,430 Now the server type will be database engine and the server name will be the endpoint. 49 50 00:04:13,430 --> 00:04:20,230 So I will just jump into the RDS management console and copy that over. 50 51 00:04:20,630 --> 00:04:25,220 We need to make sure that we take off the 1433 and the colon (:) off the end of our 51 52 00:04:25,510 --> 00:04:27,680 endpoint. The authentication. 52 53 00:04:27,680 --> 00:04:32,690 It's not going to be Windows authentication and it's not going to be active directory authentication 53 54 00:04:32,720 --> 00:04:35,720 but we could set that up if we wanted to but we haven't. 54 55 00:04:35,720 --> 00:04:41,540 So the SQL Server database itself will be authenticating us with a username and password. 55 56 00:04:41,540 --> 00:04:44,630 We put in our admin username and password. 56 57 00:04:44,630 --> 00:04:48,450 Now and we click connect. 57 58 00:04:56,880 --> 00:05:03,420 OK and there we have successfully connected into our SQL Server database using the Management Studio 58 59 00:05:04,130 --> 00:05:06,090 and I'll see you in the next one.