prerequisites for bcp usage - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

prerequisites for bcp usage

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-12-30 : 18:23:20

2 questions pls:
1/ can we use bcp also in windows authentication mode or only in sql server mode.
Because when i try to execute bcp from dos using windows account (my machine account since m runing XP) I get the error:
The user is not associated with a trusted SQL Server connection
but when i switched to sql server authentication mode. the new username and password worked well when used in BCP from command prompt.

so my question: how do i make bcp work when using win auth mode instead of sql auth mode
Thanks a lot

monty
Posting Yak Master

130 Posts

Posted - 2006-12-31 : 04:06:45

u can use bcp in windows mode.

did u specify the -T option?

if not specify -T option (trusted connection), which will create a trusted connection..