If you're referring to the administrative password for a specific Windows Azure SQL Database server , you can do this from the new portal. Select the Database choice on the left, then select Servers:

enter image description here

Then, after selecting the server of choice, you'll see the option on the right for resetting admin password:

enter image description here