SharePoint Server 2007 Anonymous Access Gotcha!

Today for the first time I was attempting to create a SharePoint site with Anonymous Access. As I usually do when attempting to trying something new I fired up my MOSSDEMO image and promptly created a new web application. However after following all the steps to the letter in Inside Microsoft Office SharePoint Server 2007 book I was still being prompted for windows credentials when I attempted to access the site.

After attempting the set up 2 or 3 times it dawned on me, “I was using windows authentication to access the WSS_Content database” so when I hit my site SharePoint was passing through the authorisation request hence resulting in a prompt for windows credentials.

After creating a SharePointSvc account on my SQL server and setting up yet another web application my Anonymous access was up and running. Now to get forms authentication going!






Ok so put some egg on my face turns out my issue had noting to do with using a SQL account my problem was that my Network Service account didn’t have access to my WSS Content database, added the service account to my SQL server and Bob’s my uncle everything worked a treat.

2 thoughts on “SharePoint Server 2007 Anonymous Access Gotcha!

  1. Hey Benny, good post but are you sure you can’t have Windows auth with FBA?

    I’ve rolled it out several times and always kept Windows auth on with DB with the FBA front end.
    I believe Sharepoint doesnt really ‘passthrough’ the users login to access the content DB – MS only say that for the licensing 🙂

    – Once your done with your demo you can present it at MOSSIG :).

  2. I know it’s a 5-year old post, but for completeness sake I need to add that if you select the (recommended) Windows authentication method when adding a content database, SharePoint uses that Windows account to add the database. It *does not* pass through the visiting user’s credentials.

Leave a Reply

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