Sample Header Ad - 728x90

Why changing the order of network protocols does not make any sense?

2 votes
1 answer
1031 views
All I want to do is to connect to SQL Server though Named Pipes **without** using an explicit way like *NP:ServerName* because mentioned *approach works*. **I want to connect through Named Pipes using just ServerName** and give a SQL Server a chance to choose the right network protocol. So I have **3** VMs: enter image description here What I did step by step: 1. In **Server Configurations** of **SQL Server A** I enabled all network protocols. enter image description here 2. I am also familiar with the Order column, however, changing it appears to have no affect. I swapped the order of **TCP/IP** and **Named Pipes**: enter image description here 3. I tried to connect from **SQL Server** B into **SQL Server A** using **Computer Name**(**WIN-VKHOKLJ3IJG**) and I hoped that it will use Named Pipes protocol but unfortunately it chose TCP/IP as a connection protocol: enter image description here Could someone explain why TCP/IP was chosen instead of Named Pipes? According the order, SQL Server should choose Named Pipes but it rather preferred to use TCP/IP.
Asked by Rauf Asadov (1313 rep)
Jan 3, 2020, 06:12 PM
Last activity: Mar 13, 2024, 03:16 PM