Search code examples
sql-serverdatabaseazureconnection

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.

Solution

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