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) / We can no longer acces...
Microsoft Dynamics CRM (Archived)

We can no longer access CRM server.

(0) ShareShare
ReportReport
Posted on by Bish 105

Our previous Tech setup CRM 4.0, but left a year ago. It has been running fine until we came back from Xmas break. We can no longer access CRM through our web browser or Outlook. We can still access CRM directly on the server. I can ping CRM server ok.

When trying to access CRM via web browser the connection times out. When trying to access CRM via Outlook the error is This folder cannot be opened until CRM for Outlook is enabled.

Not having set it up or having no idea on how the 'back end' works, what will I need to look for? I have gone into SQL sever management and all services are running, I have even restarted them all. The servers have been rebooted. Deployment manager has everything enabled as does the reporting services configuration manager. These are the only things I found on Google.. :-)

Any help would be greatly appreciated.

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hmm I also experiences this once, restart and ensuring that all services were started solved my problem though.

    Have you installed all the latest CRM rollups?

    Do you have any idea what could have been changed? Was there some update installed that could have corrupted something?

    Concerning Outlook, Have you tried to the run the client config manager?

  • Bish Profile Picture
    Bish 105 on at

    We have not done any updates at all to CRM. As we dont have the tech here anymore, we dont want to screw it up, so we are hesitant to do anything. I dont really know where to start either.

    Nothing at all has changed on the network at all. No updates have been done, nor has anyone been on the network over the break.

    I will try and find the disks to re-install the outlook client.

    Thanks so far for the help.

  • Community Member Profile Picture
    Community Member on at

    You can just download the rollups from Microsoft Download.

    You just need to figure out what the latest rollup is and then you can install the newest releases.

    How do you figure out which rollup you have?

    crmdynamo.com/.../check-which-update-rollup-version-is-installed-on-your-crm-environments

    If that is below rollup 7, make sure to install those first. You can find them here:

    www.microsoft.com/.../details.aspx

    and then install the latest one, rollup 13:

    www.microsoft.com/.../details.aspx

    Make sure you have a backup of the SQL DB!!!

  • Inogic Profile Picture
    Inogic 709 on at

    You did say u have done the usual but i would like you to list out some more... rechecking the following might help

    1. Open the Command Prompt on windows and run iisreset.

    2. Check in IIS if all apppools defined are started.

    3. Check if the CRM Async Service in Services is running - restart it once again.

    Hope this helps!

    Sam

  • Bish Profile Picture
    Bish 105 on at

    The version we are running is RTM. As it has never failed before, I am wondering if it really needs to be upgraded. I only ask as I have mentioned before, I dont really know what I am doing. We only use the Service/Cases part of CRM, we dont use any other part of it. It is only used to track record jobs.

    I have checked IIS and did what was suggested but still no go.

    Outlook client config manager cannot connect to CRM, so it is still not working.

    I can still though use CRM fine direct from the server.... This is very frustrating.

    I think that it is more so because nothing at all has changed, no windows / server updates were done, and there was no access to the network over the break. It is like it just decided not to work anymore.

    If I cannot get CRM to work again, is there a way to export the data, so for example I can import it into Access? I tried using the import/export wizard under the SQL 2008 programs, but following the wizard, it kept saying there was no data or table to export.

    As we are a small shop in a regional town, there is no real IT support here, except me and other than using CRM, I have had no experience at all in the configuration of it. I would like to thank you all for the help you have given me so far. It is really appreciated.

  • Community Member Profile Picture
    Community Member on at

    I would really like to find a solution to your problem.

    What is the error message you see? Page could not be resolved?

    Do you see something in the eventlog on the server? In system, application? Something that clearly marks an error?

  • Bish Profile Picture
    Bish 105 on at

    Ok, we returned to work on the 4th Jan. Going through the event logs, there are huge amounts of information events for MSSQLSERVER.

    The first error on the 4th though was:

    Host HA-DB01: error while processing organization 0520837a-e995-471b-a8a3-80389b6c298b. Exception: System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

      at System.Data.SqlClient.TdsParserStateObject.WriteSni()

      at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()

      at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)

      at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)

      at Microsoft.Crm.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)

      at Microsoft.Crm.CrmDbConnection.Open()

      at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)

      at Microsoft.Crm.Workflow.WaitSubscriptionDataAccess.Notify(IDbCommand selectCommand, WaitNotificationService waitNotificationService)

      at Microsoft.Crm.Workflow.WaitSubscriptionDataAccess.Notify(String hostId, WaitNotificationService waitNotificationService)

      at Microsoft.Crm.Workflow.WorkflowHost.OnNotificationTimerEvent(Object sender, ElapsedEventArgs e)

    The next one is:

    CrmKeyGenerator encountered an error generating/monitoring key type System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

      at System.Data.SqlClient.TdsParserStateObject.WriteSni()

      at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()

      at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)

      at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)

      at Microsoft.Crm.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)

      at Microsoft.Crm.CrmDbConnection.Open()

      at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)

      at Microsoft.Crm.SharedDatabase.DatabaseService.RetrieveById(String tableName, Object id, String[] columns)

      at Microsoft.Crm.CrmKeySetting.LoadSettingsBag()

      at Microsoft.Crm.CrmKeySetting.Initialize(Boolean loadSettingsFromConfigDB, Guid scaleGroupId, ConfigSku configSku)

      at Microsoft.Crm.CrmKeySetting..ctor(CrmKeyType crmKeyType, Boolean loadSettingsFromConfigDB, Boolean useCachedValues, Guid scaleGroupId, ConfigSku configSku)

      at Microsoft.Crm.CrmKeyGenerator.DoManageKeys(Guid scaleGroupId).  Check event log to see if keys are being generated properly.  KeySetting : %2.  Error : %3

  • Community Member Profile Picture
    Community Member on at

    Were these errors new since 4th of Jan or were they there before the error started?

  • Bish Profile Picture
    Bish 105 on at

    The event log is littered with thousands of SQL/CRM information logs, but the first error occured on the 6th December. It is:

    Source: MSSQLServerADHelper100

    '0' is an invalid number of start up parameters. This service takes two start up parameters.

    Source: Report Server Windows Service (MNC)

    Report Server Windows Service (MNC) cannot connect to the report server database.

    Source: Perflib

    The configuration information of the performance library "C:\Windows\system32\perf-MSSQL$MNC-sqlctr10.0.1600.22.dll" for the "MSSQL$MNC" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted.

    Source: MSSQLServerADHelper100

    '0' is an invalid number of start up parameters. This service takes two start up parameters.

    These are littered throughout the log files. There are a lot of different warnings listed, the most common one is:

    Source: SQLAgent$MNC

    SQL Server Scheduled Job 'MSCRM_CONFIG.HardDelete' (0x61AE2D8C686CF6448637B149020DC13A) - Status: Failed - Invoked on: 2010-12-07 04:00:00 - Message: The job failed.  Unable to determine if the owner (MNC\bishadm) of job MSCRM_CONFIG.HardDelete has server access (reason: Could not obtain information about Windows NT group/user 'MNC\bishadm', error code 0x6fd. [SQLSTATE 42000] (Error 15404)).

    As I have mention before though, it had been working fine up until we left for xmas break. There are not many errors up until we left for break. So based on this, the first error from the 25th Dec is on the 28th Dec.

    Source: MSSQLServerADHelper100

    '0' is an invalid number of start up parameters. This service takes two start up parameters.

    Source: Report Server Windows Service (MNC)

    Report Server Windows Service (MNC) cannot connect to the report server database.

    Then there is no errors only information logs up until the 4th Jan. There was a warning logged:

    Source: MSCRMKeyGenerator

    CrmKeyGenerator has stopped.

    That was the only warning log up until the error listed in my previous post.

    Cheers,

  • Bish Profile Picture
    Bish 105 on at

    Can there be authentication issues, and if so what would they be and what / where do I look to see if there is?

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