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:
What I did step by step:
1. In **Server Configurations** of **SQL Server A** I enabled all network protocols.
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**:
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:
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
Last activity: Mar 13, 2024, 03:16 PM