Book Image

Mastering Microsoft Dynamics NAV 2016

By : Rabindra Sah
Book Image

Mastering Microsoft Dynamics NAV 2016

By: Rabindra Sah

Overview of this book

The book begins by giving you a brief introduction to setting up your NAV environment and shows you how to install and configure it according to your requirements. You will then dive deep into the latest design patterns, network architecture, and topologies. We will show you how you can integrate NAV with the Microsoft platform, and secure your deployment by managing roles and permissions. Moving on, we will explain how to monitor and manage server instances using the Administration tool. We’ll discuss how you can take advantage of the expanded extensibility and connectivity capabilities for a tighter integration with the cloud as well as handheld devices. Then, we’ll show you how you can make use of the PowerBI capabilities that have been built into Dynamics NAV. By the end of the book, you will be confident in developing and administering a Dynamics NAV implementation that will leverage all of the new features.
Table of Contents (19 chapters)
Mastering Microsoft Dynamics NAV 2016
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

SQL Server security settings


Microsoft Dynamics NAV 2016 can run on the SQL Server, and smaller installations can also run on SQL Server Express. It is vital to understand the requirements of the client in the first place. It is recommended to use the following steps to help increase SQL Server security:

  • Always make sure that the latest operating system and SQL Server service packs and updates are installed.

  • For filesystem-level security, make sure all SQL Server data and system files are installed on NTFS partitions. Also make sure to make the files accessible only to administrative or system-level users through NTFS permissions. It safeguards against users trying to access those files when the MSSQLSERVER service is not running.

  • Use a low-privilege domain account such as NT AuthorityNetwork Service (recommended), or the local system account for the SQL Server service (MSSQLSERVER or SQLEXPRESS). This account should have only local user-level permissions in the domain.

  • Most editions of SQL...