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

• speja01

  SSC Eights!

  Points: 984

  More actions

  December 2, 2009 at 7:51 am

  #73971

  Hi Everyone,

  Since moving to SQL Server 2008, we have experienced intermitted connection problems while using sqlcmd to execute stored procedures in a .cmd script. The error that occurs is "Microsoft SQL Server Native Client 10.0 : Unable to complete login process due to delay in opening server connection". The .cmd script is stored locally on the database server and the sqlcmd command uses the -E option to connect to the instance. I believe sqlcmd uses the OLE DB provider when run from the command line...Could the provider be the issue? Is there anyway to have sqlcmd use a different provider? Maybe use the SQL Server provider instead of SQL Server Native Client 10.0 provider?

  Any help would be appreciated.

  Thanks

• George Jones

  Grasshopper

  Points: 21

  More actions

  December 22, 2009 at 12:28 pm

  #1095595

  We are having the same problem with SQL 2005. IF we use the -U -P switches instead of -E, the command connects instantly. Unfortunately, our process requires Windows Authentication. Any ideas, beside DC communication issues, that might be causing this error?