Groups | Search | Server Info | Login | Register
Groups > comp.databases.ms-sqlserver > #2263
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Determine what password is used during a login attempt |
| Date | 2025-03-05 19:55 +0100 |
| Organization | Erland Sommarskog |
| Message-ID | <XnsB299CAB9E3DDFYazorman@127.0.0.1> (permalink) |
| References | <20250305142848.fc47cf2469d2b8e8a1b6675d@g{oogle}mail.com> |
Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> Hello, all
>
Yeah "all", it's soooo crowded here. :-)
> For some reason beyond our understanding, an installation of
> SAP Business One on one of our servers has lost the ability
> to connect to the MSSQL database under an internal,
> automatically crated user B1_SBOCOMMON. The Profiler
> intercepts the attempt:
>
> Logon Error: 18456, Severity: 14, State: 8.
> Logon Login failed for user 'B1_SBOCOMMON'.
> Reason: Password did not match that for the login provided.
> [CLIENT: 192.168.0.193]
>
> Is it possible determine the password it tries to use, if we
> have full admin access to that database (and the entire
> server) under the 'sa' user?
No. It's an encrypted hash. If it was reversible that would be a major
security issue.
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
Determine what password is used during a login attempt Anton Shepelev <anton.txt@g{oogle}mail.com> - 2025-03-05 14:28 +0300
Re: Determine what password is used during a login attempt Erland Sommarskog <esquel@sommarskog.se> - 2025-03-05 19:55 +0100
Re: Determine what password is used during a login attempt Anton Shepelev <anton.txt@g{oogle}mail.com> - 2025-03-06 13:35 +0300
csiph-web