Skip to content

IIS Error – The WebResource.axd handler must be registered in the configuration to process this request

2011 January 6

After I installed Coldfusion 9 on an IIS 7 website I received an error on one of my ASP.NET pages saying that the WebResource.axd handler must be registered in the web.config file.  I looked in my web.config file and found out that the WebResource.axd file was ALREADY configured just as the error says:

<add path=”WebResource.axd” verb=”GET” type=”System.Web.Handlers.AssemblyResourceLoader” validate=”True” />

After some digging online, I found out that for some reason there is a conflict between coldfusion and Application Pools that are running in “Integrated” mode.  Once I changed the Application Pool for my website (cftest1 in the picture below), from “Integrated” to “Classic” Managed Pipeline Mode and recycled the application pool both my asp.net pages and my coldfusion pages started working.

Fixing the WebResource.axd by setting Application Pool to Classic Mode

NOTE:  Personally I don’t care if my application pool runs in “Classic” mode, but you may be different.  You will probably want to investigate the implications of running in Classic mode rather than Integrated.  I’m guessing that in “Classic” there is a greater chance that individual crashes could affect the entire website.  Also, if you are doing very complex CF or ASP.NET pages, there might be issues.  You might want to look into this further.

How to Customize Blog Posts in Sharepoint 2010

2010 December 27
by mark

It seems like there is very little documentation online from Microsoft on customizing layouts for things like Blog Sites and Blog posts in Sharepoint 2010.  I did find some posts about it online, but they were very terse and general.

This is going to be a very simple and to the point post about how to customize a Sharepoint 2010 blog post, specifically how to remove the table column with the Post date in it ( the td with ms-leftblogdate for css).  This requires you to create a new XSL template file and then connect that file to the post.

  • Step 1, locate the blog.xsl file on your Sharepoint server, mine was located in the following folder:
    • C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\XSL
  • In Sharepoint Designer create a new folder and a new file for the customized XSL file you will be creating
    • I created a folder called “xsl” in the root of my Blog site and then created a file called blogPost.xsl.
  • Copy the contents of the blog.xsl file into the file you just created, in my case I called it blogPost.xsl
  • In Sharepoint  Designer open up the Post.aspx file
    • It’s in the Lists/Posts directory of your Blog Site
  • Click the Advanced Mode button in the Ribbon
  • Switch the Sharepoint Designer to Design Mode (the button is circled in red in the image below)
  • Click on the empty cell where the Post will appear.  If you can’t tell where this is, look at the image below to help you locate it.  It will be a WebPartPages:XsltListVewWebpart object
  • In the “Tag Properties” window of Sharepoint Designer on the right side of the screen, locate the property “XslLink” and type in the location of the new XSL file you created above
    • This will be something like /blog/xsl/blogPost.xsl if you followed along above

      Customize Blog Posts to use New Customized XSL File

      Customize Blog Posts to use New Customized XSL File

  • Return to the file you just created, blogPosts.xsl, and make your edits.  I searched for the code <td class = “ms-leftblogdate”> and removed this entire TD because it was making my design look bad.
  • Save both the blogPosts.xsl and the Posts.aspx files and then reload your page.  You should see your changes reflected.

How to customize Breadcrumbs on site settings pages in Sharepoint 2010

2010 December 23
by mark

I wanted the breadcrumbs to look similar to the way they did in Sharepoint 2003.  I found some good posts online showing how to do this, but then I found out pretty quick that the breadcrumbs weren’t working on my Site Actions-Site Settings pages.  The way I customized these breadcrumbs below is bad practice and in fact if you make changes like I do below your changes will probably get overwritten when you upgrade Sharepoint. That being said, I couldn’t find anyone else online that offered a solution that worked.  So this is how it’s going to be for now.

Here’s what I did.  I found out that all the Site Settings pages are aspx files in the _layouts directory, so I located the directory on my server at:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\template\layouts

Then I used a text editor to do a find and replace in all the files in this folder (over 100 files in total).  I found the following code:

