Geek Answers Handbook

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

Sqlcmd: error: Microsoft SQL Server 10.0 native client: unable to complete the full login process due to a delay in opening a connection to the server.

when I execute the first query in SQL Server 2008 r2, there were no problems, but when I executed the second query, the problem was shown above. My database is connected to the local PC and there is no remote connection, can someone help me detect the above protection

+8
source share
2 answers
  • Raise timeouts (connection and command)
  • Give sql server more memory
  • stop any heavy background processes.
  • play with netlib, disable shared memory and enable tcpip + netbios and vice versa
+5
source

Disabling shared memory worked for me like a charm.

Instructions:

  1. Launch SQL Server Configuration Manager.
  2. In SQL Server Configuration Manager, expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
  3. Right-click "Shared Memory" and select "Disable."
  4. Click SQL Server Services, right-click SQL Server (MSSQLSERVER) and select Restart.
0
source

More articles:


All Articles