Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Connect SQL 2012 with Microsoft Dynamic NAV 2013

Posted on by Microsoft Employee

Hello Friends,

Thanks for your supports, I installed Microsoft SQL 2012 in a computer along with Dynamic NAV 2013 I want to connect to create database in SQL server I did the installation based on this guide https://msdn.microsoft.com/en-us/library/dd355184(v=nav.70).aspx how to do to work I need it urgent.?

best regards,

*This post is locked for comments

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Connect SQL 2012 with Microsoft Dynamic NAV 2013

    you can restore the sql backup into the new sql server using smss tool.

    after that it's you should set the needed sql rights for all users, which need access to the database, at least the nav service account, with which the nav service is run. give that user the dbowner right. after that start nav service management console and edit the properties of the nav service instance you want to change the database or create a new one for the new database. set the needed values and start the service.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Connect SQL 2012 with Microsoft Dynamic NAV 2013

    Hello Robert,

    I appreciate your reply and support we have already setup Microsoft Dynamic NAV 2013 with SQL Server 2012 in one server hardware one of company did now we have plan to setup backup server to be available as spare and redundant  I installed SQL 2012 successfully also I installed Microsoft Dynamic 2013 in same hardware server now I want to connect SQL database with Microsoft Dynamic to start work and I want to import my current server backup to be run.

    looking for support.

    Best wishes

    Nematullah

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Connect SQL 2012 with Microsoft Dynamic NAV 2013

    Hello SK,

    I appreciate your reply and support we have already setup Microsoft Dynamic NAV 2013 with SQL Server 2012 in one server hardware one of company did now we have plan to setup backup server to be available as spare and redundant  I installed SQL 2012 successfully also I installed Microsoft Dynamic 2013 in same hardware server now I want to connect SQL database with Microsoft Dynamic to start work and I want to import my current server backup to be run.

    looking for support.

    Best wishes

    Nematullah

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Connect SQL 2012 with Microsoft Dynamic NAV 2013

    Hi Mahesh,

    greeting , I want to install Microsoft Dynamic NAV 2013 with SQL 2012 from scratch I created DB in SQL and also I installed Dynamic NAV but not make connection to run in client.

    looking for reply.

    best wishes

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Connect SQL 2012 with Microsoft Dynamic NAV 2013

    Hi,

    Do you mean that you want to create the database from SQL Server Management Studio?  or you want to open the new database from NAV?

    Please specify your requirement.

  • Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Connect SQL 2012 with Microsoft Dynamic NAV 2013

    Hello,

    When you post the question please try to send more details and specify you requirement or issue you are facing and one other thing using urgent does not get more attention, this is a forum.

    Thank you for understanding.

  • Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Connect SQL 2012 with Microsoft Dynamic NAV 2013

    hi,

    what do you need ?  NAV Serevr doesn' t connect to SQL Server?

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans