web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM 2015 Installation ...
Microsoft Dynamics CRM (Archived)

CRM 2015 Installation Problem Connecting to SQL 2012 R2

(0) ShareShare
ReportReport
Posted on by ACECORP 1,589

I am trying to install CRM 2015 but am getting a very strange error as shown below.

SQLIssue.png

For the life of me I cannot figure this out. I checked the crmserversetup.log and found only 1 line of relevance which is 15:01:55|  Error| Check SqlServerValidator : Failure: Could not connect to the following SQL Server: 'CRM2015DEV\DEVCRM'. Verify that the server is up and running and that you have SQL Server administrative credentials. Login timeout expired

I pasted that line along with the lines above and below it for review below. CRM and SQL are on the same server and there is no firewall involved. Any help would be appreciated.  

15:01:39|   Info| Check IncomingExchangeServerValidator: Success
15:01:39|   Info| Check IfdSettingsValidator: Success
15:01:39|   Info| ClaimsEncryptionCertificateValidator linking to help topic: html/379e429f-2485-4a15-9e18-3672eccc5748.htm 
15:01:39|   Info| ClaimsEncryptionCertificateAccessValidator linking to help topic: html/379e429f-2485-4a15-9e18-3672eccc5748.htm 
15:01:39|   Info| Check ServerClaimsEncryptionCertificateValidator: Skipped
15:01:39|   Info| Group Internet Information Services (IIS)
15:01:39|   Info| Check IIsInstalledValidator: Success
15:01:39|   Info| Check IisAdminServiceValidator: Success
15:01:39|   Info| Check W3svcServiceValidator: Success
15:01:39|   Info| Check NTAuthenticationProvidersValidator: Success
15:01:39|   Info| Group Microsoft SQL Serverâ„¢
15:01:39|   Info| Check SqlServerAgentValidator: Success
15:01:39|   Info| Check SqlInstanceNameValidator: Success
15:01:39|   Info| Check CrmSqlDomainValidator: Success
15:01:55|  Error| Check SqlServerValidator : Failure: Could not connect to the following SQL Server: 'CRM2015DEV\DEVCRM'. Verify that the server is up and running and that you have SQL Server administrative credentials. Login timeout expired

15:01:55|   Info| Group Microsoft SQL Server Reporting Services
15:01:55|   Info| Check ReportingUrlValidator: Success
15:01:55|   Info| UrlAccessValidator linking to help topic: html/01f421a9-da60-4d47-a06a-75550ee94430.htm 
15:01:57|   Info| Check ExistingRSValidator: Success
15:01:57|   Info| Group Active Directory®
15:01:57|   Info| Check DomainUserValidator: Success
15:01:57|   Info| Account network name: DEV\ZZ_CRMSANDBOX
15:01:57|   Info| Account distinguished name: CN=CRM Sandbox Processing Service,OU=DynamicsCRM,DC=dev,DC=local
15:01:57|   Info| Check SandboxServiceSettingServicePrincipalNameValidator: Success
15:01:57|   Info| Account network name: DEV\ZZ_CRMASYNCPRO
15:01:57|   Info| Account distinguished name: CN=CRM Asynchronous Processing Service,OU=DynamicsCRM,DC=dev,DC=local
15:01:57|   Info| Check AsyncServiceSettingServicePrincipalNameValidator: Success
15:01:57|   Info| Check WebBasedServiceSettingServicePrincipalNameValidator: Skipped
15:01:57|Verbose| Validation ran.
15:01:57|Verbose| Validation completed.
15:01:57|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
15:01:57|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
15:01:57|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
15:01:57|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear


*This post is locked for comments

I have the same question (0)
  • ACECORP Profile Picture
    ACECORP 1,589 on at

    I forgot to mention that I can connect to SQL without incident using SQL management studio so its not my credentials or rights.

  • Community Member Profile Picture
    Community Member on at

    Taken from CRMIGv6_Planning.docx

    Minimum permissions required for Microsoft Dynamics CRM Setup and services

    The user account used to run Microsoft Dynamics CRM 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 CRM databases.
    • Have sysadmin membership on the instance of SQL Server that will be used to store the Microsoft Dynamics CRM databases.
    • Have organization and security group creation permission in Active Directory. Alternatively, you can use a Setup XML configuration file to install Microsoft Dynamics CRM Server 2013 when security groups have already been created. For more information, see Use the Command Prompt to Install Microsoft Dynamics CRM in the Installing Guide.
    • 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.

    nichi

  • Suggested answer
    ACECORP Profile Picture
    ACECORP 1,589 on at

    I was able to solve the problem by changing the setting shown below from no to yes.

    fix.png

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans