May 23, 2011 at 8:31 am
Hi All,
In one of my requirement i need to configure my package with sql server authentications to connect to DB and i have to use XML configuration for the meta Data like Server,DB,Login/password Details.
I am scared to store Login/password details as part of XML,so i am thinking of some encryption techinces..
I know there is way to encrpt credentials if we go for SQL server configuration....but i am not sure about XML configuration....
Any help will be really appreciated.....and let me know if i am not clear....
May 23, 2011 at 8:44 am
Not exactly clear what you mean, if you're talking about an asp.net application and storing the connection strings in web.config then look here : http://lmgtfy.com?q=encrypt+connection+strings.
Even if this isn't exactly what you want it may point you in the right direction.
May 23, 2011 at 9:03 am
Thanks for the quick response Nigel. Below are the more details about the rek:
1.I have a SSIS package with single DB Connection manager which uses sql server authentications
2.I am using XML for package configuration.In this XML i will store Servername,DBname,Login and password details for the connection manager.
As i am storing login details as part of XML file anyone who opens the XML file will came to know about the production login details which is not fair.
For your Reply :
I am not supposed to hard code the password inside the package itself as if there is any change in the password we have to redeploy all the packages with updated password in the package.
Hope i am clear atleast this time...
May 23, 2011 at 9:16 am
Ok, sorry that's beyond my knowledge.
You may be better off asking this in the SSIS forum on this site .
May 23, 2011 at 11:26 am
Direct all replies here:
http://www.sqlservercentral.com/Forums/Topic1113404-364-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply