Forum Discussion

Naveenks's avatar
Naveenks
Contributor
7 years ago
Solved

Password in encripted format for sql database in connection string

Hi,   I am having connection string for my SQL server where in which i need to enter plain password for connction through database.Is there any way so that i can hide or display that password in ...
  • tristaanogre's avatar
    tristaanogre
    7 years ago

    Sure... my intention was in script.  So, what you would do is something like this.

    var ConnectionString = "DRIVER=SQL Server;SERVER=H_kptest;UID=aaa;PWD=" + Project.Variables.password.DecryptedValue;
Naveenks's avatar
Naveenks
Contributor
7 years ago

Hi ,

 

I want it through script if we have any approach for that.

 

Regards,

Naveen..

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

Sure... my intention was in script.  So, what you would do is something like this.

var ConnectionString = "DRIVER=SQL Server;SERVER=H_kptest;UID=aaa;PWD=" + Project.Variables.password.DecryptedValue;
  • Naveenks's avatar
    Naveenks
    Contributor
    7 years ago

    Thanks,

    This line of code solves my problem.

     

    Regards,

    Naveen...