Server Logs

Question

Server Logs

Techgrrl

Newbie

Points: 6
More actions
June 29, 2007 at 11:34 am

#68758

In my sql server logs I have several login failures

LOGIN FAILED FOR USER "DOMAIN"/"SERVERNAME".....

Why is this occurring???? When I say several, I mean a whole lot!

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

Because they don't have access?

Check to see that the user actually has a Windows Authentication login in SQL Server. ANd that they have access to one or more databases. Lastly, check that their default database actually exists.

-SQLBill

Techgrrl Newbie Points: 6 More actions · Answer 2

Thanks for responding......the user is not listed....it just says

LOGIN FAILED FOR USER ABC/MYSERVERNAME

What user account could it be referring to?

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

It would be the default user in the computer account. Did you remove builtin\administrators from your sql server logins.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 4

If a process runs as the local System account (Windows 2000) or Network Service account (Windows XP / Server 2003), it'll connect across the network as Domain\ServerName$. Typically this is a web application which is connecting via integrated security. Microsoft's CRM 3.0 product is an example of an application which connects in this manner.

If you're seeing hits from Domain\ServerName$, investigate what applications, especially web applications may be running from that server.

K. Brian Kelley
@kbriankelley

Techgrrl Newbie Points: 6 More actions · Answer 5

Thanks so much for the replies and the explanation!