June 13, 2008 at 10:35 am
I have a link between 2005 SE 32 bit and Oracle using 9i client. works dandy if you are a local admin, if not even if you are a SQL SA no dice. What needs perms at the OS lvevl on the SQL box?
June 13, 2008 at 10:49 am
I'd first check Oracle client folder (probably c:\Oracle) might need some perms.
Make sure the account you are running sql as has read access to this folder and subcontents.
Also, if you are using oranames.tns file, and it stored on a network drive, you will need to copy that local to your server and update the registry to point to it. You may be able to get around that case if you use a domain account to run sql sever, give appropriate permissions and UNC path in registry. Havn't tried that before myself.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply