Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

MS Dynamics 2016 on premise Set up

Posted on by 10

Hello,

We want to install the MS dynamics crm 2016 on premise to our company.

Due to the security norms we can not provide local admin rights for sql server installation.

What could be the possible solutions for that? How can we solve or find a workaround regarding this issue?

Thanks,

Salih

*This post is locked for comments

  • Suggested answer
    Salih Profile Picture
    Salih 10 on at
    RE: MS Dynamics 2016 on premise Set up

    Many Thanks for your answer.

    And also what is the impact of local admin user on the sql database? If the user has no crucial impact like changing something on program files etc., we can give the rights just for the installation.

    Then the local admin should be needed permanently?

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,304 User Group Leader on at
    RE: MS Dynamics 2016 on premise Set up

    Hi Salih, you can use the following minimum privileges to install;

    The user account used to run Microsoft Dynamics 365 Server Setup that includes the creation of databases requires the following minimum permissions:

    •Be a member of the Active Directory Domain Users group. By default, Active Directory Users and Computers adds new users to the Domain Users group.

    •Be a member of the Administrators group on the local computer where Setup is running.

    •Have Local Program Files folder read and write permission.

    •Be a member of the Administrators group on the local computer where the instance of SQL Server is located that will be used to store the Microsoft Dynamics 365 databases.

    •Have sysadmin membership on the instance of SQL Server that will be used to store the Microsoft Dynamics 365 databases.

    •Have organizational unit and security group creation and add membership permission to those groups in Active Directory. Alternatively, you can use a Setup XML configuration file to install Microsoft Dynamics 365 Server when security groups have already been created. For more information, see Use the command prompt to install Microsoft Dynamics 365 Server 2016.

    •If Microsoft SQL Server Reporting Services is installed on a different server, you must add the Content Manager role at the root level for the installing user account. You must also add the System Administrator Role at the site-wide level for the installing user account.

    technet.microsoft.com/.../hh699825.aspx

    Best Wishes, Raz

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