Solved

Microsoft CRM 4.0 Reporting errors - cannot connect to database

Posted on 2011-09-05
4
2,204 Views
Last Modified: 2012-05-12
Hello Experts,

Today our CRM server reports started to fail (these had previously been working for 1year+ without issue).

on the CRM server we see the following error when trying to generate any report.

report cannot be generated please contact your administrator

If we go direcly to the SQL reporting server and try to generate a report we see the following:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
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)

Other functions of CRM appear to be funtioning normally as do other databases on the database server.

there are no obvious errors in the eventlog of the database server however on the CRM server we see the following in the event log.

Web service request SetParameters to Report Server <server> failed with SoapException. Error: Execution 'mxdk2s451qiukfyvopm5biul' cannot be found (rsExecutionNotFound)

Report Server (MSSQLSERVER) cannot connect to the report server database.

CrmKeyGenerator encountered an error generating/monitoring key type System.Data.SqlClient.SqlException: The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following:  the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.LoadKeySetting(CrmKeyType keyType, Boolean useCachedValues, Guid scaleGroupId)
   at Microsoft.Crm.CrmKeySetting.LoadKeySetting(CrmKeyType keyType, Boolean useCachedValues)
   at Microsoft.Crm.CrmKeyGenerator.DoManageKeys(Guid scaleGroupId).  Check event log to see if keys are being generated properly.  KeySetting : %2.  Error : %3

For more information, see Help and Support Center at


vent code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/5/2011 11:15:51 AM
Event time (UTC): 9/5/2011 10:15:51 AM
Event ID: a0592ad60cb64386b9ef84eae4cd29d3
Event sequence: 22
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/2/ROOT-1-129596913187187500
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
    Machine name: <server>
 
Process information:
    Process ID: 3240
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: CrmReportingException
    Exception message: Execution 's1xolifz2k5rarbbtocqkazh' cannot be found (rsExecutionNotFound)
 
Request information:
    Request URL: http://<server>/CRMReports/rsviewer/reportviewer.aspx
    Request path: /<folder>CRM/CRMReports/rsviewer/reportviewer.aspx
    User host address: <iP address>
    User: <username>
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 7
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
   at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at
0
Comment
Question by:Dave_Angel_Portsmouth
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
Dave_Angel_Portsmouth earned 0 total points
ID: 36483446
the error was related to kerberos.

we had a time difference between the SQL reporting server and the Database sever once this was corrected the reports began to generate again.
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 36483566
Hi Dave,
The most probable cause is that the reporting server cannot access the database server -basically a network problem.

Check if:
1.Can you ping the database server from the reporting server
2.can telnet into the database server from reporting server using the sql port
3.can connect to the sql instance in the database server using sqlcmd or osql fro the reporting server(osql -S servername -U username -p password)

regards,
Norman Maina
0
 
LVL 2

Author Comment

by:Dave_Angel_Portsmouth
ID: 36483571
Thanks Norman, but we've already resolved it. The NTP server we were using to keep the times matched has been taken down (manchester Kronos)

0
 
LVL 2

Author Closing Comment

by:Dave_Angel_Portsmouth
ID: 36515572
Resolved before other user comments

Was a NTP time issue
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
cannot connect to sqlserver 8 25
Need some help to cast ntext to nvarchar SQL 2000 7 31
SQL Insert parts by customer 12 31
Sql Query 6 51
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question