The blog entry here talks about how to use a non default SQL Server instance as the store for the developer storage fabric in the Windows Azure SDK. The good news is that the March CTP fixes this issue. In order to specify a different SQL Server instance simply issue the command dsint /sqlinstance:<your instance name> from the bin folder in the SDK.

Note that you cannot specify a server name, the instance is assumed to be on your local development machine.