Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Database sessions

Posted on by Microsoft Employee

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).

  • keoma Profile Picture
    keoma 32,671 on at
    RE: Database sessions

    do you use the NAS (navision application server) ?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database sessions

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database sessions

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

  • Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,611 User Group Leader on at
    RE: Database sessions

    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 Microsoft Employee on at
    RE: Database sessions

    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,611 User Group Leader on at
    RE: Database sessions

    Hi Michael,

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database sessions

    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).

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,611 User Group Leader on at
    RE: Database sessions

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans