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?

Answer 1

• 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

Answer 2

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.