Results 1 to 4 of 4
  1. #1
    iminore is offline new member
    Join Date
    Nov 2008
    Posts
    3

    Default SQL Express sa login messages

    I've got SQL Express on a Windows 2003 server. I've disabled the sa login but in Event Viewer/Application I'm getting a batch of Failure Audit messages 'Login failed for user sa'. This happens about every 40 minutes. SQL Express doesn't have an agent so I don't see how there can be regular jobs running.
    Any ideas anyone?

  2. #2
    eUK-Martin's Avatar
    eUK-Martin is offline Windows System Administrator
    Join Date
    Nov 2005
    Location
    Earth
    Posts
    629

    Default

    This is probably a brute force from another server to get the 'sa' password of your SQL server and to inject virus link into the database. Since you say that you have disabled 'sa' login they will not be able to hack any thing but these processes will consume server resources:

    There are 2 option to overcome this problem:

    1. Disable Remote SQL connection.
    2. Configure Firewall or IP Sec to allow connections from know IP only.

  3. #3
    iminore is offline new member
    Join Date
    Nov 2008
    Posts
    3

    Default

    Thanks for that. Found the 'allow remote connections' control. It was 'enabled' but not any more. Will see if any more messages come through.

  4. #4
    iminore is offline new member
    Join Date
    Nov 2008
    Posts
    3

    Default

    hmm that made it worse. Now I'm getting the same messages continuously. Is it something internal to the server?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •