A Stack Overflow Sidebar Gadget

Update: The gadget (which now also supports both Serverfault.com and SuperUser.com), with source code, is now available on CodePlex.com.

I have been following the progress of the Stack Overflow web site since it has started. In fact, I did also participate in the beta testing of the site. In podcast episode #54 , Jeff announced that they are adding the functionality to put a flair on your home page or blog. That’s a really nice idea.

One thing that would be even more cool is to have your flair as a Windows Vista / Windows 7 Sidebar Gadget. So I decided develop one. Why not? On the screenshot below you can see how it looks like. Please consider this first release as a beta release. If you find something odd, please email me.image

Download from here. Disclaimer:
It works on My Machine.

Works-on-my-machine-starburst

image

image

image

When you have installed it, it says that you must enter your user id.

image image

So, hover over to the right of the gadget, and click the Options icon.  Now, in order for it to work, you must provide it with your Stack Overflow user id. You can find it in the URL of your user profile page.

image

Enter your user id in the User Id textbox and click ok.

image

Now, it should display your Stack Overflow flair ! Now go over to Stack Overflow and ask or answer some questions.

If you like this gadget, please consider a donation to keep it updated.

Donate

A list of recommended MOSS Service Accounts

Account Type
Purpose
Account Name
MOSS Farm Account

Server Farm Account. This account needs some SQL permissions granting: dbcreator and security admin (do not grant this account SA!). If using ADACM this is the account used for creating objects in the OU specified – so you’ll need to delegate permissions on the OU to this user.

svcMOSSFarm1
MOSS App Pool Identity for the any MOSS Web App Application Pool(s). A separate process identity should be used for each content Web App (this allows for greater security and auditing). Using the site name in the naming is not advisable as although this may make troubleshooting and auditing easier it reduces security by showing the relationship between App Pools and Web Apps.

svcMOSSAppPool1
svcMOSSAppPool2
svcMOSSAppPool3

SSP Service Account SSP service account svcMOSSSSP1
SSP App Pool Identity for the SSP Web App Application Pool svcMOSSSSPAppPool1
MOSS Search Account under which the Office SharePoint Server Search runs under. svcMOSSSearch1
MOSS Content Access Account used to access content sources to be crawled and indexed. Need to grant this account permission to any NON-MOSS content sources (e.g. NTFS file share, Exchange public folder, websites etc…)Separate accounts may be configured for access to specific content sources using crawl rules. svcMOSSCrawl1
User profile & Properties Access Account Account used to access Active Directory for the Profile import svcMOSSDSA1
WSS Search Account which the Windows SharePoint Services Search service runs under. Due to the fact the Office SharePoint Server Search service is running this will only index the WSS Help files. svcMOSSWSSSearch1
WSS Content Access Account used by WSS search service to crawl content. svcMOSSWSSCrawl1
MOSS Install Account Account used to install MOSS and perform all the required configuration changes.As this account will be used to install and configure the SharePoint servers it must be granted local admin on all farms members and have permissions to the SQL instance.This account can be disabled after installation and configuration is complete (it is not advised to delete it). svcMOSSInstall1
SQL Services Used to run MS SQL Services

svcSQLSVC1
svcSQLRS1
svcSQLAS1

 

This list is copied from Matt Grove, thanks Matt.

To make the creation of these accounts easy, I have created a VBS script that does the job.

