Tuesday, February 3, 2009

HTTP 403 Forbidden Error After Installing .NET Framework 3.5 SP1 on Windows Server 2003 SP2 running MOSS 2007

I recently encountered a strange problem accessing my SharePoint0 sites and the SharePoint Central Administration site after installing .NET Framework 3.5 SP1 on my Windows Server 2003 running SP2.

The error message I recieved was the HTTP 403 Forbidden error. This was showing up for all sharepoint sites.

At first I tried specifying the URL along with the .aspx page name, resetting IIS, checking IIS to see if Integrated Authentication was enabled in IIS, and a bunch of other troubleshooting steps, with no luck.
I then decided to uninstall the .NET Framework 3.5 SP1 using the Add/Remove Programs, but strangely the problem persisted.
Solution:
Finally after some googling around, this is the workaround I used to fix this problem. I'm not sure if this is the best way of going about solving the problem, but it worked for me.
1. Open IIS (click Start -> Run -> and type inetmgr)
2. Expand Application Pools
3. Right-click Application Pool of your web application and click Properties.
4. Click the Identity tab in the property page
5. Under Application Pool Identity, choose Local System instead of Network Service
6. Click Apply
7. Click OK
8. Reset IIS

Monday, February 2, 2009

Cascading Drop Down List (With Filter) - Custom Field Control

The excellent SharePoint - Cascading Drop Down Lists provided by DataCogs is a great way to create relationships between fields/columns in SharePoint lists.

DataCogs Solution Page:
http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

This was further enhanced by Patrick Tisseghem to allow a grandchild dropdown. Visit Patrick's Page at:
http://blog.12thwave.com/?p=7

Expanding on Patrick's modified version to allow a grandchild dropdown list, I've added the functionality to filter the items in the dropdown.

Also, the "Required Field" validation was not validated accurately and this has been taken care of in my modified source.

Below find a few screenshots of configuring and using the custom field -

I have a list called 'Continents':


A second list 'Countries':


And a third list 'Cities':


In my fourth list 'My Location' in which I would want to have the three dropdowns displayed, I create three columns : Continent, Country and City using my custom field 'Cascading Drop Down List (With Filter)'.



The three columns created are -


Configuring the columns and using the filter -








When adding a 'New Item' to the 'My Location' list, the first dropdown will have "Please select an Item' (which is also something I added) as the first item in the dropdown.

Cascading Drop Down List (With Filter) in action:



According to the filter set, the list of continents that appear are only the ones that contain 'America'.







Many thanks to Datacogs and Patrick for their valuable contribution to the SharePoint community.

For the solution file (.wsp) and complete source code, please visit the project page at:
http://cascddlistwithfilter.codeplex.com/

Please feel free to post your comments/suggestions.