• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

Authentication problem with Linked Server executing Stored Procedure from VB Script

I am trying to execute a sp from vb script.  The sp uses a linked server open query.  The SP works fine on the sql server instance through sql manager but results in an authentication error from a remote or local execution of a vb script wherein the connection string authenticates fine to the server instance but fails on the sp with the linked server.  error rendered on vb script execution.   I have added the authentication for the sql database used in the connection string as  local server login to remote server login under the security tab in the linked server properties with out success.  security tab in linked server.  Any thoughts?

Thanks
0
wkrasner
Asked:
wkrasner
  • 2
1 Solution
 
jkaiosIT DirectorCommented:
Could you post the code and possible the line that causes the error?
0
 
wkrasnerAuthor Commented:
Thanks for the reply. I figured out the problem I had the remote and local authentication reveresed
0
 
wkrasnerAuthor Commented:
I figured it out on my own
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now