And welcome back to back Space Academy. In this lab. 1
We're going to again look at another RDS database engine. 2
This time it will be the Microsoft SQL server engine. We will launch an instance again and we will connect in 3
to that instance using the Microsoft SQL Server Management Studio. 4
Now back in the RDS dashboard again we launch a DB instance and we will make sure that we 5
have free tier eligible only selected because SQL server is available on the free tier if you choose 6
SQL Server Express Edition. 7
So that's what we'll do. 8
We'll select the SQL Server Express Edition. 9
And we'll leave it license included and we'll leave it db t2.micro, we won't worry about time zone and 10
we're going to put in an instance identifier 11
and I'll just use backspace-rds-ms-sql-server. 12
And again we put in a username and password. 13
And once we've got that in there we'll just click on the next step. 14
And I will leave create new security group because there's not one there already set up for us. 15
I will create one but all that is going to do is create a security group again with inbound rules for 16
access on port 1433. 17
We will ignore Microsoft SQL server windows authentication because what that does is if you've 18
got Microsoft active directory on your enterprise you can use your Microsoft active directory to authenticate 19
users to this database. 20
But we won't do that. 21
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
any backups being done or automatic backups being done for us. We'll launch that DB instance. 23
Again after a short amount of time it will go from creating to available and then we'll look at 24
connecting into our DB instance using the Microsoft SQL Server management studio. 25
Now after quite a bit of time you'll find that your SQL Server Express instance will be up and running 26
and available. 27
So then you need to go to the Microsoft Web site and download the SQL Server management studio 28
and a link to that is in the lab notes. 29
Now the quickest and easiest way to connect into your Microsoft SQL Server instance is to do it through the command 30
line. 31
And so I'm just going to copy from the lab notes. 32
There is a command that we use to connect in through SQL command 33
and the first thing we need to do is we need to replace where it says the RDS endpoint goes here 34
and put our RDS endpoint from the RDS 35
console. 36
Again we need to take off that colon (:) and the port number 1433 off the end of that 37
endpoint. Next we put in our username which will be admin 38
and then our password 39
and enter 40
and there we have it. 41
So we've successfully connected in through the command line to our SQL server and we can 42
issue the SQL commands from here if we'd like. 43
OK. 44
Now the final thing that we're going to do is go into connecting to our audience instance this time 45
using the SQL Server Management Studio. 46
So what we do is we connect. 47
We click on this connect icon here or we can go into file and then connect. 48
Now the server type will be database engine and the server name will be the endpoint. 49
So I will just jump into the RDS management console and copy that over. 50
We need to make sure that we take off the 1433 and the colon (:) off the end of our 51
endpoint. The authentication. 52
It's not going to be Windows authentication and it's not going to be active directory authentication 53
but we could set that up if we wanted to but we haven't. 54
So the SQL Server database itself will be authenticating us with a username and password. 55
We put in our admin username and password. 56
Now and we click connect. 57
OK and there we have successfully connected into our SQL Server database using the Management Studio 58
and I'll see you in the next one.