Home Forums SQL Server 2008 Security (SS2K8) SQL server login succeed many times in log RE: SQL server login succeed many times in log

  • August 18, 2015 at 9:54 am

    #1820804

    Lowell (8/18/2015)

    also, think about any items you might have installed, whether running in the background or as a service, that are running under your credentials, maybe something like RedGate lighthouse , or some monitoring service.(spotlight/ polymonitor/sqlmonitor etc)

    THAT has been a major problem where I work. I don't know what the hell it is about some of these products but they cause the desktop machine to try logging into the SQL Servers all by themselves and they are bloody relentless and it's always a chore to figure out precisely what is doing it on each box and then figuring out how to stop it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)