mibuso.com
Home› Navision Attain

SQL server: SA user-id login

alijartealijarte 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

  • bbrownbbrown Member Posts: 3,268
    These are core SQL Server processes that are running in the background.
    There are no bugs - only undocumented features.
  • DenSterDenSter 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
  • bbrownbbrown 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.
  • kinekine 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.
Sign In or Register to comment.