• Usage Analysis Tools in SharePoint Products and Technologies

    Good TechNet article on how SharePoint uses access logs (it isactually a chapter from the Microsoft SharePoint Products andTechnologies Resource Kit which you can find here:http://www.microsoft.com/technet/prodtechnol/sppt/reskit/default.mspx): http://www.microsoft.com/technet/prodtechnol/sppt/reskit/c2961881x.mspx

  • Why information is kept about users deleted from site collections

    You can tell if the users have been deleted from the site collectionby looking at the UserInfo table of the content database. If the valueof the tp_Deleted column is 0, then the user is active in the sitecollection. Otherwise, they have been removed. SharePoint keeps this information around because it needs it to linkto the items placed on the sites. If it removed the users completely,the items would become orphaned.

  • Creating New Documents from library menu

    The article is a little hard to understand, but it has some prettygood information about creating additional buttons in libraries so youcan say “New Excel file” or “New Word file” no matter the defaultdocument library’s new file type: http://msd2d.com/newsletter_tip.aspx?section=sharepoint&id=cd3fd32d-b989-4bff-aae7-a65846b795b6

  • In pursuit of the least amount of SQL privileges

    There are some who want to find the least amount of privileges forSharePoint to have in SQL. So, to help out, here is what I have sofar: The account the SharePoint Application Pool is using needs to haveread/write privileges on the content database. It also needs to haveexecute privileges on stored procedures.

  • Host Headers, IIS, SharePoint, & SSL

    Some info on how IIS works with host headers and SSL:You shouldn’t have two sites setup with the same host header (even ifthey are on different servers, UNLESS you are using load-balancing!).A suggestion might be to call it site.dev.domain.com , site.qa.domain.com,site.domain.com as you go through devlopment, testing, and productionenvironments. Also, you have to understand how IIS works. It receives a request for“domain.com” and looks to see if there is a virtual server listeningon port 80 (because no port was defined in the request) that islistening for domain.com (using a host header). If it doesn’t findone, it looks for a site listening on port 80 with no host headerdefined. If it…

  • Change Application Pool on SharePoint IIS site

    To change the application pool for an existing Windows SharePointServices site (IIS virtual server):-Ensure that the new application pool is running under the sameidentity the old AppPool is running as. (if you don’t, then SharePointmay not be able to connect to the content or configuration database)-In IIS, expand Web Sites.-Right-click on the virtual server you want to change and select properties.-On the ‘Home Directory’ tab, under the ‘Application settings’section, change the ‘Application pool:’ to the new application pooland click Apply, then OK.-Back in the Internet Information Services Manager, expand the virtualserver you are changing by clicking the + sign beside the name.-For every Virtual Directory (default virtual directories for a…

  • Mapping a Window’s share to a SharePoint site

    You can map a network share to a SharePoint site (or individualdocument library) doing the following: net use s: http://sharePointserver/somesite/doclib Note that if there is a space in the path, you need to use quotesaround the url: net use s: “http://sharePointserver/somesite/shared documents” Also need to ensure the WebClient service is running.This would be really useful for automated uploading of documentsthrough scripts, etc. Sources:(http://www.sharepointu.com/forums/m_18100/mpage_1/key_//tm.htm#18872)

  • Moving WSS SQL databases to a new SQL server

    1-Copy the databases from the old SQL server to the new one.2-Then, in the config database on the new SQL server, open the Serverstable in the config database.3-Change the Name and Address fields that have the old SQL server nameto the new SQL server name.4-Open the SharePoint Central Administration page and click on “Setconfiguration database server” under the Server Configuration section.5-Change old SQL server name to new SQL server name. Click OK.6-Again on the SharePoint Central Administration page, click on“Configure virtual server settings”, and then click on a website youwant to change.7-Click on “Manage content databases” under Virtual Server Management.8-Click “Add a content database” and then ensure “Specify databaseserver settings”…