Windows authentication cannot be forwarded to another system. For security purposes it is not possible.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kevin King Sent: Monday, April 19, 2010 7:23 AM To: U2 Users List Subject: Re: [U2] [ud] Unidata as a SQL Server "Linked Server" via OLEDB New information: In earlier tests I was logging in to SQL Server using Windows authentication. All queries with the linked server using IBM/Rocket's UniOLEDB driver failed. Over the weekend the client set up my user ID using SQL Server authentication, and the queries now work (on the old server; the new server is still a mess). The authentication method is the only thing that changed. This then begs the question: What Windows permissions are being respected by the UniOLEDB driver that it would work in one authentication scheme but not the other? -Kevin http://www.PrecisOnline.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
