Connect SQL 2012 with Microsoft Dynamic NAV 2013

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (1)

Roberto Stefanetti 12,998 on at

Like (0)

Report
Copy link

Link copied!

hi,

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

Was this reply helpful? Yes No
Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No