AWS RDS MSSQL logs so many failed login attempts

0 votes

Am pretty new to AWS. I have created RDS with MSSQL express edition and restored few databases into the server with public accessibility as YES and port 1433 and inbound rule allows everyone(0.0.0.0/0) .. after sometime I have observed some fishy login attempts from from different IP addresses. in db logs in monitoring section Is that mean someone trying to get access to my database??

2021-07-01 13:36:27.99 Logon       Login failed for user 'sa'. Reason: Could not find a login 
matching the name provided. [CLIENT: 103.41.65.227]

Is this expected, can someone throw some light on it.

Mar 14 in Others by Edureka
• 9,320 points
84 views

1 answer to this question.

0 votes

Observing log files
When you look at a log in the Amazon RDS console, you may see the contents as they are right now. When you watch a log on the console, it becomes dynamic, allowing you to see updates in real time.

Only the most recent log is available for viewing. As an example, let's say you have the following logs:

image

Log files are archived.
The Amazon RDS console displays logs from the previous week to the present day. You can download and archive logs to save them for future reference. Loading logs into an Amazon S3 bucket is one technique to archive them.

Error and agent logs are available for viewing.
Using the Amazon RDS stored procedure rds read error log and the following parameters, you can examine Microsoft SQL Server error and agent logs.

The version of the log to obtain is specified by @index. The current error log is retrieved by default, which is 0. Choose 1 for the preceding log, 2 for the one before that, and so on.

The type of log to obtain is specified by the @type parameter. To get an error log, use the 1 parameter. To get an agent log, use the 2 parameter.

answered Mar 25 by Edureka
• 9,320 points

Related Questions In Others

0 votes
1 answer

manifest merger failed with multiple errors, see logs

The initial process would be to open ...READ MORE

answered Feb 8 in Others by Soham
• 8,730 points
5,146 views
0 votes
0 answers

Why can't I connect to AWS RDS?

0 I'm trying to connect to my new ...READ MORE

Mar 1 in Others by Edureka
• 9,320 points
70 views
0 votes
1 answer

How to get password of the Amazon aws rds user?

Follow these procedures to update the master ...READ MORE

answered Mar 9 in Others by Edureka
• 8,820 points
95 views
0 votes
1 answer

AWS RDS Role type: Master vs Instance

AWS Identity and Access Management (IAM) is ...READ MORE

answered Mar 15 in Others by Edureka
• 8,820 points
47 views
0 votes
0 answers
0 votes
1 answer

Amazon RDS Instance Password?

If you're getting issues when using the ...READ MORE

answered Mar 3 in Others by Edureka
• 8,820 points
40 views
0 votes
1 answer

AWS RDS last connection date

To see the last 24 hours' worth ...READ MORE

answered Mar 15 in Others by Edureka
• 8,820 points
69 views
0 votes
1 answer

Refresh powerbi online with SQL data base (RDS AWS)

It must connect to the database successfully ...READ MORE

answered Mar 25 in Others by Edureka
• 9,320 points
24 views
0 votes
1 answer

Amazon RDS - Online only when needed?

Here's a script that will stop/start/reboot an ...READ MORE

answered Mar 25 in Others by Edureka
• 9,320 points
20 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP