Forum Discussion

srandall's avatar
srandall
Contributor
8 years ago

Is anyone having problems with password retaining when connecting to a database?

When I set up a data source, when I uncheck the 'Blank Password' box so I can provide a password, enter my password and check my connection, I can connect just fine. However, the box is re-checked on...
  • srandall's avatar
    srandall
    8 years ago

    For anyone else who has experienced this issue, SmartBear was finally able to help me resolve my issue.

     

    While you are setting up your database, select the 'All' tab and change 'Persist Security Info' to True.

     

    Changing this value will allow you to retain your selections:

srandall's avatar
srandall
Contributor

I select that I want to create a data loop for my test case and I name it. - Next-

I select that I want a Database query. -Next-

In the Connection section, I click on the button and I select 'Sql Server Native Client 11.0' and click OK.

I click on the button again so I can set up the connection.

I remove the checkmark for Blank password and set everything up

 

 

I test my connection and everything is good and I click OK.

I re-enter this screen by selecting the button by the Connection and it has re-checked the box for Blank Password.

 

 

I have tried not re-entering and seeing if I just need to complete the set up... that didn't work either. Regardless of what I do, that checkmark wants to stay in that checkbox.

AlexKaras's avatar
AlexKaras
Champion Level 3
8 years ago

Hi,

 

I would suggest to try to check 'Allow saving password' option as well. (I.e. both Empty and Allow options should be checked.)

Does this help?

  • srandall's avatar
    srandall
    Contributor
    8 years ago

    Unfortunately, I have tried that as well. I have a ticket in with SmartBear and have since Wednesday, but they aren't very responsive. ughhh......

    • srandall's avatar
      srandall
      Contributor
      8 years ago

      For anyone else who has experienced this issue, SmartBear was finally able to help me resolve my issue.

       

      While you are setting up your database, select the 'All' tab and change 'Persist Security Info' to True.

       

      Changing this value will allow you to retain your selections: