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

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

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 - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.