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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Connection --> No available companies

(0) ShareShare
ReportReport
Posted on by

Hi 

I am about to setup a new company with SQL database, Serverinstance and Client seperately

So far I have:

-Copied demodatabase to new testdatabase on SQL server

-Created new company and new user via administration shell

-Added new NAV service which points to the new testdatabase

-installed Client 

The problem is when I try to connect to the service via client. It seems like there is connection to the service but I do not have any available companies to choose from. How do I solve this?

Udklip.PNG

Thanks in advance!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    61,003 Super User 2025 Season 2 on at

    What is happening when you press tab on Server Address?

    Did you also add permission Sets like Super to user?

  • Community Member Profile Picture
    on at

    Thanks for fast reply

    When I press tab on server address I can see the address to another service which works fine. When choosing the other service I get to choose between 4 different companies in another database

    When creating the user I used the following line in the ADM shell:

    New-NAVServerUser nav8 -UserName Chris -Password (ConvertTo-SecureString 'Password1234' -AsPlainText -Force)

  • Suggested answer
    Mohana Yadav Profile Picture
    61,003 Super User 2025 Season 2 on at

    so you are not using Windows logins?

    for now please try to delete records from users table and Access Control and User Property from SQL

  • Community Member Profile Picture
    on at

    No I am not using windows logins.

    I am not sure what you meant in your previous post, but I think the problem lies in the fact that the new user have not received any permissionsets. How do I grand the permission set SUPER via ADM powershell?

  • Verified answer
    Mohana Yadav Profile Picture
    61,003 Super User 2025 Season 2 on at

    Please check this link

    msdn.microsoft.com/.../jj672890(v=nav.71).aspx

  • Community Member Profile Picture
    on at

    The issue is solved

    Copied the users ID from user table to access controle and granted permission SUPER and it works just fine now. will check out the link on how to do it via shell

    Thanks for the help!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans