Login failed for user

Question

I have created a SQL Server instance in the Azure portal but I am unable to connect to this either through the "Manage URL" or by using SQL Server Management Studio 2014 (12.0.2000.8).

I get the following:

Connect to Server

Cannot connect to i2a126t4rv.database.windows.net.

Login failed for user '[username]'.
This session has been assigned a tracing ID of '117b374c-1d43-49c8-b087-febd3b7d39d4'.  Provide this tracing ID to customer support when you need assistance. (Microsoft SQL Server, Error: 18456)

My username is an email address and I'm using the password that I use to log into the Azure Management Portal.

I have tried the username@server combination for the username but I'm not even sure how to format this when my Azure username is an email address ... is it [e-mail]@server?  Or just email@server?  Neither work.

I don't see any way to create SQL Users so I assume I'm supposed to be using my Azure login for this after I create the SQL instance.

Any help would be appreciated, thanks.

Answer 1

Hi Patrick,

We are experiencing an interruption to our Network Infrastructure in North Central US, South Central US and West Europe. A subset of customers in the affected regions may experience errors while accessing Azure resources, such as Storage, SQL Database, Cache Services, Websites, Azure Preview portal, API Management.

See Dashboard for the status http://azure.microsoft.com/en-us/status/

If you don't belong to the above mentioned region : Before you can connect to your Azure SQL Database server for the first time, you must use the Azure Platform Management Portal to configure the Azure SQL Database firewall. You will need to create a server-level firewall setting that enables connection attempts from your computer or Azure to Azure SQL Database server. Further, if you want to control access at the database level in your Azure SQL Database server, you must create database-level firewall rules for the required databases. For more information, see Azure SQL Database Firewall, How to: Configure the SQL Database Firewall, and How to:
Configure the Database-Level Firewall Settings (Azure SQL Database).

  Because some tools implement tabular data stream (TDS) differently, you may need to append the Azure SQL Database server name to the login in the connection string using the <login>@<server> notation. In these cases, separate the login and Azure SQL Database server name with the @ symbol. For example, if your login was named login1 and the fully qualified name of your Azure SQL Database server is servername.database.windows.net, the username parameter of your connection string should be: login1@servername. This restriction places limitations on the text you can choose for the login name. For more information, see CREATE LOGIN (Azure SQL Database).

For further information , see Guidelines for Connecting to Azure SQL Database

Also see Understanding "login failed" (Error 18456) error messages in SQL Server 2005

Hope this helps.

Regards,

Shirisha Paderu

Answer 2

The IP address I am attempting to connect from is already listed in the authorized IP list in the Azure portal.

I can not connect to the Microsoft Azure SQL Database Management Portal (from the Azure web portal), it will not authorize me regardless of what username/password I try to sign on with.  That sign-in page is located here:

https://i2a126t4rv.database.windows.net/?langid=en-us

Since my Azure username is an email address (from a Microsoft account), is this a problem?  I noticed in your reply you it says "this restriction places limitations on the text you can choose for the login name".  However, I did not choose this login name, it was created for me from a Microsoft account.

Is the SQL Database password the same password as the owner of the Azure account (used to log into the Azure portal)?

Answer 3

Hi Patrick,

In Connect to Server, specify the fully-qualified server name as serverName.database.windows.net just like the way you did. ( I can see this from https://i2a126t4rv.database.windows.net/?langid=en-us ).

On Azure, the server name is an autogenerated string composed of alphanumeric characters.

->Select SQL Server Authentication.

-> In the Login box, enter the SQL Server administrator login that you specified in the portal when creating your server in the format login@yourServerName. ( you would have given a Login name other than your email address )

->In the Password box, enter the password that you specified in the portal when creating your server ( This is not necessarily a Portal login password  )

->Click Connect to establish the connection.

On Azure, each SQL Database logical server is an abstraction that defines a grouping of databases. The physical location of each database might be on any computer in the data center.

Connections will now succeed based on the server name, authentication type, and administrator credentials.

For further information, please refer Connect to SQL Database

Regards,

Shirisha Paderu

Answer 4

When creating the SQL Server on Azure, I was never prompted to create credentials.

However, I used the login listed under "ADMINISTRATOR LOGIN" listed on the Azure SQL page, and chose the link to "Reset Administrator Password". 

After this I was able to login to the server.   Thanks.

Answer 5

Hi Patrick,

Thanks for sharing the workaround. I am sure this helps others who has similar issues.

Regards,

Shirisha Paderu