First of all, my problem was I was using the old Azure portal. Now when I went to server and selected reset password, changed the password, updated the password I was able to login to that database and server in visual studio. Now, because the database server was being used by a running application once that happened the application could not access the database. Doing a search for connection strings in the source code I found the original password, reset it back in Azure and everything now is good to go.
Can someone recommend from your own experience a best cloud service out there in the market now? With the reasons why? Mostly microsoft technologies we would like to host in the cloud service. Suggestions welcome but by your own experience as I can google and get some answers but I need to hear it from someone who is already using it for long time. Thank you in advance.