Pulling Data from DB2 on AS/400

#1

I dont know if this option is available to you, but it
works perfectly in other environments. Use passthru
authentication. Create a userid/password combination on
the AS/400 that's exactlly the same as the service
account of the SQL Server. Log in as the SQL Service
account on the SQL Server and create a link to the AS/400
and tell it to use the windows userid/password
combination, and then recreate a system DSN using this
link.

This works with MTS/COM+ components, and BizTalk.

Good Luck,
D2

Quote:

-----Original Message-----
We have a scheduled SQL Agent job that runs a set of DTS
packages that
transfer data from DB2 to SQL Server. The DTS uses the
Client Access Express
ODBC driver to connect to the AS/400. The ODBC driver
contains the proper ID
and password. SQL Server and Agent both run under an
account other than
Local/System, say ABC.

Problem is every time we re-boot the SQL Server, we must
run the Agent job,
one time, while logged in under the ABC account. After
that, the scheduled
jobs run correctly, until another re-boot. If we don't
do this, the Agent
job simply hangs trying to connect to the AS/400. I'm
guessing that running
the job one time must cache credentials.

Trying to figure out a way to prevent having to run the
Agent job the one
time.

Any ideas?
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Pulling Data from DB2 on AS/400

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Pulling Data from DB2 on AS/400 - 09-22-2004 , 12:02 AM