| Author |
Topic |
|
kowani1
Starting Member
42 Posts |
 Posted - 2007-06-17 : 20:05:04
|
| I have W2k server with SQL Server + SP4 and created a linked server to an Oracle DB using the MSDAORA driver.I am getting this error every time I want to list the tables/views.Error 7399: OLE DB Provider 'MSDAORA'reported an error. Access denied. Please help me resolve this ASAP.Thanks. JungleDBA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 20:17:41
|
| How did you map sql user to Oracle ones in linked server? |
 |
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-06-17 : 20:34:35
|
| I created a user on my Oracle DB and used the same user whose security context I am using to connect to the Oracle DB instance.Normally, if there are authentication issues, the error explicitly states that, but I am baffled by this 'Access Denied' error. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 22:07:16
|
| Did yoy map sql login to that Oracle user in linked server? |
|
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-06-17 : 22:45:27
|
| yes I did map the SQL Login to this Oracle User in the Linked Server 'remote server' logins. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 22:49:06
|
| Tried create linked server with other provider? |
|
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-06-17 : 23:11:58
|
| One interesting thing I am realising is the Linked Server works fine when I am loggin onto the server as the domain service account but not for any other domain account which also has sysadmin priveleges. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-18 : 16:12:38
|
| Depends on how you mapped user to oracle id in linked server. |
|
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-06-19 : 01:18:05
|
| I have tried to map the linked server login to an Oracle user as follows, but still having the same 'Access Denied' issue.EXEC sp_addlinkedsrvlogin 'test', 'true', '[domain]\[user]', 'oracleuser', 'password'where the domain\user has domain admin priveleges.I don't know what to do next, other than to change the domain\user from being the local SQL service account and replacing it with 'local system account'. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-06-19 : 03:09:06
|
| check to see if you have a "firewall" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-19 : 11:08:18
|
| Is [domain]\[user] a valid sql login? |
|
|
|
|
Access Denied - Linked Server