NAV Server instance error

domela · February 20, 2015, 6:44am

I am using NAV 2013 R2.I have a database named “NAVLIVEDB”. It iw working fine and the instance is as follows :

Database instance : CIMFINSQL

Database Name : NAVLIVEDB

Database Server : SQLSVR

Port number 7045-7048

I did a backup of that database and restore it as “NAVTESTDB”. I did create the instance with the following details:

Database instance : CIMFINSQL

Database Name : NAVTESTDB

Database Server : SQLSVR

Port number is 7055-7058

The instance is running fine

The NAV Development environment runs fine. But when I want to open a table from the DEvelopment Application, I get the following error message :There is no NAV server instances available for this database. You must ensure that a NAV server instance is running and is configured to use the database before you perform this activity.

I did restart the instance and again the same problem.

Important: On NAV Development applicaiion, when I go to File->Database->Information, the filed server instance is blank. Can you please help.

Regards

Domela

geordie986 · February 20, 2015, 7:26am

In the dev. env. did you set the server instance and company name into the Tools → Option menu?

domela · February 20, 2015, 12:29pm

I did it. Does not work

May be I am doing it wrongly. Can you please help me?

Akil_Reddy · February 20, 2015, 1:23pm

Can u please Check the Registery Editor…

domela · February 20, 2015, 1:54pm

Can you please tell me how to check the registry editor?

Thanks

domela · February 20, 2015, 1:56pm

And what should I check in the registry editor

Regards

Akil_Reddy · February 23, 2015, 12:26pm

In Registry Edit --------->DYnamics NAV----------->Shell--------->Command------------->Check Below Format

C:\Program Files (x86)\Microsoft Dynamics NAV\60\RoleTailored Client\Microsoft.Dynamics.Nav.Client.exe “%1”

suraj92291 · February 24, 2015, 9:13am

What is the name of your NAV server instance ???
Is it running??

You didn’t mention in your question.

Regards,

Suraj

geordie986 · February 25, 2015, 7:42am

Can you check via SQL if the table Server Instance contains any records?
Restoring a db sometimes can cause this table to be empty: in this case stopping the NST and restarting should be enough.

mahesh_mahi · February 25, 2015, 1:06pm

Can you Please Repair the sql server once and restart both nav and sql server instance and then try…

domela · March 3, 2015, 7:17am

Mu nav server instance is as follows:

DYNAMICSNAV71 for the original database.

Then I made a copy of this database and create a new instance which is known as CIMTEST

Both are running

Regards

Domela

domela · March 3, 2015, 7:27am

Can you please tell me how to repair the database?

Regards

suraj92291 · March 3, 2015, 10:34am

Hi,

Open your “Microsoft Dynamics NAV 2013 R2 Administration” and make sure that you had properly filled up

Database Instance

Database Name

Database Server

details for your NAV server instance.

e.g. I have recreated your error in my system by just changing my database name(Please find attachment).

Regards,

Suraj

spyroot · November 25, 2015, 8:57pm

Hi Daniele,

The table (Server Instance) should be inside my NAV database? The name that I should look is “Server Instance”?

Raja123 · November 27, 2015, 7:05am

Hi Domela,

Please follow these steps,

Open your Development Environment and open ur database (Say generally Demo database (8-0)).

File—Database—>Open — Ur Database.

2.File----->Database—>Information.

you will find Server instance field is empty in General Tab…If Empty then goto Step 3 [:P]

3.Now goto Tools ----Options---->Enter ur i. Server name ii.Instance ,iii.port iv. Management port .v. if ur using multi tenant then tenant

Regards,

Raja Venkat.