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, 2022 in Others by Edureka
• 13,690 points
876 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, 2022 by gaurav
• 23,260 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, 2022 in Others by Soham
• 9,710 points
1,080 views
0 votes
1 answer

"Server Tomcat v7.0 Server at localhost failed to start" without stack trace while it works in terminal

To resolve this issue, you have to ...READ MORE

answered Feb 23, 2022 in Others by Aditya
• 7,680 points
3,121 views
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, 2022 in Others by Kichu
• 19,050 points
765 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, 2022 in Others by nisha
• 2,210 points
4,341 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, 2022 in Others by nisha
• 2,210 points
716 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
3,591 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,460 points
579 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, 2022 in Others by gaurav
• 23,260 points
2,066 views
0 votes
1 answer
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