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

Question

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.

Answer 1

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.