[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to access data on authenticated ASA server from ASE server

Posted on 2006-12-01
2
Medium Priority
?
507 Views
Last Modified: 2009-07-29
Hi, we are trying to export some data from system running on ASE server to accounting system, that uses authenticated edition of ASA server. I have created remote server and proxy tables on ASE and I can read data from these tables. When I try to insert some data, I get "ASA Error -98: Authentication violation". I have obtained authentication code from our accounting system vendor, but I don't know how to tell ASE to use it. Does anybody know, how to pass this code to ASA ?
Jan
0
Comment
Question by:Jan Franek
2 Comments
 
LVL 14

Author Comment

by:Jan Franek
ID: 18063554
OK, it seems, that I have found the answer. I have used sp_passthru to send "SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='authentication code'" to ASA server and now I'm able to insert, update or delete data - as long as my connection to ASA lives.
0
 
LVL 1

Accepted Solution

by:
kodiakbear earned 0 total points
ID: 18064295
Closed, 500 points refunded.
kb
Experts Exchange Moderator
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Exchange administrators are always vigilant about Exchange crashes and disasters that are possible any time. It is quite essential to identify the symptoms of a possible Exchange issue and be prepared with a proper recovery plan. There are multiple…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

872 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