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
• 13,640 points
121 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 gaurav
• 13,560 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
86 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
• 19,040 points
55 views
0 votes
1 answer

Convert Rows to columns using 'Pivot' in SQL Server

If you are using SQL Server 2005+, ...READ MORE

answered Jun 20 in Others by nisha
• 2,160 points
12 views
0 votes
1 answer

How to delete duplicate rows in SQL Server?

WITH CTE AS ( SELECT *,ROW_NUMBER() OVER (PARTITION BY ...READ MORE

answered Jun 21 in Others by nisha
• 2,160 points
17 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,278 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,360 points
163 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 gaurav
• 13,560 points
201 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