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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Security, bcp, linked server's NT authentication

Author  Topic 

SQLCode
Posting Yak Master

143 Posts

Posted - 2004-06-01 : 13:45:08
Hi,
I was trying to
1. configure linked servers
2. bcp.

Very general question, when we provide id and password as arguments, how do we provide values for NT authentication mode ?
Is it possible to give security to be NT authentication and not a std. mode of uid and password.

TIA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-01 : 13:49:11
If you want to use Windows authentication on a linked server, use "Be made using the login's current security context' option on the second tab of the linked server setup.

For bcp, use -T switch.


Tara
Go to Top of Page
   

- Advertisement -