Do you mean you host a database on a Windows Azure machine, and want to connect it from a local client? First please note it is recommended to use SQL Azure rather than manually hosting a database in Windows Azure. However, SQL Azure only supports SQL
Server. If you need other databases (such as MySQL), first make sure you’ve obtained the license. Then in most cases, it is recommended to host a service in Windows Azure that talks with the database, and connect to the service from your local client. If you
really want to take a 2-tire architecture, you need to configure input endpoints to open the port. This can be different for different database products. Refer to your database instruction book to see which port(s) you need to open.
I intent do connect to the AZure SQL database from a C# Application, and maybe Microsoft Office applications.
As Mentioned This was working a couple of months ago from my dev machine. Now The Windows Azure Connect 1.0.0952.2 client has a waring icon accross it. Running diagnostics I receive Policy Check error "There is no connectivity policy on this machine" also
a IPSec certificate check error 'No IPSec certificate was found. ..."
I'm guessing without the connectivity client correctly connecting neigther with myu C# or other tools like SQL MAnager. On my Management client I se my dev machine registered under active endpoints.
Guessing this is a simple switch somwhere deep in the interfaces.