Bcp Failing

i ran it from the command prompt. I used my nt account which belongs to the domain admin nt group. my account does have sql access as sa.

also on one of the servers all jobs are failing with the following message - Unable to Connect to Sql Server (local). The nt log records the error that the specific user sqlexec (this is the account on which sql executive runs) is not defined as a valid user of a trusted sql server connection. I am not able to change the security setting on this server using EM nor am i able to use the sql security manager. I get an access denied error. What is the workaround for this problem? Will stopping and restarting the sql service help?
------------

How did you run bcp? In dos prompt or as sql job? Which nt account did you run bcp under? Did you grant sql access for that nt account?


------------
aruna at 1/3/01 4:39:49 PM

Subject:
From:
Date: bcp failing (reply)
Ray Miao ()
1/3/01 4:15:33 PM

yes i did. it still gives me the same error - 18452 error not associated with a trusted connection
-----------------

Did you enable mixed login mode on the server?

------------
aruna at 1/3/01 2:55:59 PM


hello ray

It still does not work. I granted SA rights for the nt group via sql security manager. For one of the servers i get the following error message -
This sql server does not support Windows NT SQL Server Security stored procedures.


--------------
From:
Date: bcp over trusted connections failing (reply)
Ray Miao ()
1/3/01 12:51:50 PM

Use security manager to grant access for nt account.


------------
aruna at 1/3/01 11:59:49 AM

i am attempting to bcp using the -T (trusted connection) option in sql 6.5. the login security mode is set to integrated. the bcp is however failing with msg 18452 error not associated with a trusted connection. why is this happening? i do not want to hardcode the sa password in the bcp command.

thanks