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
8 years ago

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.

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    OK, interesting... 

    Before you click "TestConnection", what happens if you just click "OK" on all screens to save all settings before you come back in?

    • srandall's avatar
      srandall
      Contributor
      8 years ago

      The same thing happens, unfortunately.

       

      OK. So it sounds like I need to get technical support engaged. I want to thank you very much for answering my post and following up to try to help me. It is very much appreciated!! 

  • 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: