Skip to main content

Error After Restore SQL Backup of NAV 2013 Database

Hi all,

we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013.

While Trying to run object from Object Designer we get below listed error (even the service is configured properly) -
---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
There are 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.
---------------------------
OK   
---------------------------





While Trying to Run The Role Tailored Client we get below listed error -

---------------------------
Microsoft Dynamics NAV
---------------------------
A fatal error occurred. The connection to SQL server cannot be established or is no longer usable. This can be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* The SQL server connection settings are not correct
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.
Try again later or contact your system administrator.
---------------------------
OK   
---------------------------

Resolution -

To resolve these error open SQL Server Management Studio.
Go to Security and open Login Folder.
Go to Properties of User - NT Authority\Network Service as shown below.

From the left panel select User Mapping.
Place a check mark on the database that you want to access in my case there are two databases as shown below.


I will put a check mark on the Map for these two databases.
In default schema i will select $ndo$navlistener as shown below.


Remember to select following role for the user in Database -
  db_datareader
  db_datawriter
  db_ddladmin

as shown below -

Click OK and restart the service.

The issue is resolved.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Comments

  1. http://blogs.msdn.com/b/nav/archive/2012/10/03/manually-restoring-the-nav-2013-demo-database.aspx

    http://www.mibuso.com/forum/viewtopic.php?f=32&t=55197
    Hi saurav above links may be useful for the readers.

    ReplyDelete
  2. Hello Saurav,

    Thank you for your information.

    i tried to install three tiers also (navsql, navserver, and navclient) and i encountered similar errors. I am using the network services. Have tried your solution , but still it said

    Microsoft Dynamics NAV
    ---------------------------
    A fatal error occurred. The connection to SQL server cannot be established or is no longer usable. This can be caused by one of the following reasons:
    * The server has been shut down manually or because of an error.
    * The SQL server connection settings are not correct
    * A network failure has occurred.
    * A hardware failure has occurred on the server or on your computer.
    Try again later or contact your system administrator.
    ---------------------------
    OK

    i really get stuck here .

    Can you please check my post : http://www.mibuso.com/forum/viewtopic.php?t=56892

    Thank you for you help.

    ReplyDelete
  3. Thanks Saurav .. It was a great Help ..!!

    ReplyDelete
  4. The information you’ve shared in this article is great and informative. Keep writing! You can visit our article API Integration Services and share your feedback with us.

    ReplyDelete

Post a Comment

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Dynamics 365 Business Central 2021 release wave 2 (BC19) Released.

Hi Readers, As we all were expecting Microsoft have Released Business Central 2021 Release Wave 2 Today a.k.a BC19. In this article we will see what all is announced with the General Availability.  Starting Today Customers & Partners can start using Business Central 19. #msdyn365bc #bc19