web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Not recognizing new sq...
Microsoft Dynamics NAV (Archived)

Not recognizing new sql instance in Dynamics NAV

(0) ShareShare
ReportReport
Posted on by Martinho Costa 779

I have instaled nav 2016 and SQL Server 2012 SP2 (since is the basic requirement and I need to provide BD's in this version to my partners). In the SQL Server 2012SP2 installation I have created a named instance like NAVSQL\XXX.

I managed to restore a Demo Database 9-0 but once I try to open the respective SQL instance in the development environment I get the following error message: The NAVSQL\XXX server cannot be found. Try again later or contact your system administrator.

What am I missing?

Thanks in advance

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Martinho,

    Did you check the SQL permissions and SQL service status?

    Regards.

  • Suresh Kulla Profile Picture
    Suresh Kulla 50,251 Super User 2025 Season 2 on at

    Is development environment installed on the same server, if so can you lookup the server instance you created ?

  • Verified answer
    Martinho Costa Profile Picture
    Martinho Costa 779 on at

    Problem solved by adding a specific user in the database logins used for the service account.

    thank you both

  • keoma Profile Picture
    keoma 32,729 on at

    please set your own answer as verified and also the answer(s), which helped you to solve your issue.

  • AnuV Profile Picture
    AnuV on at

    Martinho, 

    You indicated that you resolved this issue by adding a database login. Can you provide me with specific instructions on how this can be achieved?

    Thanks,

    Anu

  • Martinho Costa Profile Picture
    Martinho Costa 779 on at

    My service was not using network service on the account but a normal user. just had to add that specific user to the database logins.

  • AnuV Profile Picture
    AnuV on at

    Hi Martinho, Can you please elaborate on where you added thecdatabase logns. If you can provide step by step instructions that wouldbe great. Really appreciate your help.

    Thanks,

    Anu

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans