ELOGIN error while connecting to SQL Server RDS in AWS Elastic Beanstalk

0 votes
I have setup SQL Server RDS using AWS Elastic Beanstalk. I am running a nodejs-express application to fetch details from the RDS. When I run app locally I am able to connect to RDS but when I deploy my application in Elastic Beanstalk I get ELOGIN error - Login failed for user ***. I have setup environment variables in the Software Configuration and stored them locally to connect to the RDS.
Mar 3 in Others by Edureka
• 9,320 points
87 views

1 answer to this question.

0 votes
If you try to log into SQL Server using SQL Server Management Studio (SSMS) with a SQL Server account on a Windows 2012 R2 EC2 instance or in Amazon RDS, you can get an error. When SSMS is launched as a domain user, the error "Login failed for user" can occur, even if correct credentials are provided. This is a known problem, and AWS is working to fix it.

You can work around the problem by logging into SQL Server using Windows Authentication rather than SQL Authentication. Alternatively, instead of launching SSMS as a Simple AD domain user, run it as a local user.
answered Mar 3 by Edureka
• 8,820 points

Related Questions In Others

0 votes
1 answer

How to delete duplicate rows in SQL Server?

To answer your query, note that CTEs ...READ MORE

answered Feb 10 in Others by Soham
• 8,730 points
62 views
0 votes
1 answer
0 votes
0 answers

Upgrade instance type from r4 to r5 in AWS RDS

I am currently using an r4 instance. Model ...READ MORE

Apr 10 in Others by Kichu
• 16,850 points
19 views
0 votes
0 answers

How to open a new tab or a new window while writing an exam in AI - Onlime Remote Proctored

How to open a new tab or ...READ MORE

Jul 20, 2020 in Others by vimalkamal
• 120 points
2,216 views
0 votes
1 answer

How to create subnet inside a VPC in AWS using Terraform?

Hi@akhtar, You need to use aws_subnet resource inside your ...READ MORE

answered Jul 21, 2020 in Others by MD
• 95,340 points
149 views
0 votes
1 answer

ERROR: You need elevated Administrator privileges in order to run this script.

Hi@akhtar, I guess you are trying to run ...READ MORE

answered Sep 8, 2020 in Others by MD
• 95,340 points
442 views
0 votes
1 answer

Error: IllegalArgumentException: Unable to locate adb in Android Studio v2.3

when you try to move an Android project ...READ MORE

answered Dec 16, 2020 in Others by Gitika
• 65,850 points
1,650 views
0 votes
1 answer

How to import excel file in Oracle SQL live

Hello, there are a few steps You'll ...READ MORE

answered Feb 18 in Others by Edureka
• 8,820 points
121 views
0 votes
1 answer
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