Arnaud Aubert’s blog

He (or she ?) was not planned so quickly but we are proud to announce our third child should born on 27st January 2009. Here are the first ultrasound displays.

     
     

Warning, the FormParameter element doesn’t work correctly inside a master page. You should prefer using ControlParameter instead.

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=118678

You need to update the web.config file placed in your site collection virtual directory (eg. c:\inetpub\wwwroot\wss\VirtualDirectories\80) and edit all of the following settings :

• callstack=”True” in the SafeMode element
• mode=”Off” in customErrors element

If you try to optimize your collaborative processes or disk space used by identifying duplicated files and these files are being indexed by MOSS, then you can use the search database to report these duplicate items :

– Step1 : get all files with short names, md5 signatures, and size
select
md5,
right(accessurl, charindex(‘\’, reverse(accessurl)) - 1) as ShortFileName,
accessurl AS Url,
llVal / 1024 as FileSizeKb
into
#listingFilesMd5Size
from
MSSCrawlURL y inner join MSSDocProps on ( y.DocID = MSSDocProps.DocID )
where
MSSDocProps.pid = 58 – File size
and llVal > 1024 * 10 – 10 Kb minimum in size
and md5 <> 0
and charindex(‘\’, reverse(accessurl)) > 1

– Step 2: Filter duplicated items
select count(*) AS NbDuplicates, md5, ShortFileName, FileSizeKb
into #duplicates
from #listingFilesMd5Size
group by md5, ShortFileName, FileSizeKb
having count(*) > 1
order by count(*) desc

drop table #listingFilesMd5Size

When you get the following error messages and no one of the reasons may apply, try to delete the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{65bcbee4-7728-41a0-97be-14e1cae36aae}.

The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.

SSAS setup program does not configure SPNs correctly by default. Therefore, Kerberos authentication cannot run and connection from delegated accounts cannot run. The following article describes how to configure the domain account SPNs depending on the instance name. Also, don’t forget to add “SSPI=Kerberos” to the SSAS connection string to use Kerberos instead of NTLM when connecting. This is required to secure connections from MOSS/Sharepoint for example (see: http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx). 

http://support.microsoft.com/kb/936628/en-us

I recently encountered many difficulties with Kerberos authentication and delegation especially when dealing with web applications and users belonging to many groups. There were several problems in fact :

1. The size of the Kerberos ticket was larger than the default buffer
2. IIS 5 and IIS 6 do limit the size of the POST variables and therefore also apply a different quota for Kerberos tickets going through HTTP
3. When implementing Kerberos authentication with FQDN, you should check that SPNs are set up correctly

I wrote down a summary of the links that helped me solving these issues. Also, I created a small .REG files that upsize all these limites (Kerberos, IIS 5, IIS 6…).

For IIS 5 : http://support.microsoft.com/kb/310156/fr

For IIS6 : http://support.microsoft.com/kb/920862

For setspn.exe : http://support.microsoft.com/kb/929650

For the ticket size issue :

http://support.microsoft.com/kb/327825

Windows Registry Editor Version 5.00
 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HTTP\Parameters]
“MaxFieldLength”=dword:00008000
“MaxRequestBytes”=dword:00008000
  [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w3svc\parameters]
“MaxClientRequestBuffer”=dword:00008000
  [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters]
“MaxTokenSize”=dword:0000ffff
 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters]
“MaxUserPort”=dword:0000fffe 
	
 
	

Noah was finally born on 3rd January 2008 at 9:30pm ! He weighs 12.4 lbs and measures 21.9 in. His sister is crazy about him although he spends his time only by sleeping and eating!

No more than 2 months before Noah’s birth, hospital staff has been able to make a 3D ultrasound display of his face. Hereunder it is… How much beautiful he is…