App does not open after SQL password reinstate

EM 271 Reputation points
2023-05-09T22:12:44.8933333+00:00

We have a visual studio app that has run successfully for many years that connects to a SQL server backend. Many people use this app, both internally and out in the field. Recently we were asked to change the password used to access tables in SQL. This meant that the app had to be updated with the new password. Yes, I know that that should not be allowed.

We published the new app and all went well until we disabled the old password. Now the app will not open or download correctly when requested. We reinstated the old password, changed the programming to use the old password again, and now it works internally but not for others in the field.

I've checked and rechecked the programming to make sure the old password is used and not the new.

Any idea why disabling the old password would cause such a problem?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,089 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 42,486 Reputation points
    2023-05-10T05:20:41.7366667+00:00

    We have a visual studio app

    Visual Studio is the IDE, not the type of app.

    until we disabled the old password

    You deleted a password; where?

    Review SQL Server ErrorLog if you have any related error message about failed logins.

    disabling the old password

    It's not possible to disable a passwort, only logins.

    Sorry, your description is that vague, it's more then difficult to assist you.

    0 comments No comments