Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

How to install CRM with connection to SQL server and Active Directory?

Posted on by 285

I'm trying to install CRM 2015 in the following infrastructure:

  1. CRM resides on server 1
  2. SQL database resides on server 2
  3. Active Directory (AD) resides on server 3

I am loosely following this guide, however, it doesn't take into account connectivity between multiple servers.

  • I have set up the active directory with its server configured as the domain controller, as per the guide. 
  • All 3 servers have joined the same domain.
  • I've installed the SQL Server software and attempting to install the CRM using the Administrator user that was created by default in the AD.
  • SQL Server (with reporting) is installed as per the instructions in the guide.

CRM is having problems with installation. Specifically, it can't detect that the SQLSERVERAGENT service is running and it can't connect to the remote SQL reporting server.

This seems like a basic 3, and likely close to best practice, server configuration for the CRM components, but I haven't found any detailed guides for this particular structure. Specifically guides that include the permission and networking steps.

Are there any guides that you know of that would help me with the connectivity aspect for this installation?

This piece of info may change the requirements a bit: I'm trying to install these servers on AWS as separate instances. 

I did find this article on required ports, but I did try a Windows Firewall and AWS Security Group configuration that allowed all ports, and the problems I've mentioned were not resolved.

*This post is locked for comments

  • Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: How to install CRM with connection to SQL server and Active Directory?

    What kind of connections are you allowing between your CRM Server and SQL Server?

    In SQL Server Connection Manager - Do you have both TCP/IP and NetBios configured?

    That might be an issue with SQL Server agent.

    What user account did you use for authentication: NETWORK SERVICE or Domain Account?

    I would verify the accounts have the appropriate permissions.

    Hope this helps.

  • Artemy Profile Picture
    Artemy 285 on at
    RE: How to install CRM with connection to SQL server and Active Directory?

    I have SSRS configured on my SQL Server. I'm limited to 3 servers for this installation, so SSRS will have to be on the SQL Server. I am able to access the Report Server URL from within the SQL Server, but not from the CRM Server. This makes me think that the issue is either with Administrator user permissions or ports.

  • Suggested answer
    Wayne Walton Profile Picture
    Wayne Walton 13,726 on at
    RE: How to install CRM with connection to SQL server and Active Directory?

    All CRM installs assume multiple systems for SQL, AD, and the CRM front-end.  that's just how it's installed.  It sounds like you might not have an SSRS server set up, though.  Do you have SSRS configured on your SQL server?  You'll need to, if you haven't (you could also install it on its own server, if you want).

    As to networking steps, there really isn't anything special.  If they're on the same network, and you're going to use one domain, the CRM install should be able to find anything you need.  If you've heavily firewalled the AD or SQL servers, you're going to need to look here to verify your open ports: technet.microsoft.com/.../hh699823.aspx

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans