dbTalk Databases Forums  

Error Opening Data File:Login Failure:Invalid User or Bad Password

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


Discuss Error Opening Data File:Login Failure:Invalid User or Bad Password in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Delf
 
Posts: n/a

Default Error Opening Data File:Login Failure:Invalid User or Bad Password - 07-25-2006 , 05:04 AM






I've read the link on How to Run a DTS Package as a Schedule Job but I really
can't find the caus
This package failed when scheduled with the error in the Subject Line. But
I had no problem manually executing it.

The package's owner is the same as both the SQL server and SQL server agent
start up account. I have even ticked all the server roles including SYsadmin
for this account to no avail...
The path has also changed from map to using UNC..

This package 's task is to write a file on another server. Othe package can
schedule ok(mainly transferring files b/w SQL servers).

What else can I look out for ? should I turn and focus on the rights and
permisson on between the server..but then I could write successfully when
manual run paackge...

Can someone kindly advise me .. I'm getting demoralised to get stuck on this..
Thanks a lot in advance..

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.