locked
microsoft.crm.setup.server.grantconfigdbdatabaseaccessaction failed - timeout expired RRS feed

  • Question

  • Having Microsoft Dynamics 2016 CRM Server installation issues.

    "Action microsoft.crm.setup.server.grantconfigdbdatabaseaccessaction failed.  timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.  The wait operation timed out."

    This error happens near the end of the install.  Earlier stages show full connectivity with 2014 SQL Server Enterprise box.

    I've read and done all the "close SSMS" and "don't have an RDP session open to the SQL Server box" and looked around in SSMS user privs, etc. and am at a loss on how to fix this.  My next move is to go research timeout settings, etc.  

    Exchange Server 2016 has also been installed successfully on this box.

    Please help.





    • Edited by setld Sunday, February 7, 2016 8:11 PM
    Sunday, February 7, 2016 8:08 PM

All replies

  • 13:30:53|  Error| System.Exception: Action Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction failed. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
       --- End of inner exception stack trace ---
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
       at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
       at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.DatabaseInstaller.Common.SharedDatabaseUtility.CreateLogin(CrmDbConnection connection, String user, Boolean enableTrace)
       at Microsoft.Crm.DatabaseInstaller.Common.SharedDatabaseUtility.GrantDBDboAccess(String sqlServerName, String databaseName, String user, CrmDBConnectionType connectionType)
       at Microsoft.Crm.DatabaseInstaller.Common.SharedDatabaseUtility.GrantDBAccessHelper(String sqlServerName, String databaseName, String groupName, CrmDBConnectionType connectionType)
       at Microsoft.Crm.DatabaseInstaller.Common.SharedDatabaseUtility.GrantDBAccess(String sqlServerName, String databaseName, String groupName, CrmDBConnectionType connectionType)
       at Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    13:41:02|   Info| InputResult: Retry
    13:41:02|   Info| CrmAction execution time; GrantConfigDBDatabaseAccessAction; 00:13:31.9406708


    • Edited by setld Tuesday, February 9, 2016 4:02 AM
    Tuesday, February 9, 2016 4:02 AM
  • Did you "get the latest updates" for the installation?

    If you check your SQL Server, which databases has been created? Is the MSCRM_CONFIG database created? Is the SQLAccessGroup added as a login in in the SQL Server instance?

    Try and run this query to see if the group is added (will list the names of all the groups added, 'G' is Windows/AD Group):

    SELECT name
    FROM sys.server_principals 
    WHERE TYPE = 'G'
    Tuesday, February 9, 2016 8:54 AM
  • Hi,

    Do you have any errors in the logs on the SQL machine? Either in the Windows event log or on the SQL server?

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Tuesday, February 9, 2016 3:06 PM
  • It's the latest update.

    The MSCRM_CONFIG db is indeed created.  The error happens during "installing and configuring Microsoft Dynamics CRM Configuration database".

    SQLAccessGroup cannot be added via SSMS due to error 15401.  https://support.microsoft.com/en-us/kb/324321

    Ran your query - no records returned.

    Also ran:

    SELECT *

    FROM sys.server_principals 

    None of my 35 users are G.  Only U,S,C,R.

    Thanks!


    Thursday, February 11, 2016 2:57 AM
  • FCB::Open failed: Could not open file B:\Program Files\Microsoft SQL Server\MSSQL12.SETLDSQLSERVER\MSSQL\DATA\MSCRM_CONFIG.mdf for file number 0.  OS error: 2(The system cannot find the file specified.).

    Thursday, February 11, 2016 3:01 AM