Post reply

BCP- can''t connect

  • December 25, 2005 at 12:19 pm

    #170203

    I am running BCP file against a server (located on the same machine) which uses Windows Authentication. I've used -T instead of -U -P. I am logged in as Administrator with no password. But the login fails.

    This is the content of the batch file:

    bcp btest-copy..order_details in order_details.txt -c -t"|" -r"\n" -S

    maloy\inst1 -T

    I receive the following error:

    SQLState = 37000, NativeError = 4060

    Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requ

    ested in login 'btest-copy'. Login fails.

    Thank you.

  • December 25, 2005 at 12:57 pm

    #611401

    OK, I figured the answer. Can't have a dash in the object name. Thank Enterprise Manager! With friends like this, who needs enemies?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply