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, 2022 in Others by Edureka
• 13,690 points
1,662 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.

If you need to know more about MSSQL, it is recommended to go for the SQL Course today.

answered Mar 25, 2022 by Edureka
• 13,690 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, 2022 in Others by Soham
• 9,710 points
32,750 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, 2022 in Others by Edureka
• 13,690 points
587 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, 2022 in Others by gaurav
• 23,260 points

edited Jun 20, 2023 by Khan Sarfaraz 11,826 views
0 votes
1 answer

AWS RDS Role type: Master vs Instance

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

answered Mar 15, 2022 in Others by gaurav
• 23,260 points
685 views
0 votes
0 answers

AWS: can't connect to RDS database from my machine

When I tried to debug the code ...READ MORE

Apr 9, 2022 in Others by Kichu
• 19,040 points
782 views
0 votes
1 answer

Amazon RDS Instance Password?

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

answered Mar 3, 2022 in Others by gaurav
• 23,260 points
1,008 views
0 votes
1 answer

AWS RDS last connection date

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

answered Mar 15, 2022 in Others by gaurav
• 23,260 points
1,913 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, 2022 in Others by Edureka
• 13,690 points
1,182 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, 2022 in Others by Edureka
• 13,690 points
603 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP