Difference between revisions of "Publishing Troubleshooting"

(Publishing failure)
Line 1: Line 1:
= Connection failure =
+
== Connection failure ==
  
 
When you click "Connect" in the publishing dialog XLCubed will try to contact your web server.
 
When you click "Connect" in the publishing dialog XLCubed will try to contact your web server.
Line 5: Line 5:
 
If you can't connect to the web server, you can try the following
 
If you can't connect to the web server, you can try the following
  
== Client configuration ==
+
=== Client configuration ===
  
 
If you use a proxy server to access the internet this can prevent XLCubed connecting correctly
 
If you use a proxy server to access the internet this can prevent XLCubed connecting correctly
Line 18: Line 18:
 
If this fails an administrator can check the following to try to resolve the problem.
 
If this fails an administrator can check the following to try to resolve the problem.
  
== Windows Authentication ==
+
=== Windows Authentication ===
  
=== IIS Settings ===
+
==== IIS Settings ====
  
 
Depending on your IIS version, take the following steps:
 
Depending on your IIS version, take the following steps:
  
==== IIS 5/6 ====
+
===== IIS 5/6 =====
  
 
Right click the XLCubedWeb directory and select "Properties"
 
Right click the XLCubedWeb directory and select "Properties"
Line 32: Line 32:
 
[[File:XLCubedWebConfigIIS5AuthenticationWindows.png|200px|center]]
 
[[File:XLCubedWebConfigIIS5AuthenticationWindows.png|200px|center]]
  
==== IIS 7/7.5 ====
+
===== IIS 7/7.5 =====
  
 
Select the XLCubedWeb directory and open the "Authentication" section.
 
Select the XLCubedWeb directory and open the "Authentication" section.
Line 46: Line 46:
  
  
==== Web.config ====
+
===== Web.config =====
 
You will need to change the web.config file to include entries for all bindings.
 
You will need to change the web.config file to include entries for all bindings.
 
These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.
 
These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.
Line 67: Line 67:
 
|}
 
|}
  
== Basic Authentication ==
+
=== Basic Authentication ===
  
=== IIS Settings ===
+
==== IIS Settings ====
  
 
Depending on your IIS version, take the following steps:
 
Depending on your IIS version, take the following steps:
  
==== IIS 5/6 ====
+
===== IIS 5/6 =====
  
 
Right click the XLCubedWeb directory and select "Properties"
 
Right click the XLCubedWeb directory and select "Properties"
Line 81: Line 81:
 
[[File:XLCubedWebConfigIIS5AuthenticationBasic.png|200px|center]]
 
[[File:XLCubedWebConfigIIS5AuthenticationBasic.png|200px|center]]
  
==== IIS 7/7.5 ====
+
===== IIS 7/7.5 =====
  
 
Select the XLCubedWeb directory and open the "Authentication" section.
 
Select the XLCubedWeb directory and open the "Authentication" section.
Line 91: Line 91:
 
[[File:XLCubedWebConfigIIS6AuthenticationBasic.png|200px|center]]
 
[[File:XLCubedWebConfigIIS6AuthenticationBasic.png|200px|center]]
  
==== Web.config ====
+
===== Web.config =====
 
You will need to change the web.config file to include entries for all bindings.
 
You will need to change the web.config file to include entries for all bindings.
 
These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.
 
These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.
Line 112: Line 112:
 
|}
 
|}
  
== Anonymous Authentication ==
+
=== Anonymous Authentication ===
  
=== IIS Settings ===
+
==== IIS Settings ====
  
 
Depending on your IIS version, take the following steps:
 
Depending on your IIS version, take the following steps:
  
==== IIS 5/6 ====
+
===== IIS 5/6 =====
  
 
Right click the XLCubedWeb directory and select "Properties"
 
Right click the XLCubedWeb directory and select "Properties"
Line 126: Line 126:
 
[[File:XLCubedWebConfigIIS5AuthenticationAnon.png|200px|center]]
 
[[File:XLCubedWebConfigIIS5AuthenticationAnon.png|200px|center]]
  
==== IIS 7/7.5 ====
+
===== IIS 7/7.5 =====
  
 
Select the XLCubedWeb directory and open the "Authentication" section.
 
Select the XLCubedWeb directory and open the "Authentication" section.
Line 139: Line 139:
 
Control Panel -> Programs -> Turn Windows features on or off
 
Control Panel -> Programs -> Turn Windows features on or off
  
==== Web.config ====
+
===== Web.config =====
 
You will need to change the web.config file to include entries for all bindings.
 
You will need to change the web.config file to include entries for all bindings.
 
These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.
 
These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.
Line 160: Line 160:
 
|}
 
|}
  
= Publishing failure =
+
== Publishing failure ==
  
 
If you can connect to the web server, but cannot publish a file, you can try the following troubleshooting steps.
 
If you can connect to the web server, but cannot publish a file, you can try the following troubleshooting steps.
  
== Validate IIS Config ==
+
=== Validate IIS Config ===
  
 
Navigating to the repository web service on the server will give a detailed error message if there is a problem with the configuration (if everything is configured correctly you will see some sample code about using the service). For example, navigate to:
 
Navigating to the repository web service on the server will give a detailed error message if there is a problem with the configuration (if everything is configured correctly you will see some sample code about using the service). For example, navigate to:
Line 202: Line 202:
 
   </serviceBehaviors>
 
   </serviceBehaviors>
  
== Permissions ==
+
=== Permissions ===
  
 
Users need write permission to the repository directory in order to be able to publish files.
 
Users need write permission to the repository directory in order to be able to publish files.
Line 213: Line 213:
 
If the publish then succeeds then permissions was the issue, and you can restrict access to the users you wish to be able to publish.
 
If the publish then succeeds then permissions was the issue, and you can restrict access to the users you wish to be able to publish.
  
= See Also =
+
== See Also ==
 
*[[XLCubed Web Edition Installation Guide]]
 
*[[XLCubed Web Edition Installation Guide]]
  

Revision as of 11:43, 30 August 2012

Connection failure

When you click "Connect" in the publishing dialog XLCubed will try to contact your web server.

If you can't connect to the web server, you can try the following

Client configuration

If you use a proxy server to access the internet this can prevent XLCubed connecting correctly

To allow the connection turn on the option to bypass the proxy for local addresses.

Note that you only need to do this is you use a proxy, otherwise there is no need to make this change.

XLCubedWebConfigIESettings.png


If this fails an administrator can check the following to try to resolve the problem.

Windows Authentication

IIS Settings

Depending on your IIS version, take the following steps:

IIS 5/6

Right click the XLCubedWeb directory and select "Properties" Select the "Directory Security" tab Ensure that "Integrated Windows authentication" is checked and all others are not.

XLCubedWebConfigIIS5AuthenticationWindows.png
IIS 7/7.5

Select the XLCubedWeb directory and open the "Authentication" section.

XLCubedWebConfigIIS6Authentication.png

Ensure "ASP.NET Impersonation" and "Windows Authentication" are enabled, and others are disabled.

XLCubedWebConfigIIS6AuthenticationWindows.png

If you do not have these options you must add them from Control Panel -> Programs -> Turn Windows features on or off


Web.config

You will need to change the web.config file to include entries for all bindings. These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.

Please note that when using HTTPS the security mode should be equal to Transport.

Authentication Using HTTPS? web.config – on all bindings
Windows Yes <security mode="Transport"> <transport clientCredentialType="Windows"/> </security>
Windows No <security mode="TransportCredentialOnly"> <transport clientCredentialType="Windows"/> </security>

Basic Authentication

IIS Settings

Depending on your IIS version, take the following steps:

IIS 5/6

Right click the XLCubedWeb directory and select "Properties" Select the "Directory Security" tab Ensure that "Basic authentication" is checked and all others are not.

XLCubedWebConfigIIS5AuthenticationBasic.png
IIS 7/7.5

Select the XLCubedWeb directory and open the "Authentication" section.

