Blog Post

Azure Database Support Blog
3 MIN READ

Lesson Learned #472:Why It's Important to Add the TCP Protocol When Connecting to Azure SQL Database

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Jan 11, 2024
In certain service requests, our customers encounter the following error while connecting to the database, similar like this one: "Connection failed: ('08001', '[08001] [Microsoft][ODBC Driver 17 for...
Published Jan 11, 2024
Version 1.0
m60freeman's avatar
m60freeman
Brass Contributor
Feb 19, 2024

Is there any value in changing the Connection Properties in SSMS from "<default>" to "TCP/IP" when connection to Azure SQL Databases, or does SSMS detect that TCP/IP is the only supported protocol and uses it without changing this value?