You may get an error when Visual Studio or the Windows Azure SDK tries to create a storage database by default.
Therefore the fix is to open the DSInit.exe via the visual studio command promot using this script:
DSInti /sqlInstance:YourInstanceName.
The DSInit location usually in C:\Program Files\Windows Azure SDK\v1.0\bin\devstore.