<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
»
SQL Server 2005
»
Business Intelligence
»
How can I store the username and password...
11 posts, Page 1 of 2
1
2
»»
How can I store the username and password without config file
Rate Topic
Display Mode
Topic Options
Author
Message
karthick.alangattan
karthick.alangattan
Posted Tuesday, January 15, 2013 3:15 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 26, 2013 1:47 AM
Points: 3,
Visits: 62
How can I store the username and password not in the config file or SQL Server in SSIS, so that no one can identify these secured details.
Post #1407124
Sam Vanga
Sam Vanga
Posted Tuesday, January 15, 2013 4:26 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, June 14, 2013 1:13 PM
Points: 42,
Visits: 268
The secure/best method is to not save the password in config file and use Windows Authorization. If that's not possible, save in the config and restric access to that folder.
Details: http://consultingblogs.emc.com/jamiethomson/archive/2007/04/26/SSIS_3A00_-Storing-passwords.aspx
~Sam.
http://svangasql.wordpress.com
Post #1407156
karthick.alangattan
karthick.alangattan
Posted Tuesday, January 15, 2013 4:34 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 26, 2013 1:47 AM
Points: 3,
Visits: 62
Thanks mate..its very useful info.
Post #1407164
Jayanth_Kurup
Jayanth_Kurup
Posted Tuesday, January 15, 2013 4:35 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785,
Visits: 1,008
You can store package configurations in the database too
Jayanth Kurup
Post #1407165
Abu Dina
Abu Dina
Posted Tuesday, January 15, 2013 5:08 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 507,
Visits: 2,229
You can store package configurations in the database too
Jayanth Kurup
Do you mean having a table that contains the complete connection string (i.e. including user name and password)?
-----------------------------------
http://www.SQL4n00bs.com
Post #1407183
Jayanth_Kurup
Jayanth_Kurup
Posted Tuesday, January 15, 2013 5:31 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785,
Visits: 1,008
yes , please look at the below link for details.
http://msdn.microsoft.com/en-us/library/ms141682.aspx
Jayanth Kurup
Post #1407194
RSuman
RSuman
Posted Tuesday, February 12, 2013 1:13 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, February 18, 2013 6:39 AM
Points: 19,
Visits: 74
Connection passwords in a package can stored in package itself. SSIS provides encrypt sensitive information option in the package properties list. Best is encrypt with a password wherein you provide another password to encrypt the actual password.
Post #1418784
mmartin1
mmartin1
Posted Tuesday, April 30, 2013 11:10 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, June 13, 2013 2:02 PM
Points: 198,
Visits: 656
When you want to schedule the job, do you need to provide the package password in the agent configuration? If so would you need to restrict access to who can view the agent ? If so that may not go far enough if there are many users with elevated priviledges.
Post #1448153
dg227
dg227
Posted Wednesday, May 01, 2013 3:43 PM
SSC Veteran
Group: General Forum Members
Last Login: Today @ 9:10 AM
Points: 232,
Visits: 671
mmartin1 (4/30/2013)
When you want to schedule the job, do you need to provide the package password in the agent configuration? If so would you need to restrict access to who can view the agent ?
If the package is encrypted, you can pass in the package encryption password via the dtexec /DE switch (in SQL Agent, or most any other scheduling utility).
mmartin1 (4/30/2013)
... may not go far enough if there are many users with elevated priviledges.
Potentially a privledged permissions problem.
Post #1448633
nick.mcdermaid
nick.mcdermaid
Posted Wednesday, May 01, 2013 10:29 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:15 PM
Points: 162,
Visits: 437
Seriously - go with Sam's suggestion of windows authentication and forget about all these convoluted solutions requiring special passwords to be hard coded all over the place. You have an enterprise security store - use it.
Say NO to proliferation of passwords.
Post #1448678
« Prev Topic
|
Next Topic »
11 posts, Page 1 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.
