SQL Server Azure "Login failed for User"

Question

I am using the following code to perform SQL commands to my azure DB. The I do two calls inside my ASP.NET MVC action method. One to delete from Table A, and the second call to delete from Table B.

  using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConnectionString))
        {
            using (System.Data.SqlClient.SqlCommand command = conn.CreateCommand())
            {
                conn.Open();
                command.CommandText = statement;
                command.ExecuteNonQuery();
            }
        }

For whatever reason when I make the second call to this code (I have it in a Helper service class, it bombs with the following Azure error.

Additional information: Login failed for user 'MyUser'.

Is there something I'm not doing correctly but not perhaps closing a connection or something that Azure is having issues with this?

What does your connection string look like (remember to blank out personal data)? I bet you are using Windows Authentication and your Sql server does not have a login for the user that the webserver is running as. — gunr2171
– gunr2171, Commented Jul 1, 2014 at 12:54
I just noticed something.. I am pulling the connection string from the Entity Framework Entities class. "MyEntity.Database.Connection.ConnectionString" the second time I call into it the password for the connection string is missing.. why is this? — aherrick
– aherrick, Commented Jul 1, 2014 at 13:01

Marco Antonio Quintal · Accepted Answer · 2014-07-01 15:00:43Z

5

You need allow your IP Address to access azure database. click in configure and add your IP.

answered Jul 1, 2014 at 15:00

Marco Antonio Quintal

5903 silver badges14 bronze badges

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

1 Comment

Halter Over a year ago

How does one allow firewall access for an App Service? I only get this error in production (no matter what my connection information is in my web config) but the app service doesn't have an IP.

aherrick · Accepted Answer · 2014-07-01 15:29:20Z

1

I just needed add to the connection string

Persist Security Info=False;

answered Jul 1, 2014 at 15:29

aherrick

20.2k34 gold badges118 silver badges197 bronze badges

Comments

Ibraheem Al-Saady · Accepted Answer · 2016-02-01 13:32:51Z

0

when you publish your project into azure from visual studio, there is a 'settings' tab on the left.

go to the settings. it will show you the connection string that you're using in the web.config.

what worked for me is I unchecked the check box that says 'Use this connection string at runtime (update destination web.config)' and everything went well for me.

answered Feb 1, 2016 at 13:32

Ibraheem Al-Saady

8743 gold badges14 silver badges30 bronze badges

Collectives™ on Stack Overflow

SQL Server Azure "Login failed for User"

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related