August 22, 2008 at 7:41 am
When creating a Linked Server to our AS400 using the IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider, we are running into an issue.
When trying to browse table or run queries using a Domain Admin account, there is no issue. When running it under my account (also a Domain Admin) I am getting: Error 7399: OLE DB provider 'IBMDA400' reported an error. Access denied.
The accounts used are also local administrators on the SQL 2000 server and assigned System Administrator role in the SQL Login Properties.
We were using an ODBC connection to perform functions such as select queries without any problems, but when we tried to start updating tables from an ASP page, we began having problems. Some tables would update and others returned errors.
I do not care which we use, so if anyone can provide some insight as to how to correct either issue it would be appreciated.
Thanks,
August 22, 2008 at 7:57 am
What are the settings on the Security Tab of the linked server properties? Perhaps your login does not have rights on the AS400?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 22, 2008 at 8:25 am
It is a valid AS400 login and it doesn't make sense that one account can perform the task, but others with all the same security both network, local machine, and SQL cannot.
Here is the error when trying to execute a query using my login:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'IBMDA400' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'IBMDA400' IUnknown::QueryInterface returned 0x80070005: Access denied.].
When I use the actual Domain Admin account, I cannot view the tables, but can run queries and get results.
We as I mentioned before, have a linked server using an ODBC connection to the same AS400 using the same account and have no problems running select queries from any account, but ran into problems when trying to update a couple of tables on the AS400.
Thanks,
August 22, 2008 at 8:35 am
I'm not trying to beat a dead horse, but the error being returned indicates a permissions problem on the AS400 side. I am not an expert on DB2400, but I do know the security can be a hassle and easily messed up. Here is a link to a good article about connecting to DB2400 using the Microsoft drivers: http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1326266,00.html?asrc=SS_CLA_301332&psrc=CLT_87.
Also if you are running updates from a web page, why add the hassle of a linked server when you can do it directly? I'm sure you have a reason, but I have to ask.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 22, 2008 at 8:41 am
I understand totally. I am not the DBA nor am I an AS400 person. I am the LAN Admin and got in the middle of this because it does appear to be security and I also agree that it is on the AS400 side, but since we are using the same AS400 account to access it with all the Windows accounts, it doesn't make sense that one Domain Admin account can perform the task and two others cannot since they are set up identically on the SQL server.
I will look into the link you sent to see if I can seea nything there.
Thanks for your help.
I may be back>>>
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply