Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-10-05 : 14:58:53
|
| Hi,We have linked server for AS400. It is already setup on SQL Server 2005 and we can access data from linked sever.Recently I added one account through sp_addlinkedserverlogin that have same linked server properties on security tab. It is using remote login and password as other account setup on this security page. When user tried to access linked server, he is getting following error:"Cannot create an instance of OLE DB provider "IBMDASQL" for linked server "xxxxx""If I add my account, I can access. Any setting on SQL Server or AS400 side.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Linked Server Error