WEBVTT

00:00:00.000 --> 00:00:03.332 align:middle line:90%


00:00:03.332 --> 00:00:04.760 align:middle line:90%
[ELECTRONIC NOISES]

00:00:04.760 --> 00:00:10.010 align:middle line:90%


00:00:10.010 --> 00:00:15.440 align:middle line:84%
Now that we've looked at how
to enumerate MSSQL with Nmap,

00:00:15.440 --> 00:00:18.538 align:middle line:84%
let's dig in and see how
we do it with Metasploit.

00:00:18.538 --> 00:00:21.290 align:middle line:90%


00:00:21.290 --> 00:00:22.325 align:middle line:90%
We have our IP address.

00:00:22.325 --> 00:00:31.135 align:middle line:90%


00:00:31.135 --> 00:00:37.470 align:middle line:84%
We do a simple Nmap scan,
and we get 1433 along

00:00:37.470 --> 00:00:42.900 align:middle line:84%
with a lot of other services
running, but focusing on MSSQL

00:00:42.900 --> 00:00:43.410 align:middle line:90%
right now.

00:00:43.410 --> 00:00:51.090 align:middle line:90%


00:00:51.090 --> 00:00:55.260 align:middle line:90%
We can run that same skin.

00:00:55.260 --> 00:01:02.670 align:middle line:84%
Looking at 1433, we'll do
service as well as a script

00:01:02.670 --> 00:01:05.820 align:middle line:90%
for MSSQL info.

00:01:05.820 --> 00:01:10.750 align:middle line:90%


00:01:10.750 --> 00:01:12.715 align:middle line:90%
It's a script we've run before.

00:01:12.715 --> 00:01:18.188 align:middle line:90%


00:01:18.188 --> 00:01:19.730 align:middle line:84%
And our service
enumeration came back

00:01:19.730 --> 00:01:24.260 align:middle line:90%
with Microsoft SQL Server 2019.

00:01:24.260 --> 00:01:28.580 align:middle line:84%
We have the same
information from our script.

00:01:28.580 --> 00:01:32.510 align:middle line:90%
That is good to double check.

00:01:32.510 --> 00:01:33.695 align:middle line:90%
We load up msfconsole.

00:01:33.695 --> 00:01:41.500 align:middle line:90%


00:01:41.500 --> 00:01:46.390 align:middle line:84%
We did a brute force
using Nmap last time.

00:01:46.390 --> 00:01:49.600 align:middle line:84%
This time, we'll use Metasploit
to brute force our way

00:01:49.600 --> 00:01:53.605 align:middle line:90%
into user log on and password.

00:01:53.605 --> 00:02:02.280 align:middle line:90%


00:02:02.280 --> 00:02:11.980 align:middle line:84%
It is an auxiliary
scanner for mssql_login.

00:02:11.980 --> 00:02:23.005 align:middle line:90%


00:02:23.005 --> 00:02:23.770 align:middle line:90%
We'll set rhosts.

00:02:23.770 --> 00:02:26.590 align:middle line:90%


00:02:26.590 --> 00:02:29.170 align:middle line:90%
And let's setg rhosts.

00:02:29.170 --> 00:02:32.990 align:middle line:90%


00:02:32.990 --> 00:02:35.690 align:middle line:84%
That way, it stays
persistent throughout all

00:02:35.690 --> 00:02:37.325 align:middle line:90%
of the tools we use.

00:02:37.325 --> 00:02:40.440 align:middle line:90%


00:02:40.440 --> 00:02:47.790 align:middle line:84%
We'll set user_file
to me this wordlist

00:02:47.790 --> 00:02:54.940 align:middle line:90%
from the Desktop, common_users.

00:02:54.940 --> 00:03:07.190 align:middle line:84%
I'll set the pass_file to be
the 100 most common passwords.

00:03:07.190 --> 00:03:10.070 align:middle line:90%


00:03:10.070 --> 00:03:14.100 align:middle line:84%
These wordlists
exist for a reason.

