Login problem when scheduling a dts package

Hi.
(Environment: Win 2000 Server sp. 4. MS SQL 7.0 sp 4)
As me, some of you might use the "Scedule Package" option on dts packages to
let the SQL server generate a job, and then copy the "Operating System
Command" string into another job which bundles together a set of dts
packages in one scheduled job.
My problem now is when I rightclick a DTS package and select "Schedule
Package" I get a [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
for user ' '. It got no detailed error number as the one you get on the
error: "...not assosiated with a trusted SQL connection..." stuff. It only
gives the general SQLState: 28000 error.
We have done a lot off stuff on our domain lately (converted to AD), but it
worked allright yesterday, but after a reboot this morning I got the above
issue.
Where should I start looking? Where do I set the login account which is used
when generating a job from a DTS Package? The Server Agent runs normaly, and
I'm logged into the server with the same ID which have created and owns the
DTS package
Please give me a resource URL or a hint on the above, if you have any
expiriences...
Regards
Mr. SmithThe problem with Authentication, can you provide for the DTS package, to
Windows authentication mode. so that the package run successfully. i faced
same problem.some R&D i fix that issue. can you proceed with windows
authentication.
still u have problem let me know.
"Mr. Smith" wrote:
> Hi.
> (Environment: Win 2000 Server sp. 4. MS SQL 7.0 sp 4)
> As me, some of you might use the "Scedule Package" option on dts packages to
> let the SQL server generate a job, and then copy the "Operating System
> Command" string into another job which bundles together a set of dts
> packages in one scheduled job.
> My problem now is when I rightclick a DTS package and select "Schedule
> Package" I get a [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
> for user ' '. It got no detailed error number as the one you get on the
> error: "...not assosiated with a trusted SQL connection..." stuff. It only
> gives the general SQLState: 28000 error.
> We have done a lot off stuff on our domain lately (converted to AD), but it
> worked allright yesterday, but after a reboot this morning I got the above
> issue.
> Where should I start looking? Where do I set the login account which is used
> when generating a job from a DTS Package? The Server Agent runs normaly, and
> I'm logged into the server with the same ID which have created and owns the
> DTS package
> Please give me a resource URL or a hint on the above, if you have any
> expiriences...
> Regards
> Mr. Smith
>
>