January 30, 2009 at 7:31 am
This question might no entirely be an SSIS issue but any help or direction would be greatly appreciated.
I am trying to run a SSIS Job that has a script task that looks at a file on a network drive on another server. I am using the UNC path for the drive,ie \\server\folder\filename. I understand that when you run a job it runs it under the sql agent, so I have created a credential with my windows authentication and created a proxy that is run on the job.
The issue I am running into is that at our company we have to change our password every few months so having my windows authentication is not the best approach for the credential. Is there a way to create a generic login that would work on both system along with the SQL Server 2005 credentials.
Thank you for any help.
January 30, 2009 at 12:24 pm
Is your SQL Agent run under a local account? Is that why you don't just grant it permission to access the remote file?
Greg
January 30, 2009 at 12:28 pm
Yes I am running it under the default local account.
January 30, 2009 at 6:47 pm
Got it. Then my recommendation would be to have a domain login created that doesn't have the password change requirement and use it in the credential.
Greg
February 2, 2009 at 6:40 am
Greg Charles (1/30/2009)
Got it. Then my recommendation would be to have a domain login created that doesn't have the password change requirement and use it in the credential.
I thought I would have to go this route, I was hoping not to have to. Thanks for your help Greg!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply