Kevin If you are running SQL Server authentication (which was one of your tests) it takes on the permissions of the service user. Is that configured the same on both boxes?
Also from researching other postings this is not a U2-specific issue - I've seen the same reported for e.g. DB2 and PostgreSQL. Is there anything in the event viewer about permission or launch failure? Regards Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: 20 April 2010 11:20 PM To: U2 Users List Subject: Re: [U2] [ud] Unidata as a SQL Server "Linked Server" via OLEDB Hi Kevin It maybe permissions on other folders on that server. I would suspect that OLEDB needs to hold data in a temporary area, that temporary area may not be the same level of permissions on the box that is failing. Calling within linked server may change where that temporary area is located. Have you been able to link from that SQL Server to the other SQL Server? Regards David _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2823 - Release Date: 04/20/10 13:45:00 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
