Azure Login failed for user? System.Data.SqlClient.SqlException

Question

Created Azure Database and Azure Site. Used the connection string provided by the Azure Site and filled in the password. When i try access the database through the application an error is returned

Login failed for user 'stefan'. System.Data.SqlClient.SqlException: Login failed for user 'stefan' This session has been assigned a tracing ID of '6ee9a27b-4be7-494b-aadd-7b05a8a3bddb'. Provide this tracing ID to customer support when you need assistance.

if you visit http://clickpc.azurewebsites.net/ can see the error for your self.

I may believe that access is denied in sql IP configuration for the IP of the connecting node

I allowed connections from Azure to the database but seems like still access denied

Answer 1

This error indicates that your username/password is incorrect. If this was due to a Firewall issue, you would have gotten an error message stating something like this:

Firewall check failed. Cannot open server 'XXXXXXXXX' requested by the login. Client with IP address 'XXXXXXXXX' is not allowed to access the server. To enable access, use the SQL Azure Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect.

Typically, SQL Azure usernames are part username and part server name, like so: stefan@xxxxxxx

Please ensure that you've specified correct SQL Azure username and password