Path: csiph.com!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!eternal-september.org!.POSTED!not-for-mail
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: Wed, 5 Mar 2025 14:28:48 +0300
Organization: A noiseless patient Spider
Lines: 20
Message-ID: <20250305142848.fc47cf2469d2b8e8a1b6675d@g{oogle}mail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Wed, 05 Mar 2025 12:28:48 +0100 (CET)
Injection-Info: dont-email.me; posting-host="e5369a913dd3986f63230c29ca5d147c"; logging-data="2524057"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18yHZHdNlg8t6el53xNwKqGKgrCRXIkH/E="
Cancel-Lock: sha1:bufTV3zZhngYWiyrBEFn8Zp8Gjk=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.30; i686-pc-mingw32)
Xref: csiph.com comp.databases.ms-sqlserver:2262

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