2012年3月27日星期二

BCP with Windows authentication?

We've been using BCP.EXE for ages, but are now connecting to our
databases via Windows authentication rather than SQL ID's. How can I
get BCP to connect via Windows authentication? Thanks.Can't find Books on Line? First, run bcp /? to see all the
parameters. You will find one to use a Trusted connection:
[-T trusted connection]
Roy Harvey
Beacon Falls, CT
On Wed, 3 May 2006 12:44:08 -0400, Rick Charnes
<rickxyz--nospam.zyxcharnes@.thehartford.com> wrote:

>We've been using BCP.EXE for ages, but are now connecting to our
>databases via Windows authentication rather than SQL ID's. How can I
>get BCP to connect via Windows authentication? Thanks.|||I have not tried this in a long time but shold be -T as shown on the help
-T (trusted connection)
Ben Nevarez, MCDBA, OCP
Database Administrator
"Rick Charnes" wrote:

> We've been using BCP.EXE for ages, but are now connecting to our
> databases via Windows authentication rather than SQL ID's. How can I
> get BCP to connect via Windows authentication? Thanks.
>

没有评论:

发表评论