Randy,

What version of the SQL Agent are you running?

SQL Server 7.0 support was added in PTF#1.

So, you MUST be running version 1.1.1 (or 1.1.1A)
in order for the SQL Agent to run with SQL 7.0.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com


> I am having troubles with getting an NT SQL Server using the ADSM SQL
> Connect Agent.  I have installed the product following IBM's directions,
> however, when I get to the point where I want to view the databases for
> backup I recieve a message that says "Can't obtain attributes for the
> specified SQL database".  Without being able to choose which database to
> backup, the backup process gives the error "Access Denied".  If any of
you
> have installed this and use the directions manual that is printed out of
the
> getting started portion of the setup cd, I am up to page  26 of 63 and
> that's where it won't go any further.
>
> I am using the standard security with "sa" as the user with no password.
> The databases are SQL 7.0.  The NT server is registered with our ADSM
backup
> server.
> The ADSM does do a scheduled backup, so that is set correctly.
>
> Thanks,
>
> Randy Fenrick
> Network Specialist
> Lab Safety Supply
> r.fenrick AT labsafety DOT com
>