title: Can I use azure hybrid sql connection on a named instance?
body: <p>Can't find a definitive answer, or get it working.  This site says "To use an on-premises SQL Server or SQL Server Express database with a hybrid connection, <strong>TCP/IP needs to be enabled on a static port</strong>. Default instances on SQL Server use static port 1433, whereas named instances do not."  </p>
  
  <p><a href="http://azure.microsoft.com/en-us/documentation/articles/web-sites-hybrid-connection-connect-on-premises-sql-server/" rel="nofollow">http://azure.microsoft.com/en-us/documentation/articles/web-sites-hybrid-connection-connect-on-premises-sql-server/</a></p>
  
  <p>My installation of a named instance IS on a static port (1555), as outlined here:</p>
  
  <p><a href="http://blogs.msdn.com/b/arvindsh/archive/2012/09/08/how-to-assign-a-static-port-to-a-sql-server-named-instance-and-avoid-a-common-pitfall.aspx" rel="nofollow">http://blogs.msdn.com/b/arvindsh/archive/2012/09/08/how-to-assign-a-static-port-to-a-sql-server-named-instance-and-avoid-a-common-pitfall.aspx</a>  </p>
  
  <p>I have the hybrid connection configured in the azure portal with port 1555 and it shows as "Instance Connected".  </p>
  
  <p>In my app's connection string, I am specifying the instance name and port just as if the app was on-premise, which does work when run locally.  (server\instance, 1555)</p>
  
  <p>I opened all the appropriate firewall ports, but when running the app from azure, I'm getting the standard connection error: 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.)</p>
  
  <p>So is a named instance on a non-standard port supported for hybrid connections, and if so, is the connection string the standard format of : server\instanceName,port#</p>
  
  <p>Thanks</p>