Solved

adding Linked server for AS400

Posted on 2010-08-16
10
412 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
 

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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now