Executing a BCP command and see the following error: SQLState = 08001, NativeError = 0

• leosinclair

  Old Hand

  Points: 368

  More actions

  May 26, 2011 at 8:40 am

  #238885

  Hello to all,

  This is a rehash of an issue that was first noted in a SQL 2005 posting but I didn't see a valid resolution. So with that disclaimer.... Here's our issue:

  We are seeing the following error message with our bcp command and SQL 2008. Error message:

  SQLState = 08001, NativeError = 0

  Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection

  Details:

  We have a bcp command running on App Server and the command is passed to the SQL Server 2008 but then returns the error message. We notice one job would fail at the same time every morning but other jobs would fail randomly during the day.

  Here's the kicker. When we moved the time of the morning job, the error was resolved; however, the other errors happen at random times.

  We need a resolution...

  Thanks in advance.

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  May 26, 2011 at 2:10 pm

  #1330628

  Sounds like a resource contention issue...those are fun to figure out

  >Are there network congestion issues in your environment?

  >What else is running on the app server at the time when you get the error?

  >What else is running on the database server at the time when you get the error?

  >It could be virtually anything between the BCP command and the database instance...

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato