Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Destination Path Problem

Author  Topic 

aiman
Starting Member

18 Posts

Posted - 2007-07-08 : 02:32:36
I used a DTS which output file destination is following in a Network, where "OutBoundFTP" folder is shared.
\\10.234.136.22\OutBoundFTP\CNS1_OD.txt

when i am going to run this DTS it showed me "Login Failor, Unkhowen User name or password", Here i have not seen any option to give user name and password.

Need Help..

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-08 : 16:39:48
what are the rights for the shared folder?

and more important, is the server joined in a domain?
because if you try to reach an server wich is not in the same domain as your sql server it probably will not accept impersonated logons to that server.

Need an SQLDB consultant?
check www.veeningsengineering.nl
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-08 : 20:09:20
Should be ok if domains are trusted, but you need permission on that share in either cases.
Go to Top of Page
   

- Advertisement -