00:03:14.100 --> 00:03:16.975 align:middle line:84%
They are the most
common passwords.

00:03:16.975 --> 00:03:19.760 align:middle line:90%
I'll set verbose to false.

00:03:19.760 --> 00:03:21.800 align:middle line:90%
I'll double check options.

00:03:21.800 --> 00:03:24.530 align:middle line:84%
Everything is filled
in that's required,

00:03:24.530 --> 00:03:25.655 align:middle line:90%
and we can run that module.

00:03:25.655 --> 00:03:28.220 align:middle line:90%


00:03:28.220 --> 00:03:32.270 align:middle line:84%
We come up with sa and no
password, which is useful.

00:03:32.270 --> 00:03:49.650 align:middle line:90%


00:03:49.650 --> 00:03:51.520 align:middle line:90%
And that was quite useful.

00:03:51.520 --> 00:03:56.700 align:middle line:84%
The next one, we came
up with database admin

00:03:56.700 --> 00:03:59.985 align:middle line:84%
as anamaria and
auditor as nikita.

00:03:59.985 --> 00:04:02.610 align:middle line:84%
We'll write all those down, and
we can come back to them later.

00:04:02.610 --> 00:04:06.250 align:middle line:90%


00:04:06.250 --> 00:04:13.080 align:middle line:84%
The next scanner we're going
to look at is going to be enum.

00:04:13.080 --> 00:04:18.390 align:middle line:84%
We've already set our
rhosts because we set it

00:04:18.390 --> 00:04:21.959 align:middle line:84%
as a global variable for this
whole Metasploit session.

00:04:21.959 --> 00:04:22.950 align:middle line:90%
So you can just run.

00:04:22.950 --> 00:04:27.180 align:middle line:90%


00:04:27.180 --> 00:04:29.700 align:middle line:90%
It'll try those log-ins.

00:04:29.700 --> 00:04:31.120 align:middle line:90%
We're still running the log-in.

00:04:31.120 --> 00:04:43.860 align:middle line:90%


00:04:43.860 --> 00:04:45.480 align:middle line:90%
It did not load the module.

00:04:45.480 --> 00:04:50.653 align:middle line:90%


00:04:50.653 --> 00:04:51.570 align:middle line:90%
Let's try that again--

00:04:51.570 --> 00:04:58.190 align:middle line:90%


00:04:58.190 --> 00:05:05.200 align:middle line:84%
mssql, ping, schemadump,
login, hashdump.

00:05:05.200 --> 00:05:19.990 align:middle line:90%


00:05:19.990 --> 00:05:27.790 align:middle line:84%
Ah, auxiliary admin
mssql_enum and let's run that.

00:05:27.790 --> 00:05:31.950 align:middle line:90%


00:05:31.950 --> 00:05:34.980 align:middle line:84%
And it came back with
a lot of information.

00:05:34.980 --> 00:05:41.820 align:middle line:84%
And we could dig
through here, see

00:05:41.820 --> 00:05:44.410 align:middle line:90%
what audits have been set up.

00:05:44.410 --> 00:05:49.290 align:middle line:84%
Some of our database information
that we found last time

00:05:49.290 --> 00:05:52.320 align:middle line:84%
using some Nmap scripts,
Metasploit came up with them

00:05:52.320 --> 00:05:53.740 align:middle line:90%
with this.

00:05:53.740 --> 00:05:59.910 align:middle line:90%
So we'll admin enum script--

00:05:59.910 --> 00:06:00.840 align:middle line:90%
module, rather.

00:06:00.840 --> 00:06:09.150 align:middle line:90%


00:06:09.150 --> 00:06:17.940 align:middle line:84%
If we were to continue with
the auxiliary admin tools,

00:06:17.940 --> 00:06:22.280 align:middle line:84%
there is enum and
then sql_logins.

00:06:22.280 --> 00:06:28.700 align:middle line:90%


00:06:28.700 --> 00:06:31.720 align:middle line:90%
We can run that.

00:06:31.720 --> 00:06:33.295 align:middle line:90%
We see that sa is a sysadmin.

