Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Error

Status
Not open for further replies.

DanGus

Programmer
Joined
Oct 18, 2001
Messages
1
Location
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top