Home Forums SQL Server 2008 SQL Server 2008 Administration reset sa password RE: reset sa password

  • January 31, 2011 at 6:23 am

    #1280372

    GilaMonster (1/31/2011)

    Brandie Tarvin (1/31/2011)

    Box Admin and SQL Server admin are not the same thing.

    They are if SQL is running in single user mode. Challenge appears to be to find what app is stealing the single connection.

    Might not be an actual app. It may be a domain account that keeps trying to re-acquire the connection every time it gets disconnected or killed. We have a few of those around our place.

    Wouldn't the security log give that information?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.