Today I arrived in Seattle for the MVP summit, the trip was a little more exhausting that I would have liked as I didn’t get any sleep on the flight from Melbourne to LA, then my connecting flight from LA to Seattle was delayed about 1 hour as we waited for a fuel truck to show up and refill our plane. All up I think I’ve been up for about 26 hours, but to sit in my hotel with this view it’s almost worth it.
Tomorrow it’s off to the first day of the summit which should be great, not to mention Seattle has turned on it’s best rainy weather for this week so I’ll get to experience some winter weather (you know real winter weather not like that mixed up season Melbourne gets :o)
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.