A few weeks back, I ran into this problem where one of our console application, which was doing image extraction into the remote server stopped working because we moved to a Clustered environment, and pass through security would not work anymore. Basically, I could see the share by manually entering the username, and password, but that kind of share is not recognized by SQL Server. In order to make it work, I wrote a custom VBScript which would open the prompt as a different user via runas, and pass the password. Trying to fine tune the script and the wait time before sending the password keys gave me no luck. So the only solution was to create the same username/password on the local machine from where the application was running and the remote machine, and running the application via Windows Scheduled job. That seemed to have done the work!
Runas in Windows
Leave a reply