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

Notifications

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) / Microsoft Dynamics CRM...
Microsoft Dynamics CRM (Archived)

Microsoft Dynamics CRM 2013 - Installation Issue on Windows server 2008 R2 SP1

(0) ShareShare
ReportReport
Posted on by Sheik mohamed 280

Hello there,

I have been experiencing problems when during CRM 2013 install on Windows server 2008 R2 SP1.

Installation failed due to below error outlog:

SQLexception during install CRM config db action. Cannot perform this action when SQLServer agent is starting. Try again later.

I came across a Microsoft support forum post saying DTC transaction fails when Sql server is running is fiber mode (light weight pooling). when I checked the sql server properties -> Processers, Use windows fiber mode option is unchecked.

Any help with this is very much appreciated! Thank you very much for helping with this.

Thank you, Sheik

*This post is locked for comments

I have the same question (0)
  • Sheik mohamed Profile Picture
    Sheik mohamed 280 on at

    Dear all, Can you please help?

    Thank you,

    Sheik

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    DTC problem mainly causes for port or firewall block, check your port/firewall.

  • Sheik mohamed Profile Picture
    Sheik mohamed 280 on at

    Dear mn_mak,

    Thank you very much for your suggestion. I checked allowable programs through windows firewall and noticed DTC unchecked. I checked it, restarted and tried installing CRM 2013 again. No luck this time around! Please find the failure screenshot below. 

    Any help further would be appreciated.

    Thanks for help,

    Sheik

  • Community Member Profile Picture
    Community Member on at

    ASAK Sheik

    can you attach screeshot?

    Mohideen Kader

  • Sheik mohamed Profile Picture
    Sheik mohamed 280 on at

    Alaikum Salam Mohideen Kadar,

    Sorry I could get you the screenshot now. But here is what it says.

    CRM setup failed during CRMconfig db installation:

    SQLexception during install CRM config db action. Cannot perform this action when SQLServer agent is starting. Try again later.

    Thanks for your help.

    -Sheik

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    ASAK

    it is more generic exception,  look at both crm/db server  event viewer, may be you will get some idea about the exception.

    Check the blog

    dynamics-crm2011.blogspot.com/.../how-to-install-microsoft-dynamics-crm.html

  • Sheik mohamed Profile Picture
    Sheik mohamed 280 on at

    Dear Mohideen,

    Here is the error from crmserversetup logs..

    21:53:52|  Error| Check SqlInstanceNameValidator : Failure: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Thanks,

    Sheik

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    1)Enable Remote connections

    a)Right-click on the SQL Server Management Studio (instance) -> select "Properties" from the menu - > Select "Connections" -> Enable check box "Allow remote connections to this server". -> Restart the instance.

    b)optional Right-click on the SQL Server Management Studio -> select "Facets" from the menu - > Select "Surface Area Configuration" from the Facet drop down -> RemoteDacEnabled to True

    2)Use a domain account as a service account.

    3) Create a firewall exception for the SQL Server instance and port

    (Windows Server 2008 R2) Control Panel -> Windows Firwall -> Advanced Settings -> Select Inbound Rules -> Action menu -> select New Rule -> Select Custom -> Add the sqlservr.exe (program path)  and TCP protocal type,port (default is 1433)

    4)Check SQL server services(SQL Server ,SQLBrowser,..) is up and running properly

    5)Run "sqlcmd -L", check your server is included in your network list.

    6)Enable TCP/IP in sql server configuration

    7)SQL server connectivity

    Run > cmd

    •netstat -ano| findstr 1433

    •telnet SQLSERVER_NAME_OR_IP_ADDRESS 1433

    •ping -a SQLSERVER_NAME_OR_IP_ADDRESS

    I am sure there is a firewall/port  issue in  your configuration

  • Sheik mohamed Profile Picture
    Sheik mohamed 280 on at

    Dear Mohideen,

    Thanks for your suggestions. Tried all the steps except using domain account as service account. Used Network service account for Sql service. Problem still persists!

    On 3rd section what you have mentioned, I did create only firewall inbound rule for only port. Do you think if i try to do so for sql instance also, problem goes away?

    3) Create a firewall exception for the SQL Server instance and port

    (Windows Server 2008 R2) Control Panel -> Windows Firwall -> Advanced Settings -> Select Inbound Rules -> Action menu -> select New Rule -> Select Custom -> Add the sqlservr.exe (program path)  and TCP protocal type,port (default is 1433)

    I am not sure what else is causing this! Please help.

    Best,

    Sheik

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Look like your  "Use Windows fibers(lightwight pooling" may cause this error.

    i am not sure why do you enabled this setting, it is one of dangerous in sql server.

    some ms kb article will help you?

    smallbusiness.support.microsoft.com/.../303287

    smallbusiness.support.microsoft.com/.../319942

    technet.microsoft.com/.../ms191506%28v=sql.105%29.aspx

    technet.microsoft.com/.../ms178074.aspx

    keerthikiran.weebly.com/.../understand-use-windows-fibers-light-weight-pooling-when-configuring-sql-server.html

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans