Dear Shamsudeen,

I am connecting from another machine in the network and doing bcp.

SO I should mention the server machine name.Pls help

My command is this

bcp testdatabase.dbo.[dimension_72] in E:\HR.txt -S xxxxx\SQL2005 -USA -PSA -f E:\HR_unq.fmt -e E:\HR_unq_error.log -o E:\HR_unq_bcp.log -t "" -r

where xxxxx is server name

THe error...

The server is running and I am able to connect with the same credentials using QueryAnalyzer

My command is this

bcp testdatabase.dbo.[dimension_72] in E:\HR.txt -S chennai\SQL2005 -USA -PSA -f E:\HR_unq.fmt -e E:\HR_unq_error.log -o E:\HR_unq_bcp.log -t "" -r

THe error is as follows:

SQLState =...

I am getting this error while using bcp in 2005

SQLState = 28000, NativeError = 18456

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

THe bcp command worked fine when...