<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Polar Bear
»
Run an SSIS Package Under a Different Account...
18 posts, Page 2 of 2
««
1
2
Run an SSIS Package Under a Different Account
Rate Topic
Display Mode
Topic Options
Author
Message
sqlusers
sqlusers
Posted Monday, March 29, 2010 10:12 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, June 04, 2013 6:13 AM
Points: 196,
Visits: 467
Nice Article!!! Thanks for posting...
Post #891991
hzhu
hzhu
Posted Monday, March 29, 2010 11:53 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, November 12, 2010 1:31 PM
Points: 9,
Visits: 52
I have one question about this section:
Enter the credential name - Enter the domain account, and password. Repeat the password in the 'Confirm password'. This account should have the right access to the application database.
We use windows authentication to connect to the database. So if I put individual account, I can use network password. What if I need to add a group for credential, and the group doesn't have a network password. What should I put in password field?
Post #892084
Grey Cat
Grey Cat
Posted Monday, March 29, 2010 4:44 PM
Grasshopper
Group: General Forum Members
Last Login: Today @ 3:53 PM
Points: 22,
Visits: 97
I don't think a group account without password will work this way. The originally purpose of doing that is to bypass different accounts that do not having access...
Post #892305
min 30087
min 30087
Posted Wednesday, July 14, 2010 10:45 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, July 18, 2010 5:53 PM
Points: 2,
Visits: 8
One question for this:
What if the credential's password get changed? I had been using one credential and created a proxy to run the SSIS package in SQL Agent jobs, but the job failed after the password for the account changed.
any comments will be appreciated.
cheers,
Min
Post #952841
Grey Cat
Grey Cat
Posted Thursday, July 15, 2010 11:53 AM
Grasshopper
Group: General Forum Members
Last Login: Today @ 3:53 PM
Points: 22,
Visits: 97
Please check the ProtectionLevel of the SSIS package.
If it's not DontSaveSensitive, change it to.
Hope that helps.
Post #953368
min 30087
min 30087
Posted Thursday, July 15, 2010 7:23 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, July 18, 2010 5:53 PM
Points: 2,
Visits: 8
Thank you Grey Cat,
I did what you told me to, but the package still fails.
the only way i can avoid the failure is to change the 'credential' password under security of the database.
I guess i did not make it clear
I found that whenever the user's password is changed in the windows operating system, i have to change the passward in the SQL server credentials too otherwise it will fail the package scheduled under the Sql Agent jobs.
My case is - one of our system administrators just went ahead changed the password without telling me and all my packages failed, i had to let him reverse back the password (or i could have just changed the password in SQL security - credentials)
And I wanted to know if there is another way to avoid this troublesome.
cheers,
Min
Post #953573
Grey Cat
Grey Cat
Posted Friday, July 16, 2010 10:02 AM
Grasshopper
Group: General Forum Members
Last Login: Today @ 3:53 PM
Points: 22,
Visits: 97
I see. the password in credential has to be the correct account password. Sorry, but your admin has to inform you if the password has been changed.
Post #953983
gscruggs
gscruggs
Posted Tuesday, October 23, 2012 2:04 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:10 AM
Points: 1,
Visits: 15
Great article. Used on a SSIS package for verifying addresses via the Melissa Data Contact Verify component against MS CRM contact addresses. Account running SQL agent did not have permissions to access data in the CRM db. This allowed me to setup a proxy with a known user and it worked like a champ.
Gene A Scruggs
American College of Emergency Physicians
Technical Support Manager
Post #1376229
« Prev Topic
|
Next Topic »
18 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
