Steps to Schedule reports to Sharepoint’s Directory using UNC path:
1) Make sure you can browse to the Sharepoint location using UNC path. So if your URL is http://Servername/SiteDirectory/Title, equivalent UNC path would be \\Servername\SiteDirectory\Title. We need the Webclient Service running on the box to access this UNC path.
2) If the URL is accessible you should be able to schedule the report to \\Servername\SiteDirectory\Title\SharedDocuments. The Shared Documents folder is created because we had used “Document Workspace” as a template. The folder structure will wary as per the template you select.
3) Go to the Business Objects Server running Crystal Reports / Web Intellignce / Desktop intelligence / Destination Job Servers (whichever report type is applicable).
4) Click on Start >> Run.
5) Type services.msc and hit ENTER. .
6) Enable and start the service Webclient.
7) Click on Start >> Control Panel >> Add or Remove Programs >> Add/Remove Windows Components.
8) Uncheck the box with the label Internet Explorer Enhanced Security Configuration >> Click Next.
9) Logon to Business Objects Server computer using the service account which is being used to Authenticate against the Sharepoint Server.
10) Open Internet Explorer >> Tools >> Internet Options >> Security >> Local Intranet >> Sites >> Advanced.
11) Add the hostname and hostname.domain.com of the SharePoint Server to the Trusted Sites. Do NOT prefix the name with http(s) .
12) Open Internet Explorer >> Tools >> Internet Options >> Security >> Local Intranet >> Custom Level >> User Authentication >> Logon
13) Choose the radio button with the option Automatic logon with current username and password. >> Ok >> Ok.
14) Create a registry entry AuthForwardServerList of type Multi-String Value at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters\. Type the names of the computers hosting the SharePoint service as a list in the Value Data, one name on each line. Click OK.
15) Reboot the Business Objects Server.
16) Schedule Documents through Business Objects and browse to http://Servername/SiteDirectory/Title and click on Documents on the left pane to view it in Sharepoint site.
Please Note:-
1) If you create a schedule with default name it will contain ‘~’ in the file name which is not allowed on the Sharepoint by default. You will get error:
“destination directory error.[CrystalEnterprise.DiskUnmanaged]: [The parameter is incorrect. ]” Or “destination directory error. [C rystalEnterprise.DiskUnmanaged]: [The file type being saved or retrieved has been blocked. ]”
So make sure you configure the instance to you any valid name by adding the place holder in the schedule e.g. %SI_NAME%
2) Webclient Service is not enabled by default on Windows Server 2008. Please follow the below steps for same.
a. Open Server Manager and click the Features node.
b. If "Desktop Experience" in not already listed under Features, click "Add Features".
c. Select the "Desktop Experience" item and then click Next followed by Install.
d. Reboot the PC as instructed.
Some usuful information:
BusinessObjects Server makes a simple ping request to the sharepoint server. If this succeeds and the sharepoint server replies back, then the Job Server tries to make a connection on port 445 (microsoft-ds) to the sharepoint server. If it does not get a reply back, it tries a couple times unsuccessfully and then tries to make a connection to the sharepoint server on port 139 (netbios-ssn). If it does not receive a reply after a few tries, if we get a response back from another IP (Not SharePoint) stating Destination Unreachable. It could be a firewall.
Port 445 is the new Microsoft file sharing port and port 139 is the older Microsoft sharing port. The Job Server tries to make connections on both and never receives any reply back. Typically ports 445 and 139 are used by virus/trojan/worms to spread viruses so these are common ports for a firewall to block.
References: SAP KB article # 1373496.
