SharePoint connector

(Eric) #1

Hi again,

 

I am trying to setup a test sharepoint connection and working with few parts of organization so it's a bit of a hit and miss.

 

We have setup squiz demo server on our DMZ, Sharepoint list I am trying to connect to is on a local network, (access from DMZ to internal network has been configured see troubleshoot 2) I have a full access to it. When I create Sharepoint connector asset and give it URL and username and password I get following error

  PHP Warning 

			SoapClient::SoapClient(<a data-ipb='nomediaparse' href='http://pcc-adm-dapp3/_vti_bin/lists.asmx?WSDL'>http://pcc-adm-dapp3:portnumber/_vti_bin/lists.asmx?WSDL</a>): failed to open stream: HTTP request failed! HTTP/1.1 401 Unauthorized 
	
			PHP Warning
	
			SoapClient::SoapClient(): I/O warning : failed to load external entity &amp;quot;<a data-ipb='nomediaparse' href='http://pcc-adm-dapp3/_vti_bin/lists.asmx?WSDL&amp;quot;'>http://pcc-adm-dapp3:portnumber/_vti_bin/lists.asmx?WSDL&amp;quot;</a>
	<p>&#160;<p>What I tried to troubleshoot:<p>&#160;<p>1. Access <a data-ipb='nomediaparse' href='http://pcc-adm-dapp3'>http://pcc-adm-dapp3</a> from internal network using IE - Works fine as I am already authenticated on the network <p>2. Access <a data-ipb='nomediaparse' href='http://pcc-adm-dapp3'>http://pcc-adm-dapp3</a> from using IE user/pass dialog comes up give same details works fine <p>3. Access (<a data-ipb='nomediaparse' href='http://pcc-adm-dapp3/_vti_bin/lists.asmx?WSDL'>http://pcc-adm-dapp3/_vti_bin/lists.asmx?WSDL</a> - I get proper XML response <p>&#160;<p>Any ideas? Is there something that needs to be enabled on sharepoint server? or some firewall configuration?<p>&#160;<p>I can't even ask Squiz for help as this is all internal and there is no way to access it remotely
(Edison Wang) #2

You will need to verify  that the access is possible from the Matrix server to that Sharepoint server URL. (not using browser from your own computer)

So run sth like this from the Matrix server, assuming you are using http auth:

curl -u username:password http://pcc-adm-dapp3...lists.asmx?WSDL

(Eric) #3

Thanks for that, I will try, but I have to ask our IT to do it as I don't hav direct access, what results am I expecting to see?

 

Update: running command didn't return any results just came back to prompt.

(Micky Gough) #4

You'll need to check with your SharePoint admins that Basic authentication is enabled.

 

According to the Matrix manuals,"Please also note that only Basic Authentication is supported when connecting to a SharePoint Server; NTML Authentication is not supported."

 

Micky

 

 

(Eric) #5

As we using Windows authentication, I suspect this is a problem. Dows anyone know if this is a global setting or it can be limited to a sharepoint list/site/server ?

(Eric) #6

It is a test at the moment, however if it ever has a chance of being live, is there more secure connection then just basic authentication? Our Sharepoint admin doesn't like basic authentication due to security risks.

(Edison Wang) #7

If you use HTTPS and basic auth together, it should make the connection safer. If you have the network behind firewall, it should be even safer.

(Eric) #8

Thanks, meeting our IT team tomorrow, will discuss.

(Eric) #9

Is there a reason only basic authentication allowed? Can there be custom solution built allowing windows authentication? Has anyone implemented secure connection from website to sharepoint?

(Rohit Sharma) #10

I think you should follow theMicrosoft site to resolve this issue. Because I had also encountered the similar issue after the performing SharePoint Online Migration.