Linked Server Issue with AS400 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Linked Server Issue with AS400

Here is the situation. The link works when I connect with a SQL Server login and run an openquery statement against the AS400. The link throws the following error when I connect using a Windows Authenticated NT account.<br /><br />Server: Msg 7399, Level 16, State 1, Line 1<br />OLE DB provider ‘HiTOLEDB400’ reported an error. Access denied.<br />OLE DB error trace [OLE/DB Provider ‘HiTOLEDB400′ IUnknown:<img src=’/community/emoticons/emotion-41.gif’ alt=’:Q’ />ueryInterface returned 0x80070005: Access denied.].<br /><br />I really don’t understand how access can be denied when using a different authentication mode to connect to SQL Server because our linked server is always using the same Remote Login | Password for every connection to the AS400.<br /><br />I checked the permissions on the HiTOLEDB400 folder on the server and it looks fine. The crazy thing is I have the exact same setup on another server and it works. <br /><br />Any ideas?<br /><br />Thanks in advance for your help.<br /><br /><br /><br />
What is the version used for CLient access?
And ensure SQL server is on latest service pack. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hit Version is on Patch 2.1.0.3
SQL Server is 8.00.765
One thing that comes to mind that I left out in my previous posts is that the Link that is having the issues is on the named instance in my active active cluster. SQL01 has a link that is configured exactly the same and SQL Server Login works fine with link and the NT authenticated Login works fine with the link as well. SQL02(Named instance) has a link configured exactly the same and SQL Server Login works fine with the link but NT authenticated Login with the Link has the problem. Tested further and failed over the problem node to 01 and tried to access the Link with NT and it still fails. I am thinking this has something to do with the SQL Server named instance. By failing over to the other node I should be using the other nodes provider so I think provider is not the problem. Ughhhh…
Please post the statements used to create the Linked servers to those 2 instances. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>