Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Connection --> No a...
Microsoft Dynamics NAV (Archived)

Connection --> No available companies

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Connection --> No available companies

    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!

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,137 Super User 2024 Season 2 on at
    RE: Connection --> No available companies

    Please check this link

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Connection --> No available companies

    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?

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,137 Super User 2024 Season 2 on at
    RE: Connection --> No available companies

    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
    Community Member Microsoft Employee on at
    RE: Connection --> No available companies

    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
    Mohana Yadav 59,137 Super User 2024 Season 2 on at
    RE: Connection --> No available companies

    What is happening when you press tab on Server Address?

    Did you also add permission Sets like Super to user?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans