• Change Service Account and The Password in MOSS and WSS 3.0

    I get the quesiton of how to switch the service account for MOSS and WSS 3.0 fairly often.   There are many reasons why one would want to change the account or the password to the account used for SharePoint. Microsoft has now put up a KB article on exactly how to do it. They even included a sample script!   Check out the KB article here: How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0    

  • Mobile View Doesn’t Work on SharePoint ( WSS 3.0) List

    I recently ran into a situation where I couldn’t get the ‘Mobile View’ in WSS 3.0 to work on a list that I had created. I went into the view of the list and selected the Mobile checkboxes (‘Make this a mobile view ‘ and ‘Make this the default mobile view‘), but it still was not showing up on my SharePoint site’s mobile homepage. My first thought was “What makes this list different than the other lists that have mobile views that are working?” The answer was easy: I had created the list by selecting Custom List in Datasheet View from the ‘Create’ page. There are no mobile view choices…

  • How to Enable Incoming Email within SharePoint 2007

        SharePoint 2007 allows for emails to be accepted into discussions, document libraries and lists. To enable this functionality, a few steps will need to be followed. One thing to note: integrating SharePoint with Exchange is NOT needed for this functionality, but if you do choose Exchange, you will get some added benefits.   -SMTP Service You will need to install the SMTP Server Service on the SharePoint server. This is done via add/remove programs, and within the IIS component listing.   -Enable Incoming Email Now, enable Incoming Email from the Central Administration website. It is found by following: Central Administration > Operations > Incoming Email Settings   -SMTP…

  • SharePoint Database Performance – Moving the SharePoint SQL Database to New Location on the Same Server

    I run an instance of WSS 3.0 on a machine at home for testing. I don't use it much because it is so slow unless you are on the LAN. I always knew it was because of SQL, but I didn't really have time to look into fixing it. See, I don't have the option of having two separate drives in the machine. NOTE: You should never run SQL databases on the same HD spindle where the OS is located due to exactly what I was experiencing: slow response. Then I woke-up to the year 2007 and apparently there are external HDDs you can buy…okay, I knew about them; I…

  • Exclude Managed Path

    In the SharePoint version 2.0 products, to exclude a directory from SharePoint “control”, you add an Explicit Exclusion to the Managed Paths for the site using the Central Administration Website. You also add Explicit Inclusions and Wildcard Inclusions at the same location. However, in SharePoint version 3.0 products, it is a bit different. You still create Explicit Inclusions and Wildcard Inclusions on the administration page for the site. However, to create an Explicit Exclusion, you just have to create a new Virtual Directory in IIS underneath the appropriate IIS Virtual Server. This is because ASP.NET knows that when you create a new virtual directory, it should not touch it. Pretty…

  • Differences between Windows SharePoint Services and Portal Server 2003 ( WSS vs. SPS )

    The question comes up pretty often: "Which product is right for me?" Honestly, there are many factors that come into play to answer that question: -Usability -Cost -Scalability -Flexibility   Microsoft has an article giving the feature differences between WSS and SPS 2003. Microsoft also has a white paper titled Implementing Rich Collaboration Infrastructure Using Microsoft Windows SharePoint Services and Microsoft Office SharePoint Portal Server 2003. The white paper does an okay job at describing the differences and I think everyone should take a look at it before deciding which SharePoint product to deploy.

  • My take on the Microsoft SharePoint Products and Technologies Resource Kit

    I think it is always good to remember the Microsoft SharePoint Products and Technologies Resource Kit has chapters online that are free to access. But, most people don’t know how this book can help them. So, here is the chapters listing along with some of my thoughts on the chapter. Remember, my advice is to read the whole book BEFORE you deploy SharePoint into production! You will thank me later! Chapter 5 – SharePoint Portal Server ArchitectureThis is a good chapter to read up on how SharePoint Portal 2003 and WSS are different Chapter 6 – Security Architecture for SharePoint Products and TechnologiesThis is a good chapter to read to…

  • List Item Limits

    I was just reminded today about the limits on how many items you can have on a list. The limits are divided by the type of fields as dictated by the Microsoft article titled “Column Limit Exceeded” Message When You Add a New Column to a SharePoint Services List . Part of the article: With Windows SharePoint Services, you can create the following numbers of each column type for each list or library: – 64 Single line of text and Choice (drop-down menu or radio buttons) – 31 Multiple lines of text and Choice (check boxes (allow multiple sections)) – 32 Number and currency – 32 Hyperlink – 16 Date…

  • Viewing files in the GAC

    Many times I have needed to get a copy of the dll that is in the GAC for a webpart. I have been trying the different methods to get to the dll without the possibility of moving the reference to the GAC entirely (which you can do with the xcopy command! :-/ ) Here is a method I like: To view the physical file structure of the GAC, add a DWORD value named ‘DisableCacheViewer’ to the registry key HKLM\Software\Microsoft\Fusion and set it to a non-zero value. Works like a charm!