can't find definitive answer, or working. site says "to use on-premises sql server or sql server express database hybrid connection, tcp/ip needs enabled on static port. default instances on sql server use static port 1433, whereas named instances not."
my installation of named instance on static port (1555), outlined here:
i have hybrid connection configured in azure portal port 1555 , shows "instance connected".
in app's connection string, specifying instance name , port if app on-premise, work when run locally. (server\instance, 1555)
i opened appropriate firewall ports, when running app azure, i'm getting standard connection error: network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: tcp provider, error: 0 - no such host known.)
so named instance on non-standard port supported hybrid connections, , if so, connection string standard format of : server\instancename,port#
thanks
this old post, presumably not relevant more. in case else finds useful... yes can use named instance on non-standard port hybrid connections, i've got couple of connections set-up. reference, connection string needs in format of
driver={sql server};server=server_name.domain.com\instance,port;database=database_name;uid=username;pwd=password
i found didn't work (for me) unless qualified server name domain too
