You get the more generic error message 18456 = "Login faild"
Often cause are wrong credentials. See
See https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error?view=sql-server-ver15
Can't connect to my Azure db from SSMS - login failed for user
OrenA
21
Reputation points
I get an error when trying to connect from SSMS to my SQL DB.
I've made sure the username and password are correct (I've taken the username and password from my app which worked before I deployed the last version).
Here are my SSMS settings:
It worked previously, and just now started to not work.
What could it be?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
Answer accepted by question author
-
Olaf Helper 47,586 Reputation points2022-03-30T11:49:04.713+00:00