October 8, 2014 at 5:27 pm
Created the proxy account To run the ssis package in the job.
Before that created the new credentials and mapped to the existing login.
Login failed.
Do we need to give credentials password as Logn password?
What is the relation b/n crednetials & login
October 8, 2014 at 9:38 pm
ramana3327 (10/8/2014)
Created the proxy account To run the ssis package in the job.Before that created the new credentials and mapped to the existing login.
Login failed.
Do we need to give credentials password as Logn password?
What is the relation b/n crednetials & login
Not sure what you mean, there is no "mapping" between a cred and a login the're totally different things.
Although you can have a login and a cred that are the same account but there is no link between them and you can create a cred without a login.
whatever account is specified in the cred needs the pw to go with.
A credential is used by the proxy to say I'm executing as this account. And that account must have access to all the resources that the SSIS package is using including the location where the packages are stored (for sure if you issue an exec package task) it may also need access to the local file system, and any sql server including the local one where the job is executing (in which case that same account needs to be created as a login)
Creating a credential gives that account zero access to the sql server. To access sql server that account need to have a login and database security but again totally different than the credential.
hth
Tom
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply