Microsoft KB Archive/925714

= An Excel 2007 workbook does not load from a Web page that uses EWA when there are many connections to the computer that is running SharePoint Server 2007 =

Article ID: 925714

Article Last Modified on 10/17/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007
 * Microsoft Office Excel 2007

-



SYMPTOMS
Consider the following scenario. You use a Web page that uses Excel Web Access (EWA) to open a workbook on a computer that is running Microsoft Office SharePoint Server 2007. If there are many connections to the computer that is running SharePoint Server 2007, the workbook does not load. Typically, this issue occurs if there are more than 2,000 sessions on the computer that is running SharePoint Server 2007 server. Additionally, you may receive one or more of the following error messages.

Note This issue applies only to a Kerberos environment. This issue does not apply to a Trusted Subsystem (TSS) configuration.  Error message 1

An error has occurred.

 Error message 2

Failed with the following response soap:Server An error has occurred. 



Additionally, the following warning message is logged in the Application log: Event Type: Warning

Event Source: Office SharePoint Server

Event Category: Excel Services Web Front End

Event ID: 5236

User:

Computer:

Description: An Internal error prevented the request from being processed. Excel Calculation Services

http:// :56737/ /ExcelCalculationServer/ExcelService.asmx Exception: Client found response content type of 'text/html', but expected 'text/xml'.

The request failed with the error message:

Error  No authority could be contacted for authentication. --. [Session: (null) User: ].

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

You may also experience this issue if you access workbooks by using the Excel Web Services for SharePoint Server 2007.



RESOLUTION
To resolve this issue, change the MaxUserPort setting on the computer that is running SharePoint Server 2007. To do this, follow these steps: <ol> Click Start, click Run, type regedit in the Open box, and then click OK.</li> Locate and then click the following registry subkey:

 

</li> After you select the subkey that is specified in step 2, point to New on the Edit menu, and then click DWORD Value.

Note If the MaxUserPort DWORD value already exists, go to step 5.</li> Type MaxUserPort, and then press ENTER.</li> Right-click MaxUserPort, and then click Modify.</li> In the Value data box, type a value that is more than 5000 and less than 65535. Then, click OK.

For example, type 10000 in the Value data box, and then click OK.

Note The MaxUserPort value controls the maximum dynamic port number. The exact number that is used for this value depends on your scenario.</li> On the File menu, click Exit to exit Registry Editor.</li> Restart the computer that is running SharePoint Server 2007.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
The TCPTimedWaitDelay setting can also be added to determine how long a closed port waits until the closed port can be reused. For more information about how to change the MaxUserPort setting and the TCPTimedWaitDelay setting, click the following article number to view the article in the Microsoft Knowledge Base:

328476 Description of TCP/IP settings that you may have to adjust when SQL Server connection pooling is disabled

Additional query words: sharepointserver2007 sharepointserver2k7 sharepointserver12 sps2007 sps2k7 sps12 moss2007 moss2k7 moss12 xlservices excelservices ecs ewa

Keywords: kberrmsg kbtshoot kbprb kbopenfile kbexpertiseinter KB925714

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.