Can't connect

Question

This used to work, then recently stopped. My Dev m,achine won't connect to my Azure database server over Windows Azure Connect.

Have not tried connecting for a couple of months, any recent changes on the Azure side?

My machine is listed in the activated endpoints, but still my local connect client refuses:

'This endpoint is not configured correctly'

Diagnostics say:

'There is no connectivity policy on this machine', and 'No IPsec certificate was found. ...'

Duncan

Answer 1

windows-azure-connect-connect-to-local-sql-server-database-from-azure-using-virtual-network

check my article.Do let me know its help ful

Answer 2

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.

Answer 3

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.

Duncan

Answer 4

Duncan, are you still having this issue?

Regards,
SethM
Microsoft

Answer 5

Yes SethM, I'm frustrated. I've added screenshots of the diag and portal below