Saturday 16 February 2008

Firefox: Goodbye 3rd Party Cookies!

I love and hate cookies. I love the fact that I can go to certain
"safe" sites and they'll remember certain settings. Google, PageFlakes, Blogger, etc. would be good examples of this.
Then there's the other guys... I don't want everyone and their mother knowing what I browse, or when. To increase my privacy I like to disable 3rd Party cookies, but the DEVs removed the simple click-box to do this in later version of Firefox.
Here's how to add it back:

1. Type in about:config in the address bar and hit enter
2. Edit the value for network.cookie.cookieBehavior and set it to 1.
1 = Accept cookies from this site only, 0 = accept all cookies, 2 = accept no cookies, 3 = use P3P policy

...I also modified the network.cookie.lifetime.days value so that the cookies expire much sooner.
Check out this MozillaZine page for more great info.

Thursday 14 February 2008

IIS 6 ASP.NET Website Permissions Error

If you're ever trying to get a website to load properly in IIS 6.0 and you keep seeing this:
"Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. "


In your browser, followed by an event in the application log that starts with this:
"Failed to initialize the AppDomain:/LM/W3SVC/1/Root"

And you're using the Network Service account to run your worker process here's some steps that should get you up and running...
1. Ensure that you've granted the Network Service the "Local Launch" and "Local Activation"permissions. (Component Services -> Computers -> My Computer -> DCOM Config -> IIS Admin Service -Right-Click-> Properties -> Select the Security tab, and set the permissions)

2. Locate the file system directory that you've mapped to the IIS virtual directory and edit the permissions to grant at least Read & Execute, List Folder Contents, and Read to the IIS_WPG account.

Make sure the worker process is running and then try again. With any luck your application will display in the browser properly!

Cheers!

Monday 11 February 2008

How To: Unlock Protected Excel Worksheet with a Password - Without the Password!

I went to modify a worksheet today that's used for tracking a few things, but found that I couldn't change the period of the report. The group who was responsible for posting these was behind in doing so and I really wanted to fill out the report before I forgot what I wanted to put in it.
This meant I had to find a way to unprotect the sheet without a password.
Easier done than said!

I opened the workbook, opened up the VB Editor and typed in the following code:
Sub NoProtection()
With ActiveWorkbook
ActiveSheet.Protect Password:="abc"

ActiveSheet.Unprotect Password:="abc"
End With
End Sub

That's it! The previous password is overwritten, then the sheet is unlocked.

...and that's why you never rely on Excel worksheet protection to protect anything.

Disclaimer: This was Excel 2003... Haven't tested if this still works with 2007