Groups | Search | Server Info | Keyboard shortcuts | Login | Register

Groups > comp.databases.ms-sqlserver > #2262

Determine what password is used during a login attempt

From Anton Shepelev <anton.txt@g{oogle}mail.com>
Newsgroups comp.databases.ms-sqlserver
Subject Determine what password is used during a login attempt
Date 2025-03-05 14:28 +0300
Organization A noiseless patient Spider
Message-ID <20250305142848.fc47cf2469d2b8e8a1b6675d@g{oogle}mail.com> (permalink)

Show all headers | View raw

Hello, all

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?

-- 
()  ascii ribbon campaign -- against html e-mail
/\  www.asciiribbon.org   -- against proprietary attachments

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

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