Solved

adding Linked server for AS400

Posted on 2010-08-16
10
415 Views
Last Modified: 2012-05-10
I am trying to add a linked server for our AS400 to use with SQL 2005. So far I have not been sucessful. I am attaching what I entered and the error I received. Any help will be greatly appreciated. as400-Linked-Server-error.docx
0
Comment
Question by:qbjgqbjg
  • 6
  • 3
10 Comments
 
LVL 12

Expert Comment

by:NormanMaina
ID: 33448189
0
 

Author Comment

by:qbjgqbjg
ID: 33449170
I did not find anything there that helps. I am trying to fill out the screen correctly.
0
 
LVL 4

Expert Comment

by:MeLindaJohnson
ID: 33450441
Did you check to see if the "allow in process" has been checked?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:qbjgqbjg
ID: 33456233
What screen is that on?
0
 
LVL 4

Expert Comment

by:MeLindaJohnson
ID: 33456270
I use SQL 2008 so it may be the same

Using Management Studio,
expand linked servers,
expand providers
right click on your provider,
check Allow inprocess

Hope this helps...
0
 

Author Comment

by:qbjgqbjg
ID: 33456330
It is already checked.
0
 

Author Comment

by:qbjgqbjg
ID: 33457132
Is there an easy way to get the correct provider string?
0
 
LVL 4

Accepted Solution

by:
MeLindaJohnson earned 500 total points
ID: 33457354
0
 

Author Comment

by:qbjgqbjg
ID: 33466857
I was finally sucessful. I am attaching a document with what I did. Thanks for all of your help. It was trial and error until I got it working (along with help from google).
Setting-up-Linked-server-to-AS40.docx
0
 

Author Closing Comment

by:qbjgqbjg
ID: 33466967
See also my notes on how the linked server was sucessfully created on our system.
Thanks for your help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question