Error logging into SQL Azure using manage link on Azure portal

Question

I have logged into Azure and navigated to Database link. I created a new database using "create' on the azure portal. Now i try to test connectivity. It fails. So i try to debug by clicking on "manage". Here i enter the database name user id and password. It fails, stating "Login is disabled or credentials are invalid" I am using windows azure in conjunction with Visual Studio express (trial edition). I have tried with checking the "allow other windows azure services.." box and also by providing the IP designated to the db server in firewall rules. In both cases i get the same error. When i created an ip rule i logged off and logged back in to ensure the rule was active. This effort is part of deploying the sample VS 2010 windows azure web application on azure. It works fine on the emulator, but fails when actually deployed, at the time for registering a user. I have changed the default connection string to point to SQL azure as described @ http://msdn.microsoft.com/library/hh369932.aspx#SQLAzure. Any pointers would be appreciated regards Sameer

Answer 1

Hello.

Did you try to re-create your SQL Azure Server? I have never had such an error, but i suppose that it has its roots in SQL Server login model. So:

1) You trying to use wrong password/login pair;

-or-

2) Your login is disabled. But when i tried a moment ago to disable my SQL Azure login with TSQL 

ALTER LOGIN training DISABLE

i received an error that i don't have a permissions. 

So i suppose that it's a bug. Can you send it to Customer Support?

Answer 2

I was indeed using the wrong userid/password pair. The password was my window live ID, while the userid was something else.

Thank you

Sameer