Azure SQL Database connection exception (System.Data.SqlClient.SqlException is thrown )

Question

I'm working on an ASP.NET MVC project and I started from scratch. I just want to use the SQL database hosted on Azure in my project.

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'myname'. This session has been assigned a tracing ID of '00dbcf81-35eb-4d92-b022-da1bca001e5f'. Provide this tracing ID to customer support when you need assistance.

What I did:

I set up the web.config connection string using the one Azure Management Portal provided. I copied and pasted directly.
I set up the firewall on my computer - both outbound and inbound with port 1433 allowed
In azure management portal, I put my IP address in the list.
I can use my password and username to connect the Azure db using SQL server management studio successfully. Everything works fine.
I also set "Allow other Windows Azure services to access this server"

Here is my connection string:

<add name="DefaultConnection" connectionString="Server=tcp:myserver.database.windows.net;Database=aspnet-WebApplication1-20140927090028;User ID=myid;Password={mypsw};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.SqlClient" />

I checked all the posts here and didn't find much information useful.

Any help is greatly appreciated.

Thanks.

Could you post the connection string/code you're trying to connect with? Other than that, I'm afraid the only other advice I can offer is to double check the username and password. — Kakira
– Kakira, Commented Oct 6, 2014 at 4:29

catlovespurple · Accepted Answer · 2014-10-06 16:05:21Z

1

FINALLY. Solved.

PAY ATTENTION to the connection string Azure portal provides. You have to remove the brackets for the password. THAT'S IT!

answered Oct 6, 2014 at 16:05

catlovespurple

7021 gold badge8 silver badges21 bronze badges

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

Comments

Louis Michael · Accepted Answer · 2014-10-06 04:46:45Z

0

Seems there is something wrong with the credentials given as stated below Double check your Username and Password carefully.

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'myname'. This session has been assigned a tracing ID of '00dbcf81-35eb-4d92-b022-da1bca001e5f'. Provide this tracing ID to customer support when you need assistance.

answered Oct 6, 2014 at 4:46

Louis Michael

3981 silver badge12 bronze badges

1 Comment

catlovespurple Over a year ago

Thanks Louis. I double checked and I'm pretty sure psw and name are correct.

Collectives™ on Stack Overflow

Azure SQL Database connection exception (System.Data.SqlClient.SqlException is thrown )

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related