Solved

adding Linked server for AS400

Posted on 2010-08-16
10
411 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

743 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

10 Experts available now in Live!

Get 1:1 Help Now