Camelot ConnectionString Errors

One of the most common support issues we have is related to connection errors. Setting up connections correctly to SharePoint (or any .NET system for that matter) can be tricky and require some reading. Regardless of which there may be other things that create these errors.

The most common error is

The client was not authorised by the server. Ensure that the
ConnectionString property on the Connection is correct.

at Camelot.SharePointConnector.Data.SharePointCommand.ExecuteReader(CommandBehavior
  behavior, Boolean returnScalar)
at Camelot.SharePointConnector.Data.SharePointCommand.ExecuteDbDataReader(
  CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[]
  datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
  command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord,
  Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Camelot.SharePointConnector.Data.Helper.ExecuteDataTable(String query, String
at Camelot.WebParts.BlogReader.BlogReader.Page_Load(Object sender, EventArgs e)

This usually means that the

  • credentials in the connectionstring is wrong, or
  • connection wasn’t allowed from the client
  • the authentication didn’t succeed from a client that is on a different domain

Credential management

It is important that the parameters in the connectionstring are correct, if you have used authentication=default you may try using the authentication=ntlm instead and remember to check and recheck that your user have access rights to the specified SharePoint Server and Site

Allowing connections

There is something called “loopback errors” that occurs internally in Windows. There are a lot of articles on how to work with this; we prefer the simple approach to solve this by using PowerShell

Execute the following PowerShell command on each SharePoint frontend server.

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword

In some very rare occasions you may need to reset IIS.

More reading at Microsoft

This entry was posted in Camelot .NET Connector. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>