Home → Questions →

How to encrypt provider settings

• Edit

Gopinath Sabapathy

21 Jul, 2016 03:24 PM

Hi,

We are deploying the database using SSDT. In provider settings we have to provide the connection string with clear text database password which you can't encrypt or hide it in the UI.
How do we encrypt/hide the connection string specified in provider settings?

Thanks

1. Support Staff 1 Posted by Feodor Fitsner on 21 Jul, 2016 04:03 PM

   

   Is it environment or Deployment tab of project settings?

   • Edit

2. 2 Posted by Gopinath Sabapa... on 21 Jul, 2016 04:13 PM

   

   It is for environment provider settings.

   Please find the example screenshot attached.

   • Screen_Shot_2016-07-21_at_17.12.18.png 151 KB
   • Edit

3. Support Staff 3 Posted by Feodor Fitsner on 21 Jul, 2016 04:37 PM

   

   You can add a new Environment variable, say MyConnectionString at the bottom of this screen, then use it as a value for a setting like $(MyConnectionString).

   • Edit

4. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 02:07 AM.