Rajeev Pentyala – Microsoft Power Platform

In my SQL server I have a Login account ‘sa’ with ‘SQL Server Authentication’.

Login Account

Even though all the properties provided properly, I was unable to login with below login exception.

Login Failed For User

Troubleshooting steps:

SQL Server Authentication:

• Open ‘SQL Server’ properties window

SQL Server Properties

• Make sure SQL server’s ‘Server Authentication’ set to ‘SQL and Windows Authentication mode’

Server authentication

• Restart the SQL Services if you change.

Enable Login for ‘sa’ account:

• ‘Login’ feature has to be enabled for ‘sa’ account
• Open the ‘sa’ account by double click.
• In the ‘Staus’ tab make sure ‘Login’ is enabled and set ‘Permission to connect to database engine’ to ‘Grant’

Enable Login for Account

🙂