BCP error on 64-bit Yukon

• Fred Krusemark

  SSC Rookie

  Points: 26

  More actions

  September 8, 2005 at 2:31 pm

  #110279

  I'm getting the following error when I try to bring a file into Yukon on a 64-bit server:

  Code:

  EXEC

  xp_cmdshell 'bcp "<Database>.dbo.Table" IN "<Filename>" -n -T -S"<Server\Instance>" -e"<Error log file>" -h"TABLOCK"'

  Error:

  SQLState = 08001, NativeError = 17

  Error = [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied.

  SQLState = 01000, NativeError = 53

  Warning = [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()).

  NULL

   

  Any ideas? I've tried replacing the trusted connection option (-T) with a sysadmin user/pwd, but no luck.  I'm logged in as an admin on the server.

   

  Thanks,

  Fred

• PhilPacha

  Hall of Fame

  Points: 3645

  More actions

  September 9, 2005 at 1:30 pm

  #588884

  IF you are NOT running this SQL from the server holding the SQL Database, it doesn't know which Server to connect to.

   

  If you ARE running this from the server, my comment isn't any help.

   

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  September 12, 2005 at 3:35 pm

  #589192

  If your sysadmin role registered as login for SQL Server?

  _____________
  Code for TallyGenerator

• Fred Krusemark

  SSC Rookie

  Points: 26

  More actions

  September 13, 2005 at 4:51 pm

  #589538

  Solved.

  Turns out that the TCP/IP protocol for the SQL network configuration had been disabled.  How is another matter....

  Thanks for the replies.

  Fred