Skip to main content

Posts

Showing posts from July, 2010

Error in the Site Data Web Service. (Value does not fall within the expected range.)

After setting up a new web application for a new portal I faced a crawling problem of the new site collection. Description: Right after starting the crawler it stops, giving 2-3 error messages, all with the same syntax: Error in the Site Data Web Service. (Value does not fall within the expected range.) The crawl log was the only place the error was logged, with no additional information regarding the cause of the problem. Searching the web came up with very little solutions, while only one of them seemed to apply to our case: 1. stsadm -o export -url http://intranet/sites/it -filename D:\it.back.11.21.08.cmp -versions 2 2. Delete the site collection 3. stsadm -o import -url http://intranet/sites/it -filename D:\it.back.11.21.08.cmp -updateversions 2 –nofilecompression (See here) While option 1 and 3 are reasonable, deleting the site collection didn’t apply since the portal was already in production stage. (along with the fact faze 1 didn’t pass either due to some technical issues…

Using Kerberos for SharePoint Authentication

Although SharePoint offers multiple authentication options and authentication zones, the two most common choices for enterprise implementations in intranet scenarios are NTLM and Kerberos. Both of these protocols are used with Integrated Windows authentication in a classic challenge/response scheme. NTLM relies on IIS generating a token with a challenge, sending it to the client, the client responding with a token, and a domain controller validating that response. NTLM requires user names and passwords to be encrypted before they are transmitted, and also requires re-authentication (a new token) when accessing a new network resource. Kerberos, on the other hand, relies on a ticketing system where a client and server access a trusted authority called a Key Distribution Center (KDC), which responds to client requests and grants tickets that the client can use to access network resources. Kerberos does not require re-authentication for accessing multiple resources. Much of the documentati

Steps for retrieving a file from MOSS content database

Query for the filename in the Leafname column of AllDocs table and the get the Id of that Row, then update the id in the following code and execute the same. File is in your hands!!! using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.Data.Sql; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlBlob2File(); } public void SqlBlob2File() { try { int PictureCol = 0; // the column # of the BLOB field SqlConnection cn = new SqlConnection("server=vbassql01i\\bassql01in1;integrated security=yes;database=IE_30_06_2010"); SqlCommand cmd = new SqlCommand("SELECT [Content] FROM AllDocStreams