Option Explicit
' =====================================================
' Author:        Magnus Johansson
' Create date:   12.08.2009
' Description:   Creates services acounts for the MOSS VPC
' File Name:     CreateMOSSServiceAccounts.vbs
' =====================================================
Dim strComputer
' Set the local computer name
strComputer = "."
' Run the Load method
Load
Sub Load()
Dim strPassword
strPassword = "Pa$$word"
' Create the service accounts
CreateUser "svcMOSSFarm1", strPassword, "MOSS Farm Account"
CreateUser "svcMOSSAppPool1", strPassword, "MOSS App Pool 1"
CreateUser "svcMOSSAppPool2", strPassword, "MOSS App Pool 2"
CreateUser "svcMOSSAppPool3", strPassword, "MOSS App Pool 3"
CreateUser "svcMOSSSSP1", strPassword, "MOSS SSP Service Account"
CreateUser "svcMOSSSSPAppPool1", strPassword, "MOSS SSP App Pool"
CreateUser "svcMOSSSearch1", strPassword, "MOSS Search"
CreateUser "svcMOSSCrawl1", strPassword, "MOSS Content Access"
CreateUser "svcMOSSDSA1", strPassword, "User profile & Properties Access Account"
CreateUser "svcMOSSWSSSearch1", strPassword, "WSS Search"
CreateUser "svcMOSSWSSCrawl1", strPassword, "WSS Content Access"
CreateUser "svcMOSSInstall1", strPassword, "MOSS Install Account"
CreateUser "svcSQLSVC1", strPassword, "SQL Services SQL Server"
CreateUser "svcSQLRS1", strPassword, "SQL Services SQL Reporting Services"
CreateUser "svcSQLAS1", strPassword, "SQL Services SQL Analysis Services"
MsgBox "Complete!"
End Sub
' Create the local user
Sub CreateUser(userName, password, description)
Dim objComputer
Dim objUser
' Check to see if the user exists; if so, then skip
If NOT CheckIfUserExists(userName) Then
Set objComputer = GetObject("WinNT://" & strComputer & "")
Set objUser = objComputer.Create("user", userName)
objUser.SetPassword password
objUser.FullName = userName
objUser.Description = description
objUser.Put "UserFlags", 65600 ' Sets Password Never Expires to TRUE
' and sets User Can't Change Password to TRUE
objUser.SetInfo
Else
MsgBox userName & " already exists!"
End If
End Sub
' Check to see if user exists
Function CheckIfUserExists(userName)
Dim objComputer
Dim intFound
Dim User
Set objComputer = GetObject("WinNT://" & strComputer & "")
objComputer.Filter = Array("user")
intFound = 0
For Each User In objComputer
If lcase(User.Name) = lcase(userName) Then
intFound = 1
End If
Next
If intFound = 1 Then
CheckIfUserExists = True
Else
CheckIfUserExists = False
End If
End Function

 

Then, follow a guide to install a complete MOSS setup.

How to install MOSS on Windows Server 2008 R2

First a disclaimer. Microsoft doesn’t support this scenario, so you will be on your own.

When you try to install MOSS 2007 on Windows Server 2008 R2, you will be prompted by this error message:

image

and you are stuck.

The only way to install MOSS 2007 on Windows Server 2008 R2 is to slipstream MOSS Service Pack 2 into the installation media. I will now run through the steps to do so.

Prerequisites:

  • MOSS 2007 installation media. (Either the .iso file from MSDN, or the DVD)
  • WSS 3.0 Service Pack 2 (Remember to get the x64 version, since Windows 2008 R2 is 64bit only)
  • MOSS 2007 Service Pack 2 (Remember to get the x64 version, since Windows 2008 R2 is 64bit only)

First, extract the contents of your MOSS 2007 media .iso file (or simply copy the files if you are using the DVD) to a temporary installation folder. In my case this will be H:\MOSS Installation Media. There is an TechNet article on how to slipstream updates into MOSS, but I will go through the steps here also.

Open a command prompt and change directory to where you have the service pack files. Extract the contents to the Updates folder of your installation folder.

First the WSS Service Pack files:

officeserver2007sp2-kb953334-x64-fullfile-en-us.exe /extract:"H:\MOSS Installation Media\x64\Updates"

Then the MOSS 2007 service pack files:

 

officeserver2007sp2-kb953334-x64-fullfile-en-us.exe /extract:"H:\MOSS Installation Media\x64\Updates"

 

Now, you will need to delete the file wsssetup.dll from the Updated folder, otherwise it will only install the WSS SP2.

You can now install WSS 3.0 and MOSS 2007 SP2 using set setup.cmd found in the installation folder.