web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Database sessions
Microsoft Dynamics NAV (Archived)

Database sessions

(0) ShareShare
ReportReport
Posted on by Community Member

I have recently started providing assistance to a small business that uses Microsoft Dynamics NAV with SQL server that was set up by the NAV support people.

When the NAV server is started, multiple instances of "sa" show up in the NAV database information. Can anyone explain why this happens (I have already asked this question in the SQL forum, but was advised to ask here as it might be better understood).

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,419 User Group Leader on at

    Hi Michael,

    There can be two reasons for same -

    1. Multiple users are using SA to login into Navision. Navision does not restrict multiple users to use same account.  (IF you are checking the NAV Database Information).

    2. Only one user is using SA login and doing multiple transactions. At Sql the transaction is appearing in steps / Parts. (IF you are checking the users in SQL).

    Hope it helps. Let me know if any issues.

  • Community Member Profile Picture
    Community Member on at

    Hello Saurav

    No, this is not related to standard users or transactions.  It happens when the service starts and before standard users have access.  There are 19 sessions all starting at exactly the same time on service start (or server reboot).

  • Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,419 User Group Leader on at

    Hi Michael,

    Which version of NAV you are referring to and Where you are checking the sessions?

  • Community Member Profile Picture
    Community Member on at

    Hi Saurav

    NAV 2009 R2 Classic.  Checking sessions in File, Database, Information.  The sessions appear at the very top of the connections list, but do not count in "Current Sessions".  If you can tell me how to attach a file, I can provide the information.

    Regards

    Michael

  • Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,419 User Group Leader on at

    Hi,

    For adding image select Use Rich formatting while replying to the forum.

    In Rich Formatting tool you get option to insert a picture. 

  • Community Member Profile Picture
    Community Member on at

    I have tried to create an image, but cannot get it small enough to meet the limit set.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    When you look at the sessions in 2009, you see all connections to the SqlServer. Some of them are system connections form services running on Sqlserver. They are not consuming users from your license. When i use the session form, I Always start with putting a filter on my database name, which ends up in showing only the connections to my Navision database.

  • keoma Profile Picture
    keoma 32,729 on at

    do you use the NAS (navision application server) ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans