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

Igorek · Accepted Answer · 2013-03-04 00:36:13Z

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

answered Mar 4, 2013 at 0:36

Igorek

15.9k3 gold badges60 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Evildommer5 Over a year ago

Server=tcp:fu12xyhuc2.database.windows.net,1433;Database=[ClickPCdb]; User ID=stefan@fu12xyhuc2;Password= {******};Trusted_Connection=False;Encrypt=True;Connection Timeout=30; is this the correct format for the connection string

richstep · Accepted Answer · 2013-12-18 17:41:10Z

Managing logins in the SQL Azure world are unfortunately difficult. For example, SQL Server Management Studio doesn't let you add new logins and users via the GUI. Things have to be done using T-SQL.

To start, when you first created the database using the Azure Portal, did you use Stefan as the login name? That is important because Stefan becomes takes on the dbo database role (admin). Otherwise, you need to create new users and assign permissions.

Second, in the Azure Portal, locate your database and click on manage. Try to login on via that webpage using Stefan. If that doesn't work then you have the wrong username or password. If it does work, open up Management Studio and connect to your SQL Azure db, using Stefan. Then use this Microsoft guide to troubleshoot: Managing Databases and Logins in Windows Azure SQL Database

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related