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

Reply via email to