SQLCMD Unable to complete login process due to delay in opening server connection

Question

Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Unable to complete login process due to delay in opening server connection.

When I execute the first query in SQL Server 2008 R2 there was no problems but when I executed the second query there is problem shown above. My database is connected to the local PC and there is no remote connection.

Can anyone help me for finding the above remedy?

score 4 · Accepted Answer · edited Mar 07 '19 at 19:45

4

Raise your timeouts (connection and command)
Give the sql server more memory
Stop any heavy background processes
Play with netlibs, turn off shared memory and tcpip+netbios turn on and vice versa

edited Mar 07 '19 at 19:45

David Rogers

2,601
4
39
84

answered Jan 24 '12 at 09:59

Oleg Dok

21,109
4
45
54

Sir i am connecting the sql server locally – Philip Jan 24 '12 at 10:11
@user1155613 so why? You also can connect to local sql server by tcpip, but by default it goes thru shared memory – Oleg Dok Jan 24 '12 at 10:18
1

Increasing the connection timeout worked for me thanks! – tom redfern Dec 24 '15 at 09:51
Go to the connection properties, then increased the connection timeout to 1000s worked for me – Loc Huynh Jan 30 '20 at 20:01

score 3 · Answer 2 · answered Dec 12 '18 at 12:02

3

Disabling the shared memory worked like a charm for me.

Instructions:

Start SQL Server Configuration Manager.
In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for MSSQLSERVER.
Right-click Shared Memory, and then click Disable.
Click SQL Server Services, right-click SQL Server (MSSQLSERVER), and then click restart.

answered Dec 12 '18 at 12:02

Kondar

31
2

Thanks for the suggestion, but it did not help in my case. – CowboyBebop Dec 16 '22 at 19:08

score 3 · Answer 3 · answered Jan 23 '20 at 23:29

My office switched to a MultiSubnetFailover (load-balanced) system for our SQL set-up. Our connection manager previously had been set to OLEDB, and as it turns out OLEDB cannot accommodate MultiSubnetFailover=True; that's why we were getting the above error message.

As a result, we switched to an ODBC connection manager instead, and that worked.

SQLCMD Unable to complete login process due to delay in opening server connection

3 Answers3

Linked