Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Question Unanswered: SQL Anonymous Logon

    I was reading though my logs and noticed I had three instances of an anonymous logon last night. The last anonymous logon was at approx midnight. This is prime hacking time.

    Can anyone give me direction on issues or concerns with anonymous logons.

    Much thanks in advance ....

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    An Anonymous logon? I do not think I have heard of such in SQL Server. Can you post the log entries?

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Was it successful or did it fail? Was it from an internal server? Does the server it originated from have SQL Server with linked servers?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Feb 2004
    Posts
    9
    Quote Originally Posted by derrickleggett
    Was it successful or did it fail? Was it from an internal server? Does the server it originated from have SQL Server with linked servers?
    derrickleggett,

    Thank you for your reply.

    1. It was sucessful.

    2. It is an internal server.

    3. It's not a linked server.

  5. #5
    Join Date
    Feb 2004
    Posts
    9

    Post

    Quote Originally Posted by MCrowley
    An Anonymous logon? I do not think I have heard of such in SQL Server. Can you post the log entries?
    Okay, I will send the log file as a word doc attachment.
    Attached Files Attached Files

  6. #6
    Join Date
    Oct 2003
    Posts
    9
    Do you have a FTP service running

    check this
    uder IIS >under FTP: (default FTP) > right click > properties > SEcurtiy accounts tab.

    see if you have "Allow Anonymous Connections" checked.
    that is all i can think of ...looking at the log.

    PS: I hope you have a password for sa setup. (in SQL)
    Last edited by EzCompany2Squad; 06-16-04 at 15:51.

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I am not sure what these could be, but they appear to be on our servers as well. I do not think you have anything to worry about, but you may want to check what these mean on an Windows NT forum.

  8. #8
    Join Date
    Mar 2004
    Posts
    114
    It is not linked to SQL. Has your server another role ? Like DC ? Or is FRS active ?

  9. #9
    Join Date
    Feb 2004
    Posts
    9
    Quote Originally Posted by EzCompany2Squad
    Do you have a FTP service running

    check this
    uder IIS >under FTP: (default FTP) > right click > properties > SEcurtiy accounts tab.

    see if you have "Allow Anonymous Connections" checked.
    that is all i can think of ...looking at the log.

    PS: I hope you have a password for sa setup. (in SQL)
    No FTP service. The server is linked to SQL.

    We are using anonymous access because of Active Directory according to the network guys.

  10. #10
    Join Date
    Oct 2003
    Posts
    9

    Thumbs up

    good job!
    thanks for posting and letting us know

Posting Permissions

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