Forum Discussion

srandall's avatar
srandall
Contributor
8 years ago
Solved

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.

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!!