Reputation: 11

Connecting Apps with Windows Azure Connect - Problem connecting

I'm following the Connecting Apps with Windows Azure Connect lab in the Azure Training Kit.

I've followed the instructions to set up the Groups and Roles, and the Activated EndPoints.
I've updated the SQL Express settings and restarted the service
I've installed the local endpoint, which gives the following text.
I've added a new Windows Firewall rule

This endpoint is configured to connect, and can connect to other resources in Windows Azure Connect.

I still get this error displayed in the browser.

Sorry, an error occurred while processing your request.

Message: The underlying provider failed on Open. Inner Message: 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: TCP Provider, error: 0 - No such host is known.)

Any ideas on why this might be or suggestions on finding out where it is failing?

Thanks.

Update

I found this link "Windows Azure Connect and Symantec Endpoint Protection" describing a similar problem; as the title suggests Symantec EndPoint Protection could be the problem.

Although in this case, removing Symantec did not fix the problem

Update 2
some messages from Event Viewer - this set is repeated every 2 mins, they dont appear connected to a web page request.

at 9:29:40 [Information]

The user SYSTEM has successfully established a link to the Remote Access Server using the following device: Server address/Phone Number = sydrelay4.windows.azure-test.net

also at 9:29:40 [Information]

The link to the Remote Access Server has been established by user SYSTEM.

at 9:29:41 [Error]

The user SYSTEM dialed a connection named Windows Azure Connect Relay2 1 which has failed. The error code returned on failure is 798.

at 9:29:45 [Information]

The user SYSTEM dialed a connection named Windows Azure Connect Relay2 1 which has terminated. The reason code returned on termination is 631

Upvotes: 1

Answers (3)

user810731

Reputation:

I had the exact same issue, Symantec et al. I was able to resolve it by adding the .cer certs I used in the Azure portal for the Hosted Services -> Management Certificates to my personal certificates collection via MMC and then rebooting my computer.

Hope that helps.

Upvotes: 1