00:06:33.295 --> 00:06:39.930 align:middle line:90%


00:06:39.930 --> 00:06:42.650 align:middle line:90%
That's useful.

00:06:42.650 --> 00:06:46.403 align:middle line:84%
Some more log-ins, we'll
write all those down.

00:06:46.403 --> 00:06:47.945 align:middle line:84%
We can come back
and use those later.

00:06:47.945 --> 00:06:51.010 align:middle line:90%


00:06:51.010 --> 00:06:53.220 align:middle line:84%
The last thing we
would want to check

00:06:53.220 --> 00:06:55.080 align:middle line:90%
is if we can run commands.

00:06:55.080 --> 00:06:57.820 align:middle line:90%


00:06:57.820 --> 00:07:03.090 align:middle line:84%
So it's going to be
another auxiliary admin.

00:07:03.090 --> 00:07:08.220 align:middle line:84%
And this one instead of
enum is exec for execute.

00:07:08.220 --> 00:07:12.870 align:middle line:84%
And we'll set the
command to be whoami.

00:07:12.870 --> 00:07:14.820 align:middle line:90%
Let's look at those options.

00:07:14.820 --> 00:07:17.630 align:middle line:90%
It'll connect, ask it.

00:07:17.630 --> 00:07:24.200 align:middle line:84%
If we can execute whoami,
let's see what it looks like.

00:07:24.200 --> 00:07:29.690 align:middle line:84%
And it came back as net
service/mssql/$sqlexpress,

00:07:29.690 --> 00:07:36.530 align:middle line:84%
which is what we would
expect the SQL service to be

00:07:36.530 --> 00:07:39.140 align:middle line:90%
identified as.

00:07:39.140 --> 00:07:44.840 align:middle line:84%
Let's enumerate some
domain accounts.

00:07:44.840 --> 00:07:51.570 align:middle line:90%


00:07:51.570 --> 00:07:53.460 align:middle line:84%
And to switch it
up, use exploit.

00:07:53.460 --> 00:07:54.840 align:middle line:90%
You can use exploit or run.

00:07:54.840 --> 00:07:56.010 align:middle line:90%
They both do the same thing.

00:07:56.010 --> 00:07:59.992 align:middle line:90%


00:07:59.992 --> 00:08:01.575 align:middle line:84%
And it's pulling
some domain accounts.

00:08:01.575 --> 00:08:06.300 align:middle line:90%


00:08:06.300 --> 00:08:07.715 align:middle line:90%
And it should be quite a list.

00:08:07.715 --> 00:08:11.620 align:middle line:90%


00:08:11.620 --> 00:08:13.000 align:middle line:90%
We got alice and bob.

00:08:13.000 --> 00:08:25.210 align:middle line:90%


00:08:25.210 --> 00:08:28.840 align:middle line:84%
You might recognize them from
discussions of encryption.

00:08:28.840 --> 00:08:37.059 align:middle line:90%


00:08:37.059 --> 00:08:39.059 align:middle line:84%
Again, with enumeration
everything that we find,

00:08:39.059 --> 00:08:40.380 align:middle line:90%
we're going to write down.

00:08:40.380 --> 00:08:43.350 align:middle line:84%
And we can determine
whether it's useful later.

00:08:43.350 --> 00:08:45.540 align:middle line:84%
But during enumeration,
it's all about

00:08:45.540 --> 00:08:50.070 align:middle line:84%
gathering, gather, gather,
gather as much as you can.

00:08:50.070 --> 00:08:54.810 align:middle line:90%


00:08:54.810 --> 00:08:57.680 align:middle line:90%
And that completed.

00:08:57.680 --> 00:09:01.550 align:middle line:84%
With that, that's the end
of our SQL enumeration.

00:09:01.550 --> 00:09:06.900 align:middle line:84%
And hopefully, you got
something to take with you

00:09:06.900 --> 00:09:10.160 align:middle line:84%
for all of your
enumerations here on out.

00:09:10.160 --> 00:09:11.000 align:middle line:90%