Re: Random Login Failures
From: ME (mail_at_moon.net)
Date: 03/05/04
- Next message: Yuri G.Quaresma: "SQL Memory - The SQL Server can not use more than 2GB"
- Previous message: Ray Watts: "SQL 2000 Enterprise Installation"
- In reply to: Errol Neal: "Random Login Failures"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 5 Mar 2004 09:54:07 -0800
setup a trace in Profiler to collect failed logins with these columns
needed: database ID, host name, login name, NT username, ApplicationName.
Analzy the trace after some failed login may help. My box had failed logins
that later I found out a report queried ALL user databases instead SOME
databases.
"Errol Neal" <errol.neal@enhtech.com> wrote in message
news:EB7BAE21-8C53-4367-B45B-ABFEE001CF3F@microsoft.com...
> Hi folks,
>
> I am not a SQL Server Guru - so I was hoping I could get some help in
tracking down a problem I am having.
>
> We run MSSQL 2000 on a Poweredge 2650. This server is a dedicated SQL2000
machine. It has dual Xeon procs @ 2.4/400 and 2048 MB of ram. In terms of
disk, its has 4 Ultra 160 73 GB Seagate SCSI disk. The databases hosted on
the system are primarily for a bunch of ASP and Coldfusion based web sites
hosted on our application servers.
>
> Lately, we have been seeing a lot of random login failures for certain
databases. As I said they are random and really are not associated with any
occuring events. The databases we are seeing this behaviour on are db's that
see alot of activity. The system on a whole is pretty active as it is our
primary database server hosting about 50 or so databases. In terms of why
this is happening, we are very stumped. The login info specified in the code
of these sites are consistenly defined and have the correct login
information so it is not that we are supplying incorrect login information
to the server otherwise these sites would not work at all as they are
database dependant. So I was wondering, what can cause this? Is this a sign
of some a machine that is overworked? I would appreciate any help and input
you folks may have.
>
>
> Regards,
>
> Errol Neal
>
>
- Next message: Yuri G.Quaresma: "SQL Memory - The SQL Server can not use more than 2GB"
- Previous message: Ray Watts: "SQL 2000 Enterprise Installation"
- In reply to: Errol Neal: "Random Login Failures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
