sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server: Login timeout expired

The full error can be seen in the screenshot below :

The issue is caused by something to do with the value that is returned by default in the configured Named pipes. Firstly,

– Open SQL Server Configuration Manager
– Branch out SQL Server Network Configuration
– Click on the Protocols for your instance.
– In the right-hand pane, right-click on Named pipes and then click properties.

– Change the value in the field Pipe Name to

\\.\pipe\sql\query

Click ok. Then restart the SQL Instance. You should now be able to connect to the instance.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alim Dogan

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.