<SharePoint:UIVersionedContent UIVersion="3" runat="server"><ContentTemplate>
<asp:SiteMapPath SiteMapProvider="SPXmlContentMapProvider" id="ContentMap" SkipLinkText="" NodeStyle-CssClass="ms-sitemapdirectional" RootNodeStyle-CssClass="s4-die" PathSeparator="&#160;&gt; " PathSeparatorStyle-CssClass = "s4-bcsep" runat="server" />
</ContentTemplate></SharePoint:UIVersionedContent>
<SharePoint:UIVersionedContent UIVersion="4" runat="server"><ContentTemplate>
<SharePoint:ListSiteMapPath runat="server" SiteMapProviders="SPSiteMapProvider,SPXmlContentMapProvider" RenderCurrentNodeAsLink="false" PathSeparator="" CssClass="s4-breadcrumb" NodeStyle-CssClass="s4-breadcrumbNode" CurrentNodeStyle-CssClass="s4-breadcrumbCurrentNode" RootNodeStyle-CssClass="s4-breadcrumbRootNode" HideInteriorRootNodes="true" SkipLinkText="" />
</ContentTemplate>
</SharePoint:UIVersionedContent>
<SharePoint:UIVersionedContent UIVersion="3" runat="server">
<ContentTemplate>
<asp:SiteMapPath SiteMapProvider="SPXmlContentMapProvider" id="ContentMap" SkipLinkText="" NodeStyle-CssClass="ms-sitemapdirectional" RootNodeStyle-CssClass="s4-die" PathSeparator="&#160;&gt; " PathSeparatorStyle-CssClass = "s4-bcsep" runat="server" />
</ContentTemplate>
</SharePoint:UIVersionedContent>
<SharePoint:UIVersionedContent UIVersion="4" runat="server">
<ContentTemplate>
<SharePoint:ListSiteMapPath runat="server" SiteMapProviders="SPSiteMapProvider,SPXmlContentMapProvider" RenderCurrentNodeAsLink="false" PathSeparator="" CssClass="s4-breadcrumb" NodeStyle-CssClass="s4-breadcrumbNode" CurrentNodeStyle-CssClass="s4-breadcrumbCurrentNode" RootNodeStyle-CssClass="s4-breadcrumbRootNode" HideInteriorRootNodes="true" SkipLinkText="" />
</ContentTemplate>
</SharePoint:UIVersionedContent>

And also I had to replace this code as well:

<SharePoint:UIVersionedContent UIVersion=”3″ runat=”server”><ContentTemplate>

<asp:SiteMapPath

SiteMapProvider=”SPXmlContentMapProvider”

id=”ContentMap”

SkipLinkText=”"

NodeStyle-CssClass=”ms-sitemapdirectional”

RootNodeStyle-CssClass=”s4-die”

PathSeparator=”&#160;&gt; ”

PathSeparatorStyle-CssClass = “s4-bcsep”

runat=”server” />

</ContentTemplate></SharePoint:UIVersionedContent>

<SharePoint:UIVersionedContent UIVersion=”4″ runat=”server”><ContentTemplate>

<SharePoint:ListSiteMapPath

runat=”server”

SiteMapProviders=”SPSiteMapProvider,SPXmlContentMapProvider”

RenderCurrentNodeAsLink=”false”

PathSeparator=”"

CssClass=”s4-breadcrumb”

NodeStyle-CssClass=”s4-breadcrumbNode”

CurrentNodeStyle-CssClass=”s4-breadcrumbCurrentNode”

RootNodeStyle-CssClass=”s4-breadcrumbRootNode”

HideInteriorRootNodes=”true”

SkipLinkText=”" />

</ContentTemplate></SharePoint:UIVersionedContent>

And I replaced the above 2 code blocks with the following code:

<asp:SiteMapPath SiteMapProvider=”SPXmlContentMapProvider” id=”ContentMap” runat=”server”/>

After I did this, it looks like the breadcrumbs are now fixed on all my Site Settings pages.  I have a bad feeling that I will regret doing it this way, but like I said I couldn’t figure out a better way.  And if it comes down to it and I run into a problem I can always reverse the steps above and put the old code back in.

