When you need to connect to a SQL Server that has a Named Instance, and your application is not capable, don’t lose hope.
You can find the PORT for the named instance in the Windows Registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[Instance Name]\MSSQLServer\SuperSocketNetLib\Tcp\REG_SZ TcpPort=I hope this helps Others…..