Using Windows NT ID in BCP Stage

kalkavi · Post by **kalkavi** » Wed Aug 18, 2004 9:19 am

HI,

I'm trying to load SQL Server Table using BCP Stage. The Job works fine if i give an user id and password (USERid was created for that specific database). If i try to use NT id and password it gives login error.

Thanks for the help in advance
Kalyan

jeredleo · Post by **jeredleo** » Wed Aug 18, 2004 12:29 pm

Your SQL Server Database may not have synchronization with the NT Operating System. SQL Server can maintain it's own login account information outside of NT's. If you want to use the NT ID, you need to have the database set up to use Widows authentication and then grant this ID access to the database.

JB