bcp login failure in query analyzer but ok in cmd console ???!!!

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  February 10, 2006 at 6:29 am

  #170583

  Hi guys,

  I tried to execute in query analyzer (I connect with windows authentication) this cmd:

  exec master.dbo.xp_cmdshell 'Bcp "SELECT * FROM db.dbo.table" queryout "d:\test" -n -S . -T',

  and the error is:

  Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\user'.

   

  If I execute the bcp cmd directly from cmd line, the bcp is execute without problem.

  Do you have any suggestion?

  thank

  

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  February 10, 2006 at 8:29 am

  #620158

  Sorry,

  the error is:

  Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\machine'.

  the problem is that: I log on to windows as domain\user and log on to SQLserver with windows authentication, but the login is 'domain\machine' ???

  Any suggestion

   

• AMIT GUPTA-263376

  SSCarpal Tunnel

  Points: 4244

  More actions

  February 10, 2006 at 8:34 am

  #620165

  Your,

  Windows Domain settings are chaged.

  You should login the SQL TO sa

  The Sql Server Administrator Account  

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  February 10, 2006 at 3:36 pm

  #620296

  I'm thinking that you are right.

  thank a lot, I will investigate in this way...