NOTE: You might have to rearrange your design if you do exactly what I did above.  My design works well with the above changes because I’ve hidden the page title.   If I unhide the page title, then my breadcrumbs run right over top of my page title and I would need to move the page title.

No Search Results Show up for Anonymous Users in Sharepoint 2010

2010 December 22
tags:
by mark

This drove me nuts.  Everytime I would search as a logged in user my search results would show up, but whenever I did a search with an anonymous user nothing would show up.  I searched Google and found alot of posts like this telling you to set “Always index all web parts on this site.”  I tried that and then re-indexed the site and still no search results were returned for anonymous users (NOTE: In order for my solution to work, you will still need to do the steps in this post).

While digging around I found out that my “Intranet” profile was not set to allow anonymous users.  So in order to change this.  I did the following:

  • In Central Administration click on Manage Web Applications under the heading Application Management
  • Click on the Web Application that you want to be searchable to highlight it
  • Click on the Authentication Providers button in the ribbon
  • I had 2 zones listed.  Default and Intranet.  When I clicked on Default the Anonymous Access checkbox was already checked, however, when I clicked on Intranet zone the Anonymous access box was not checked.  I checked this box and then clicked the Save button.

    Allow Anonymous Access for all Zones

  • I then re-indexed the site

After I did this the searches started working for anonymous users

Can’t edit code on Sharepoint 2010 pages like results.aspx in Sharepoint Designer

2010 December 21
tags:
by mark

I was trying to edit part of the results.aspx page in Sharepoint Designer 2010 and it wouldn’t let me type where I wanted to.  After some trial and error I realized that it was preventing me from editing any code that was highlighted with a orangish peach color.

Sharepoint Designer won't let you edit code that is highlighted like this

Sharepoint Designer won't let you edit code that is highlighted like this

After much frustration and trying different things like trying to edit a copy, I finally found the “Advanced Mode” button in the ribbon in Sharepoint Designer.  If you click this button it will then allow you to edit the code.  Thank you Microsoft for protecting me… that was said with some sarcasm.  I understand that Microsoft would do something like this to help reduce the chances that people would make mistakes and end up completely fubaring their entire site but I feel like if you’ve made it this far to open up some obscure aspx page and are using Sharepoint designer you should be given some credit rather than wasting a half hour of your time trying to figure out why you can’t edit the text.

Clicking the Advanced Mode button will allow you to edit text that was previously protected

Clicking the Advanced Mode button will allow you to edit text that was previously protected

How to Fix – Sharepoint 2010 search not indexing pages on HTTPS (SSL) site because of error with certificate

2010 December 20
by mark

Sharepoint 2010 searches would return no entries for my site.  I looked in the Crawl Log in Central Administration and was repeatedly getting 6 errors.

Sharepoint 2010 Crawl Logs

Sharepoint 2010 Crawl Logs (note that the first line has no errors because this was taken after I fixed the problem)

The errors mentioned that there was problems with indexing the site because of problems with the HTTPS (SSL) certificate for the site.  Well, since we have a very small sharepoint install (one server), and I know the SSL cert is good I don’t care if sharepoint thinks the certificate is bad.  I just want SP to index the sites.

Solution
So I finally figured out how to fix this.

  1. In Sharepoint Central Admin click on “General Application Settings” on the left menu on the Central Admin homepage
  2. Then click on “Farm Search Administration” under the Search icon
  3. It will take you to a page with “Farm-Level Search Settings.”  One of these is Ignore SSL Warnings.  It should say No next to it by default.  Click No.
  4. A window will pop up that will allow you check a box the Ignore SSL certificate name warnings.  Check this box and click OK.
    Have Search Ignore SSL Certificate name warnings
  5. After you do this you will need to re-index your site.
    • To do so go back to the Central Admin homepage and click “Manage Service Applications” under the Application Management heading.
    • On the list of services click “Search Service Appilcation.”
    • Click “Content Sources” in the left menu and then click the name of your Content Source, mine is “Local Sharepoint sites.”
    • Next scroll down to the bottom of the screen and check the box that says “Start full crawl of this content source.”  Then click ok and it should start indexing your site.Force full indexing crawl of your site

