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

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

(0) ShareShare
ReportReport
Posted on by ratiusv 105

Hello,

I have 2 servers: 1 for the Crm2016 FullServer and 1 SqlSqerver

I try to install CRM2016 and everything works fine until the System Checks.

Then, I get this error while checking "Microsoft SQL Server". Microsoft SQL Server version = 11.0.6020.0.

After around 60 seconds of "checking" the "Microsoft SQL Server" and after creating the database MSCRM_CONFIG on the SqlServer machine, I get the Timeout error twice.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The wait operation timed out

The MS Sql Server Reporting Service is also not found (although it is installed on the same SqlSqrver and the link I have provided for it is the right one.

After all these errors, the MSCRM_CONFIG database is removed.

Could anyone please reach me a helping hand?

*This post is locked for comments

I have the same question (0)
  • ratiusv Profile Picture
    ratiusv 105 on at

    In the SqlServer I found this Error:

    2016-09-01 09:51:59.71 Logon       Login succeeded for user 'XXX'. Connection made using Windows authentication. [CLIENT: XX.XX.XX.XX]
    2016-09-01 09:52:00.01 spid57      Error: 17204, Severity: 16, State: 1.
    2016-09-01 09:52:00.01 spid57      FCB::Open failed: Could not open file E:\SQLServer_INSTPCH1\MSCRM_CONFIG.mdf for file number 0.  OS error: 2(The system cannot find the file specified.).
    2016-09-01 09:52:35.14 Logon       Login succeeded for user 'XXX'. Connection made using Windows authentication. [CLIENT: XX.XX.XX.XX]
    2016-09-01 09:52:35.15 spid60      Error: 17204, Severity: 16, State: 1.
    2016-09-01 09:52:35.15 spid60      FCB::Open failed: Could not open file E:\SQLServer_INSTPCH1\test_MSCRM.mdf for file number 0.  OS error: 2(The system cannot find the file specified.).

    I have uninstalled the Antivirus but the same error pops up again and again :(

  • ratiusv Profile Picture
    ratiusv 105 on at

    and on the SQL Server side I found that this command fails:

    exec sp_executesql N'EXEC sp_attach_db @dbname = @databaseName, @filename1 = @dbFile, @filename2 = @logFile;',N'@databaseName varchar(30),@dbFile nvarchar(260),@logFile nvarchar(260)',@databaseName='17581e24fe4cea8e3ac6963e18bd13',@dbFile=N'E:\SQLServer_INSTPCH1\MSCRM_CONFIG.mdf',@logFile=N'E:\SQLServer_INSTPCH1\MSCRM_CONFIG_log.ldf'

  • Suggested answer
    Tushar2016CRM Profile Picture
    Tushar2016CRM 1,130 on at

    hi ,

    kindly check if there is enough disk space available in the partition where u are trying to install SQL DB.

    Also the priviledge for the sql account which you have configured for the same.

  • ratiusv Profile Picture
    ratiusv 105 on at

    1. There is more than enough free space ... over 100G

    2. The MSSQL$INSTPCH1 has FULL access on both mdf path and ldf path (they are saved on separate drives: mdf on E: and ldf on F: ).

    Could it be perhaps the windows firewall?

    I cannot turn it off by myself - I do not have enough rights. But I have already asked the team to turn it off for this test system.

    Are there any other ideas that I could use?

  • Suggested answer
    Tushar2016CRM Profile Picture
    Tushar2016CRM 1,130 on at

    HI ,

    Please check few of the pre requisites mentioned on the below link if they might help

    technet.microsoft.com/.../hh699671.aspx

    Thanks

  • ratiusv Profile Picture
    ratiusv 105 on at

    I have double checked everything...

    Windows Server 2012 R2 Standard

    Services Running:

    - IIS Admin Service

    - Net.Tcp Port Sharing Service

    - World Wide Web Publishing Service

    - Indexing Service - installed from Server features - Windows Search Service

    - MDAC version 6.0.6020.0 - read from HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer

    - ASP.NET 4.5 installed from Server features

    Microsoft® SQL Server® 2012 Service Pack 3 (SP3)    11.0.60.20.0

    - Running service: SQL Server Agent service

    - SQL Server full-text indexing - installed from SqlServer install kit

    - SQL word breakers ???? --- is not needed if everything is installed in english.

    And it still does bring up the same error :(

  • Verified answer
    ratiusv Profile Picture
    ratiusv 105 on at

    Hello all,

    I finally found out the real blocker.

    It seams that when CRM makes his final checks, prior to the installation of crm2016, it really creates the databases files MSCRM_CONFIG and myOrg_MSCRM, without attaching them to the database. Then  these are removed.

    The problem was that the default size of the to be created database was set to 1024M for both MDF and LDF files.

    On my VM, it takes usually 20 second to create a database with these initial values.

    Unfortunatly, on the server, starting Management Studio, a blank database was created in 2 minutes !!!!!!!! ::(((((((

    This is now being discussed in order to improve the performance, but this is another issue ....

    Now, I had to find out how to decrease the default database creation size.

    After asking bing, I found out that every new database copies the initial properties from the "model" database.

    There I have change the initial size to 300M for both MDF and LDF and ... surprise .... everything works fine now.

    No timeout any more.

    Have a wonderful CRM life!

    Regards,

    Sorin

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