I try to deploy the Azure Tools for visual studio 2010, and then tried to debug a simple hello world application. Then i got the following error:
Windows Azure Tools: Failed to initialize the Development Storage service. Unable to start Development Storage. Failed to start Development Storage: the SQL Server instance ‘localhost\SQLExpress’ could not be found. Please configure the SQL Server instance for Development Storage using the ‘DSInit’ utility in the Windows Azure SDK.
I do not have SQLExpress installed, but the full version of sql Server 2008.
This message told me to use the "DSInit" utility for setting up some ports and the storage database.
The I executed this query, i’ve got this:
Failed to create database ‘DevelopmentStorageDb20093919’ : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)
One or more initialization actions failed. The development storage cannot be used without resolving these errors.
After checked the InstanceName of my sql server Which showed me that i don’t have any instance name:
It seems not to be possible(or at least not easy) to change the InstanceName for the sql server, so i did not.
But i now tried the DSInit tool with parameter "/sqlinstance:" and this worked.(No InstanceName set)