CODEWITHSUNDEEP
sql-serverazure
elgurinn
elgurinn

Reputation: 13

Create Hybrid connection (Azure), access sql database from another computer

I cannot set up a hybrid connection via Azure portal, always comes up not connected. I am trying to connect to a SQL Database but "through" another computer. Like so, "Website" <-> "Hybrid connection" <-> "Computer1[Hybrid connection manager] <- Computer2[sql server]"

Because I don't have access to computer2, but I can access Sql Server via computer1 and I have access to that computer. What I am trying to do is set up a hybrid connection to computer1 that connects to computer2[sql server]. All attempts have been unsuccessful. Can anyone help with this problem?

Hybrid connection setup:

ConnectionString: 

add name="HybridConnection" provider=System.Data.SqlClient;provider  
connection string=&quot;Server=computer1,1433;DataBase=databasename;  
user id=sa;password=sapassword;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /

Overview image

Upvotes: 1

Views: 2488

Answers (1)

Justin Patten
Justin Patten

Reputation: 1069

We followed the following guide and got it up and running:

https://azure.microsoft.com/en-us/documentation/articles/web-sites-hybrid-connection-connect-on-premises-sql-server/

The name of the computer you provide to the hybrid connection should be the name of the SQL Server you want to connect to. In your example, the hostname in the hybrid connection and server in the connection string should be "Computer2"

Upvotes: 1

Related Questions