Tuesday, April 28, 2009

Installation of Certificate Server on Windows Server 2003 enterprise

Here are some easy steps for Installation of Certificate Server on Windows Server 2003 enterprise

  • Click Start, point to Control Panel, and then click Add or Remove Programs.
  • In Add or Remove Programs, click Add/Remove Windows Components.
  • In the Windows Components Wizard, under Components, select Certificate Services.
  • Read the warning about domain membership, and then click yes.
  • Click Next.
  • On the CA Type page, click Enterprise root CA, and then click next.
  • On the CA Identifying Information page, in the Common name for this CA box, type Server Name (CERT-CA1), and then click next.
  • On the Certificate Database Settings page, accept the defaults in the Certificate database box and the Certificate database log box, and then click next.
  • When prompted to stop Internet Information Services, click yes.
  • When asked if you want to enable Active Server Pages (ASP), click yes.
  • After the wizard completes the installation, click Finish.

Office 2003 documents Open in Read-Only Mode

If you click on an Office document in SharePoint to open it - it loads it in the relevant application, but in Read-Only mode. The way to open a document to edit - is to access the context menu and select "Edit in Microsoft Office Word. This is especially annoying when searching for documents, since the search results does not show the context menu and does not provide a link to the document library containing the document. So the only option is to load the document in Read Only mode but then to save it - the user needs to know which document library it belongs to and then manually navigate to it.
There is however a workaround as detailed in http://support.microsoft.com/?kbid=870853. It involves adding a new registry key on every desktop as follows:
1. Quit all Office 2003 programs that are running.
2. Click Start, click Run, type regedit in the Open box, and then click OK.
3. Locate and then right-click the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Internet
4. Point to New, and then click DWORD Value.
5. Type OpenDocumentsReadWriteWhileBrowsing, and then press ENTER.
6. Right-click OpenDocumentsReadWriteWhileBrowsing, and then click Modify.
7. In the Value data box, type 1, and then click OK.
8. On the File menu, click Exit to quit Registry Editor.

If you like, you can paste the following into a command box:
reg add HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Internet /vOpenDocumentsReadWriteWhileBrowsing /t REG_DWORD /d 1 /f

SharePoint Content Database Tables

Here are some importent tables of SharePoint Content Database

  • Features Table that holds information about all the activated features for each site collection or site.
  • Sites Table that holds information about all the site collections for this content database.
  • Webs Table that holds information about all the specific sites (webs) in each site collection.
  • UserInfo Table that holds information about all the users for each site collection.
  • Groups Table that holds information about all the SharePoint groups in each site collection.
  • Roles Table that holds information about all the SharePoint roles (permission levels) for each site.
  • AllLists Table that holds information about lists for each site.
  • GroupMembership Table that holds information about all the SharePoint group members.
  • AllUserData Table that holds information about all the list items for each list.
  • AllDocs Table that holds information about all the documents (and all list items) for each document library and list.
  • RoleAssignment Table that holds information about all the users or SharePoint groups that are assigned to roles.
  • SchedSubscriptions Table that holds information about all the scheduled subscriptions (alerts) for each user.
  • ImmedSubscriptions Table that holds information about all the immediate subscriptions (alerts) for each user.

Configuring Usage Analysis Processing using stsadm

I ran into a problem recently when attempting to enable and configure Usage Analysis Processing (UAP)using stsadm, I needed to do this as part of a fully scripted installation of MOSS 2007 that I was assisting a customer with. Looking at the stsadm documentation, the following commands are available:

stsadm -o setproperty
-propertyname usageprocessingenabled
-propertyvalue {Yes | No}
stsadm -o setproperty
-propertyname job-usage-analysis
-propertyvalue {Yes | No}


I then ran the following two commands to configure UAP:
stsadm -o setproperty -pn job-usage-analysis -pv "daily between 08:00 and 09:00" To configure the time that the process runs.
stsadm -o setproperty -pn usageprocessingenabled -pv "Yes” To enable Usage Analysis Processing.
However when I browsed to Central Administration – Operations – Usage analysis processing the following was displayed



If you look closely you can see that the time has been set correctly but it hasn’t enabled usage analysis processing. As you can see this is grayed out meaning that Enable logging must be selected before it can be enabled – but how do I enable logging? After much investigation I eventually found out (from a colleague- thanks Kirk) that the following stsadm can be used to enable this.
stsadm -o setproperty -pn loggingenabled -pv "Yes”To put this all together I need to run the commands in this order to achieve my objective:

• stsadm -o setproperty -pn loggingenabled -pv "Yes”
• stsadm -o setproperty -pn job-usage-analysis -pv "daily between 08:00 and 09:00"
• stsadm –o setproperty -pn usageprocessingenabled -pv "Yes”


Enterprise Content Management (ECM)

Hi All These are some good blogs and links for Enterprise Content Management

Blogs
==============
blogs.msdn.com/ecm/
blogs.msdn.com/ecm/archive/2006/06/09/624520.aspx
blogs.msdn.com/sharepoint/archive/2008/01/03/new-beta-extranet-collaboration-toolkit.aspx
blogs.msdn.com/.../30/announcing-the-first-release-of-the-microsoft-sharepoint-administration-toolkit.aspx

Sites
==============
office.microsoft.com/en-us/sharepointserver/HA101747881033.aspx
office.microsoft.com/en-us/sharepointserver/HA102063591033.aspx
msdn.microsoft.com/en-us/library/aa830818.aspx

YouTube
==============
www.youtube.com/watch?v=8zT4NsSSa6g

Other resources
===============
www.andrewconnell.com/blog/articles/MossWcmResources.aspx
www.microsoft.com/downloads/details.aspx?FamilyID=6D94E307-67D9-41AC-B2D6-0074D6286FA9
www.1stafftraining.com/b2b/outlines/1Staff_50003.pdf