XLCubedWebConfigIIS6Authentication.png

Ensure "ASP.NET Impersonation" and "Basic Authentication" are enabled, and others are disabled.

XLCubedWebConfigIIS6AuthenticationBasic.png
Web.config

You will need to change the web.config file to include entries for all bindings. These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.

Please note that when using HTTPS the security mode should be equal to Transport.

Authentication Using HTTPS? web.config – on all bindings
Basic Yes <security mode="Transport"> <transport clientCredentialType="Basic"/> </security>
Basic No <security mode="TransportCredentialOnly"> <transport clientCredentialType="Basic"/> </security>

Anonymous Authentication

IIS Settings

Depending on your IIS version, take the following steps:

IIS 5/6

Right click the XLCubedWeb directory and select "Properties" Select the "Directory Security" tab Ensure that "Enable anonymous access" is checked and all others are not.

XLCubedWebConfigIIS5AuthenticationAnon.png
IIS 7/7.5

Select the XLCubedWeb directory and open the "Authentication" section.

XLCubedWebConfigIIS6Authentication.png

Ensure "ASP.NET Impersonation" and "Anonymous Authentication" are enabled, and others are disabled.

XLCubedWebConfigIIS6AuthenticationAnon.png

If you do not have these options you must add them from Control Panel -> Programs -> Turn Windows features on or off

Web.config

You will need to change the web.config file to include entries for all bindings. These entries are dependent on the authentication mode (Basic, Windows or Anonymous) and whether or not you are using HTTPS.

Please note that when using HTTPS the security mode should be equal to Transport.

Authentication Using HTTPS? web.config – on all bindings
Anonymous Yes <security mode="Transport"> <transport clientCredentialType="None"/> </security>
Anonymous No <security mode="TransportCredentialOnly"> <transport clientCredentialType="None"/> </security>

Publishing failure

If you can connect to the web server, but cannot publish a file, you can try the following troubleshooting steps.

Validate IIS Config

Navigating to the repository web service on the server will give a detailed error message if there is a problem with the configuration (if everything is configured correctly you will see some sample code about using the service). For example, navigate to:

http://localhost/xlcubedweb/webservices/RepositoryServer.svc

If this returns without error, then try with the exact URL the user would enter, for example:

https://www.someserver.com/xlcubedweb/webservices/RepositoryServer.svc

A full error message should be displayed giving details of the configuration that needs changing. Here a some example errors and their solutions:

The HttpGetEnabled property of ServiceMetadataBehavior is set to true and the HttpGetUrl property is a relative address, but there is no http base address. Either supply an http base address or set HttpGetUrl to an absolute address.
Locate the <serviceBehaviors> section and update it to the following:
 <serviceBehaviors>
   <behavior name="XLCubedWeb.WebServices.RepositoryServerBehavior">
     <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
     <serviceDebug includeExceptionDetailInFaults="false" />
   </behavior>
   <behavior name="XLCubedWeb.WebServices.SmallMultipleChartServerBehavior">
     <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
     <serviceDebug includeExceptionDetailInFaults="false" />
   </behavior>
   <behavior name="XLCubedWeb.WebServices.MapServerBehavior">
     <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
     <serviceDebug includeExceptionDetailInFaults="false" />
   </behavior>
   <behavior name="XLCubedWeb.WebServices.PrintRendererServerBehavior">
     <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
     <serviceDebug includeExceptionDetailInFaults="true" />
   </behavior>
   <behavior name="XLCubedWeb.WebServices.SchedulingServerBehavior">
     <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
     <serviceDebug includeExceptionDetailInFaults="false" />
   </behavior>
 </serviceBehaviors>

Permissions

Users need write permission to the repository directory in order to be able to publish files.

If this permission is missing often users can connect to the web server, but don't see a "My Reports" folder, and get an error when attempting to publish a file.


To check if this is the problem you can grant Read and Write Access to the Repository directory in the XLCubedWeb site to everyone and retry publishing.

If the publish then succeeds then permissions was the issue, and you can restrict access to the users you wish to be able to publish.

See Also