Re: Where did the connections come from?

Ah, in that case perhaps this is your problem:
http://support.microsoft.com/kb/307002

Harish Ranganathan may be able to help with his blog comments:
http://harishmvp.blogspot.com/2005/05/you-may-receive-error-login-failed-for.html
http://harishmvp.blogspot.com/2005/05/you-may-receive-error-login-failed-for_25.html

RLF

"bing" <bing@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A57DD3B7-3A03-45A5-B0A8-3499CDE2B58A@xxxxxxxxxxxxxxxx
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: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Problem connectin SQL Server 2005
    ... Have you configured the SQL Server 2005 to allow remote connections? ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem connectin SQL Server 2005
    ... > Have you configured the SQL Server 2005 to allow remote connections? ... > Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... > Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)