Hello,
I am trying to run a DTS package from within a stored procedure. The line looks like:
EXEC master..xp_cmdshell 'DTSRUN /Usa /SP4 /NtmpLoad'
This runs fine in a Win98 environment using SQL Server Authentication. When I take this over to an NT environment with /UAdministrator using Windows Authentication, I get the following error:
Login failed for user 'Administrator': Reason: Not associated with a trusted SQL Server connection.
This package runs fine when run directly in Enterprise Manager in NT.
Is there something extra I need to do under NT, or is this not allowed?
Thanks,
Dan
I am trying to run a DTS package from within a stored procedure. The line looks like:
EXEC master..xp_cmdshell 'DTSRUN /Usa /SP4 /NtmpLoad'
This runs fine in a Win98 environment using SQL Server Authentication. When I take this over to an NT environment with /UAdministrator using Windows Authentication, I get the following error:
Login failed for user 'Administrator': Reason: Not associated with a trusted SQL Server connection.
This package runs fine when run directly in Enterprise Manager in NT.
Is there something extra I need to do under NT, or is this not allowed?
Thanks,
Dan