Post reply

Unknown user trying to log!

  • November 11, 2002 at 3:07 pm

    #58142

    Hi! i have a challenge for you 🙂

    There is a user 'RECOVER' trying to access to a SQL7 Server (i saw it in the SQL logs), but the user doesn't exists neither as a server login, or a db user, or a login from the connected linked servers. How can i trace them? There is another kind of login that i missed to check? What can i do????

    Thanks in advance, and sorry by my English

  • November 11, 2002 at 3:17 pm

    #441017

    Try running the SQL Profiler and select Security audit,it gives the info. about all the users who are trying to log in.

  • November 11, 2002 at 3:29 pm

    #441021

    I don't found that option, remember that i'm working with SQL 7, maybe that option is available en 2000....

  • November 11, 2002 at 3:40 pm

    #441025

    is it an domain user name. They get access through a domain group.

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

  • November 11, 2002 at 3:42 pm

    #441026

    I think in SQL 7.0 it is under logins instead of security audit as in SQL 2000

  • November 11, 2002 at 3:51 pm

    #441035

    Simon, you are saying that 'RECOVER' is a NT User? or you are asking me?

    Simon says: is it an domain user name. They get access through a domain group.

  • November 11, 2002 at 4:03 pm

    #441042

    Look at connections.

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

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