Hello,

I am trying to set up a linked server with MS SQL Server and Active Directory. I have two questions:

1. What is the provider string and datasource for Active Directory when using Enterprise Manager?

2. Is it possible to use OPENQUERY to return the usernames AND the passwords to a table in SQL Server? If so, how would i accomplish this?


Thanks!

Joel