CODEWITHSUNDEEP
sql-serverdatabaseazureconnection
BenHayward
BenHayward

Reputation: 81

Azure SQL Server Connection Error Despite Correct Credentials - Error Number:18456,State:1,Class:14

I have created a new SQL Database on Azure, and have copied the connection string directly from the Azure Portal.

On my .NET application, when I am trying to run 'Update-Database' command in Package Manager Console to commit the migration, I receive the following error:

Error Number:18456,State:1,Class:14 Login failed for user

'benhayward'.

Extra Information: - I have changed my database admin password. - I have confirmed that the log-in credentials are correct. - I am on the Azure free trial.

Any advice or assistance on this would be greatly appreciated.

Upvotes: 0

Views: 1430

Answers (2)

dekanidze
dekanidze

Reputation: 152

I had the same issue. The problem was that I had two entirelly different connection strings with the same name in different config files. The right one in app settings was being overwritten by another connection string in my user secrets. As soon as I deleted connection string from my secrets, everything went fine without any errors. Hope my solution will help the others

Upvotes: 0

BenHayward
BenHayward

Reputation: 81

Ok a slightly embarrassing solution, but the reason this wasn't working is because of the curly brackets surrounding the password, as LeonYue suggested.

Upvotes: 2

Related Questions