Skip to main content

NAV 2013 R2 - How to Login in a Database Which have NO Companies?

Hi all,

This post can also be used for NAV 2013 R2 - Creating New Companies in Database From Cmdlets.

With Release of NAV 2013 R2, we can create database from the Developer Environment but there is no option of creating company from Developer Environment.

Due to this we have so many issues as Role Tailored Client will not open until there is a company in the database. One of the issues is discussed below with resolution.




Suppose i received Only Objects from my Client For NAV 2013 R2. I imported same By Creating a New Database From Developer Environment.

I created the service for the same as shown below.



Now i tried to open Role Tailored Client For same, but i cannot get in because there are no companies in Database as shown below.



Let's see how we can create Company for getting access to the Windows (Role Tailored) Client.

Steps -

1. Open Powershell ISE as Administrator. How to Open ISE

2. Run the Below Listed Command to Create A company in the Database.

-----------------------------------------------------------------
#Prepare PowerShell
Set-ExecutionPolicy unrestricted -Force
Import-Module 'C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1'

#Create Company with Name Demo Company and Instance DynamicsNAV71
New-NAVCompany -CompanyName "Demo Company" -ServerInstance DynamicsNAV71 -Confirm
-----------------------------------------------------------------

The Above command will create a Company "Demo Company" in the database Mapped to Service Instance DynamicsNAV71.

Change these two Parameter as per your requirement.

Click F5 to Run the Command. It will ask for Confirmation for Creating Company Select Yes.



Once you see completed in Status Bar as shown below that means company is created.



Now lets try to open the Windows Client.



So we can now get access to the Windows Client. Now the First task is to create your user in database with Super Rights.

I hope you find the post usefull.


Regards,
Saurav Dhyani
saurav-nav.blogspot.com

Comments

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searchi...

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.