Now your search should work!

How to get around the windows 2008 2TB limit?

2010 December 1
by mark

I had a disk that was 2.2 TB but when I opened disk management in the Server Manager, it showed that the disk was split into 2 unallocated partitions, one that was 2 TB and one that was 168 GB.  By default Windows 2008 R2 automatically sets new disks as MBR, which has a limit of 2TB, and therefore it splits it into two partitions.

If you want only one partition, right click on the disk in Disk Management (in the Server Manager), and select “Convert to GPT.” This will convert the disk to use GUID Partition Table (GPT), and you should then see the disk with one complete unallocated partition with OVER 2TB.  Here’s a document at Microsoft that discusses GPT.  Keep in mind that you can only do this before you put data on the drive, and also using GPT has it’s considerations as well, so you will want to read documentation about GPT to make sure it’s what you want.

What RAID Stripe Size should I use for SQL Server 2008? What Partition Offset should I use for SQL Server 2008? What File Allocation Unit Size (cluster size) should I use with SQL Server 2008?

2010 November 30
by mark

When creating my RAIDs for a SQL server I first had the question, what RAID Stripe Size is optimal for SQL Server 2008?  While searching for an answer to this question, I found out that it’s not all about the RAID Stripe Size, you also need to set the correct Partition Offset and File Allocation Unit Size (cluster size).  I am using Windows Server 2008 R2 and SQL Server 2008 R2 and based on my research I think these settings below work the best for my environment, however, please read this extremely good microsoft document for more information on what settings you should use since they are different depending on your setup.

  • I decided to stick with the defaults on my RAID card for a stripe size of 64kb
  • For partition offset I’m using 64kb
  • For File Allocation Unit Size (cluster size), I’m sticking with the Windows 2008 default of 1024kb

Setting the RAID card stripe size is done through the RAID configuration.  This will be different for every RAID card, so I won’t go into this.

However, here is an example from Microsoft on how to set the partition offset and file allocation size. Keep in mind these settings can only be made before you start using the disk to store data, since it will FORMAT your drive.

C:\>diskpart
Microsoft DiskPart version 6.0.6001
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: ASPIRINGGEEK
DISKPART> list disk
  Disk ###  Status      Size     Free     Dyn  GPT
  --------  ----------  -------  -------  ---  ---
  Disk 0    Online       186 GB      0 B
  Disk 1    Online       100 GB      0 B
  Disk 2    Online       120 GB      0 B
  Disk 3    Online       150 GB   150 GB
DISKPART> select disk 3
Disk 3 is now the selected disk.
DISKPART> create partition primary align=1024
DiskPart succeeded in creating the specified partition.
DISKPART> assign letter=F
DiskPart successfully assigned the drive letter or mount point.
DISKPART> format fs=ntfs unit=64K label="MyFastDisk" nowait

So hopefully this helps a little with creating the disks for a optimal SQL setup.  When I get a chance I will post another article about what RAID configurations you should use for optimal SQL server set ups.

How to do two finger pinch zoom on iPhone emulator in xcode

2010 November 18

This is something pretty basic that I end up forgetting every few months.  To do two finger pinch and zoom or two finger gestures in the iPhone simulator simply hold option down while you click in the emulator and it will show the position of the two fingers.

The credentials you provided for the SQL Server Agent service are invalid. Error During SQL Server 2008 Install

2010 November 17
by mark

SQL Server Installation Error - The Credentials you provided for the SQL Server service are invali

The credentials you provided for the SQL Server Agent (or Database Engine or etc) Service are invalid. To Continue, provide a valid…

I run into this error almost everytime I install SQL Server 2008, because I’m not thinking and I try to install SQL Server while logged onto windows with a local user account.

If you want to install SQL Server 2008 and have it use Domain credentials to start the service accounts as I was trying in the picture above, you need to be logged onto the box as a Domain user NOT a local user.  You will also want to be sure that this Domain user has administrator privileges to your server or else you might run into some other problems in the install.