Re: Where did the connections come from?

You'll need to use a network sniffer - the IP address of the failed
login isn't logged in SQL Server 2000, just SQL Server 2005.

-Sue

On Wed, 11 Apr 2007 11:04:01 -0700, bing
<bing@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks much for the reply. Good to know. But why I don't see any connecting
IP or hostname? In EM, under Management->SQL Server Logs, when I click a log
entry, here is all the information I can see.

SQL Server Error Log message
Source: logon
Date: 2007-04-11 09:49:40.22
Message: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL server connection.

I'm not clear if SQL 2000 has any log level settings anywhere.

Bing

"Russell Fields" wrote:

The login failure entries should have the IP address of the machine from
which the login was attempted. Look up that IP address on your domain and
see whose machine it is.

From the command prompt, this may help:
nbtstat -a the.ip.addr.ess

RLF
"bing" <bing@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:72B6EC6E-DFBE-4A5D-ADA4-480FCCC95B05@xxxxxxxxxxxxxxxx
Hi,

We use SQL 2000 on Windows 2003. In Enterprise Manager, when I looked
through the SQL server logs, I found a lot login failures. But how can I
know where those login failure connections came from?

Thanks much in advance for any insight.

Bing






.

Relevant Pages

  • Re: Cannot access my SQL Database
    ... >I have tried the sa login, the network admin logins I created to no avail. ... Is there a way to hack in to SQL Server accouts and reset them to allow all groups? ... >Login failed for user .....reason:Not associated with a trusted SQL Server connection. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)