SQL Azure: Invalid object name 'sys.configurations'

This is a rather dumb error. I am able to connect to SQL Azure from SQL Server Management Studio in my work computer but not from my home computer. But if I connect to it from a query window in my home computer it works!


I'm guessing it has to do with the SSMS version or with Object Explorer. It's better not to waste time with these errors because you'll probably end up uninstalling the software (and spend a bunch of time on that) to make it work.


This thread helped me http://social.msdn.microsoft.com/Forums/en-US/windowsazuredata/thread/9e5b6854-9e5a-4e7d-b771-313aa5683b72/.

Failed to start Storage Emulator: the SQL Server instance ‘localhost\SQLExpress’ could not be found

I wonder why when you follow a tutorial there are always errors in the process which are not mentioned in the tutorial. It happened to me when following a Windows Azure "Hello, World" tutorial. This error is simple to solve though, just do this:

1) Open a command window and go to C:\Program Files\Windows Azure Emulator\emulator\devstore

2) Execute dsinit /server:localhost

In my case I don't use SQL Express, so I had to run the command above to point the Emulator to SQL Server.

Azure Data Market

This is an interesting concept, can't wait to test/consume some of the services on https://datamarket.azure.com/!!