SQL server: SA user-id login

alijarte
alijarte Member Posts: 30
edited 2006-05-17 in Navision Attain
All,

today we had an issue with the user-id SA as it was blocking all the other users in the DB, then it came to my mind that SA is always logged in to SQL server but it is not clear to me the reason for those session opened to the master DB.

Could anyway through some light over topic?

Thanks,
Ch.
Ch.

Comments

  • bbrown
    bbrown Member Posts: 3,268
    These are core SQL Server processes that are running in the background.
    There are no bugs - only undocumented features.
  • DenSter
    DenSter Member Posts: 8,307
    The sa account should only be used by the system admin (hey what a coincidence!! System Admin, initials SA :)). It looks like you have the sa account set up for some services.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • bbrown
    bbrown Member Posts: 3,268
    These processes are part of SQL's internal operations. The user has no control over the login account used by these processes.
    There are no bugs - only undocumented features.
  • kine
    kine Member Posts: 12,562
    Hint: If the session ID is < 50, it is internal process (for example process doing checkpoint, rollback etc...)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories