Skip to main content

Notifications

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) / Problems with creating...
Microsoft Dynamics NAV (Archived)

Problems with creating Company via PowerSehell

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I had problems with nav2016. We think it is caused by the demo database we started with as base for production database. So I create a new database in the Development Environment. After that I wanted to create a new company . I cannot create a new company via the client because I cannot login there. I think it misses some objects. So I used the powershell cmdLet command:

New-NAVCompany -ServerInstance DynamicsNAV90B -CompanyName OURCOMPANY

This gives an error:

New-NAVCompany  : The following SQL error was unexpected:
Invalid object name 'dbo.$ndo$tenantproperty'.

et. etc.

So I think this is not the way to create a 'clean' start database or I do something wrong.

Can somebody give me a good hint?

Thanks,

Patrick

New-NAVCompany -ServerInstance DynamicsNAV90 -Tenant CRONUS -CompanyName 'CRONUS Subsidiary'

*This post is locked for comments

  • Krupesh Profile Picture
    Krupesh on at
    RE: Problems with creating Company via PowerSehell

    Hi Patrick,

    After we finished upgrading all objects from NAV 2013 R2 to NAV 2016 and resolving conflicts we were getting the error The following SQL error was unexpected: Invalid object name 'dbo.$ndo$tenantproperty'. We used the Sync Schema for all tables as mentioned in your mail and the error is now resolved.

    Thank you for posting the solution it helped us in resolving the issue.

    Regards,

    Krupesh Daiya

    Mumbai, India.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Problems with creating Company via PowerSehell

    Hi,

    The problem is solved by starting 'Sync. Schema for all tables' in development environment. After that creating of company via Powershell was successful.

    Thanks.

  • aavio Profile Picture
    aavio 895 on at
    RE: Problems with creating Company via PowerSehell

    Please try to import a valid license to app database and restart nav server instance.

  • Community Member Profile Picture
    Community Member on at
    RE: Problems with creating Company via PowerSehell

    Check via SQL Dev Env the presence of dbo.$ndo$tenantproperty table in your db.

    Check also login account permission of nav service 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans