Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
Hello, Siberians.
00:01
Welcome to this demonstration on Azure 80 authentication for your sequel.
00:07
This demonstration is part of the eight Ma do off the other 500. Microsoft, as your security technologies costs
00:15
some quick information on the activities that will be completing in this demonstration will start by configuring on a jury 80 at mean for sequel server after that were hard on as your 80 user. As a database owner, I will conclude by connecting to as a sequel
00:33
us on Azure 80 User.
00:36
Let's get into this.
00:38
So in the first task off this demonstration are become figuring on as your A D had mean for Nigel Sequel seven
00:45
on Harris Official Representation Off. What are we, Dean?
00:50
I currently have an address Equal Sever that has a single as your sequel database. Within it.
00:58
I have to use us in as your 80 David and Hemming
01:03
in the first ask how be harden the user David as an azure 80 at mean for the sequel Seven So that David can manage the server and the data basis wouldn't hate. So here I am, in the azure portal. Now I have sickle service over here, so I Guidant Lee Consequence Service.
01:22
You can see my single sequel server over here, so if I go ahead and click on that
01:26
on on the left hand side, I have active directory, had men here for a guide and click on that option. So at the moment you said that this is not configured. The only thing that's configured by the fault is a local at mean when I created this sick or seven.
01:44
So the conflagration as you're 80 years there as an active directory at mean
01:48
our go ahead and click on set at me.
01:51
The good thing here is I have the option to select a the users or groups now in production. You probably be a good idea to select groups because then we can manage membership going forward directly in Azure 80.
02:06
For now, I'll just quiet on typing to user. David
02:10
and I have David at Super Clouds that X Y Z yes, are great and selects David,
02:15
and I'll go ahead and click on Select.
02:19
So once I have everything the way I wanted a quiet and click on safe
02:23
and now that has completed successfully that that asked, done now the significance of Thes East that the admit that I had it can authenticate to the sequel. Sever On also managed to seven on the data basis within it.
02:39
So in the next task, RB Harding on Azure 80 user as a database owner
02:46
on here vis a vis representation off. What are between how beheading the other 80 user Emmy as a database. Boehner for the single adjust Sicko database that we have in the seven Now. To do that, I'll use a window system that has sickle several management studio installed.
03:05
How connects to the sequel Sever
03:07
as the admin David that I just added in the previous task. Andi are running this sequel. Query. What Equipment Does It is going to heart the A jury 80 user Emmy as a database owner and as a database access add mean for my database
03:27
by another for David to be able to connect to the several to begin wheat.
03:31
Our first of all needs to ensure that the I P address off my Windows system is others to the allowed least off the sickle firewall in hasher. So that's the connection can be successful, so I'll be doing all these tasks in the next demonstration. So here I am, back in the azure portal.
03:52
Now I'm sitting on my sequel. Seven. So on the left hand side, if I go ahead and click on Far Wars and Virtual Networks
04:00
and when we get to the client I p address are quiet and create a new rule,
04:05
we tell just call
04:06
client True.
04:11
Now for the start, I p are put in the I p address off the system that David will be connecting from.
04:17
So if I grade and put the high P and I grabbed and click on Save
04:23
and I'll click OK to that.
04:26
So the next one that I'll do is I'll go to my Windows system
04:29
and our connects to this server.
04:32
To do that, I'll need the address of this ever. So if I goto overview
04:38
on if I copy this seven name
04:42
so I have my Windows system over here for great and bring up sick or seven Management studio
04:49
now for the seven name our quiet and paste, named like Copied Elia and for the user name are quiet and type in David
04:58
at Super Clouds.
05:00
But X y Z.
05:02
And if I go riding, taken, connect
05:05
and from there to enter the past. Words are great and enter the password.
05:13
So now I'm logged into my sequel. Sever
05:16
on. I can see my database over here,
05:19
so what I'll do is I'll right click on this database, and I'll click on new Query.
05:26
So the step that I want to do is I want to add an azure 80 user called M E.
05:31
As a user off this database are then assigned a database on a row to the user Emmy.
05:39
To do that, I'll be using this sequel, query language,
05:44
and that will create T either on the last lines were assigned the votes to the user.
05:49
So if I go ahead and click execute and that's
05:54
now I can see the message command completed successfully. If I quite and right click on users and I refresh that, I can see that the Emmy has not been created on. Also, the use has been assigned to the right rules.
06:08
So in the final task off this demonstration,
06:11
our connects to my azure Seiko database as Thea's your 80 user Emmy
06:17
on Harris. A visual representation off. What are we, Dean,
06:21
Are we switching the log in that I currently have on my Windows clients machine
06:27
to log in as the user Emmy and I'll be connecting to the azure sick or database.
06:33
So here I am, back on the Windows client system. I'm still logged in as David, but what I'll do is I'll quiet and close out of this and I'll click no knots to save the query.
06:45
If I glide on open six or seven managements to deal again,
06:49
I'll still be connecting to the same several. So the address tents
06:55
and I'll be using as your a D universal With MFP, however, House switched the user name, too.
07:02
I m e.
07:04
Also, Emmy does not have permission on the seven level.
07:09
So if I go, I'd and click on options.
07:12
How we specifying the exacts database that mes permissions to connects to If I go ahead and right click and I paste that, so that's my database name Day.
07:23
So if I go ahead and click on Connects, today's
07:27
I'm prompted to enter the password for EMI
07:32
and I could consign in,
07:35
and now I'm signed in with Me's as your A D credential into this database, so everything is looking good.
07:44
So here's assembly off the activities that were completed in this demonstration.
07:50
We started by configuring on as your 80 ad mean for azure, sick or seven.
07:57
Well, then added on Azure 80 User as a database owner using the sequel Query that we used.
08:03
And finally we connected to Adjust sequel as I Azure 80. Use it.
08:11
Thanks very much for watching on. I'll see you in the next lesson.

Up Next

AZ-500: Microsoft Azure Security Technologies

In the AZ-500 Microsoft Azure Security Technologies training, students will learn the skills that are needed to pass the AZ-500 certification exam. All exam topics are covered as well as exam preparation strategies and hands-on practice.

Instructed By

Instructor Profile Image
David Okeyode
Cloud Security Architect
Instructor