Making Sense of the SharePoint World

Jun-262009

SharePoint Service Pack 2 Repair Patch

MCSY00579_0000[1]"You Are Now Free to Upgrade Your Servers..."

Several weeks ago, Microsoft released Service Pack 2 for SharePoint. It was great! SP2 fixed many problems, large and small, as well as introduced a feature to scan your environment for potential upgrade issues.

There was just one problem. If you were running anything other than plain Windows SharePoint Services (WSS), SP2 would trip an expiration flag that made your computer think you were running an evaluation version. For many users this was just a little inconvenience. You could simply re-enter your product key, and the timeout would be removed. Unfortunately, users of Microsoft Search Server 2008 Express (MSSX) were in a pickle. For you see, MSSX doesn't have a license key.

Of course, MSSX user or not, Microsoft didn't plan for SP2 to do this. So they have been working diligently to come up with a patch to resolve the issue. As of last night, that patch has been released. You can read about the details, and/or download it, on the SharePoint Team Blog, or KB Article 971620.

So, install the patch, apply Service Pack 2, and the April 2009 cumulative update package, and you'll soon be SharePoint-ing your way into the future!


Jun-182009

A Peek Under the Hood

MCj03347000000[1]

What Makes The Sanity Point Run?

Today I'm going to give you a little peek under the hood of my new site. I'll compare what I used before, and what I have now, and how that impacts what I could do. Then I'll go into some technical detail about my current environment, and point out a few things to look for when selecting your own provider. Finally, I'll show you how I customized what I got from the ISP to produce The Sanity Point you are reading now.

The Importance of Dedication

Although I have brought most of my articles over from my previous blog, in many ways this site is the polar opposite of what I had before. The biggest change, of course, is that I have moved from a shared hosting environment (Office Live and Windows Live Spaces) onto a dedicated server. The key difference is, as its name implies, on a shared environment, your web site is using the same hardware as other users - potentially many others; while on a dedicated server, you are the only person on the box.

This greatly impacts what you are allowed to do with your site. Virtually all shared hosting providers pre-configure their servers with a selection of templates, tools, and utility applications (e.g. eStores, blog software, etc...). The usually allow (but don't always encourage) you to upload your own pages and images (typically via FTP or FrontPage extensions), and may offer connectivity to some shared database resources for server-side scripting. However, because you are sharing the host with other users, you won't usually be allowed to create compiled applications, or install and use components that the ISP hasn't already provided.

With a dedicated server, on the other hand, the ISP usually sets up a box, installs an OS, maybe some Antivirus software and a few free utilities, and hands you an administrator password. From then on, it is essentially "your box". Unless you buy enhanced support, the only thing they'll do is poke the power switch if you accidentally shut it down or otherwise lock it up, reset the admin password, or replace a component that gets fried. Otherwise, you are on your own and free to install any (legal) software, and customize the environment to your heart's content.

Yes, Virginia... You can Run SharePoint on Windows Web Server

Of course, with that freedom comes additional responsibility. Since only you know what you plan to do, you have to be careful in choosing options. Ordering a dedicated server is just like buying one for your own office. You need to consider:

  • The Operating System (Windows or a Linux/Unix variant)
  • The CPU
  • How much memory to order
  • How much network bandwidth you expect to use

And, of course, all of this is tempered by how much you can afford. Dedicated servers can get very expensive. If you look around, though, you can find some decent deals. The provider I chose, for example, (APlus.net) offers dedicated servers for as little as $45 a month.

In my case, since I wanted to run SharePoint, my first requirement was running Windows Server. That slimmed my choices a little, but not by much. Since I was only going to get a single box, for Internet-only users, and wasn't going to be running a domain, that made the obvious choice Windows Web Server 2008.

I can hear some of you saying "But wait! You can't run SharePoint on the Web Edition of Windows!!" Well, I'm pleased to say, that isn't entirely accurate. There has never been any restriction against running SharePoint on any edition of Windows Server. However, with Windows Server 2003 web edition, you weren't allowed to install a database server on that edition. This meant you needed at least two boxes in order to run SharePoint, which made dedicated hosting prohibitive for most users.

The good news is, with Windows Web Server 2008, Microsoft no longer has that restriction, so now you can effectively create a low-cost single-box SharePoint environment for Internet sites with either Windows SharePoint Services, or Search Server Express. That's what I've done here. While you can technically install WSS on 512MB, it really doesn't work very well, so I bumped the memory up to 3GB (the most SharePoint can effectively use on 32-bit Windows). I'm also running a dual-core CPU. This results in the Windows about page shown below:

img2

Note: APlus doesn't offer Web Edition in 64 bits, but for my usage, 32-bits is fine. By the time SharePoint 2010 rolls around with its 64-bit requirement, I'll be ready to replace this server.

Installing My Stuff

After sitting down and figuring out my realistic usage, I decided to directly install SQL Server 2008 Express and do an advanced Search Server 2008 Express installation, rather than setting up a basic Windows SharePoint Services install first. While this does limit me to 4GB per database, even for the WSS content databases, it also allowed me the full flexibility to set my service accounts and decide how to manage my databases.

Rule #1: Default Settings + Internet Facing = Bad Move!

Once I had SharePoint (well, MSSX) installed, all that gave me is the default stuff of SharePoint:

image

Now, that's all great, but if I just wanted the stock SharePoint look, I could have used a shared hosting provider. So next I added the Community Kit for SharePoint: Enhanced Blog Edition (CKS:EBE), and a few other goodies that I wanted to use in my sites. I've used the Intensive Theme in the past:

image

But again, I wanted something a bit more unique. So, with SharePoint Designer in hand, I took creating and applying a theme I call "Sanity Road", which is the theme you see today.

image

Going Beyond

Of course, going to a dedicated server is usually overkill if you only have one site, and can be a little flexible in your demands for customization. In my case, however, I'm going to use the server for some other things, such as demonstrations, and hosting other personal and community sites not necessarily related to SharePoint.

In this article, I've tried to give you a feel for the tasks involved in selecting and setting up hosting on a dedicated server. I hope you have found it helpful!


Jun-172009

Sample Chapters Online

MCj04379900000[1]A Taste of "Professional SharePoint Designer"

I am pleased to announce that Microsoft has posted two chapters from "Professional Microsoft Office SharePoint Designer 2007" on MSDN. This is the book I spent the better part of last year writing, along with Asif Rehmani and Bryan Phillips. In the approximately six months since its release, Pro SPD has received excellent reviews, now you can see why for yourselves with the following chapters:

Chapter 11: Advanced Data Access: External Data and More

Chapter 15: Creating Workflow Elements in Visual Studio

These two chapters give you a taste of the breadth and depth you will find in the book, including creating views of complex hierarchical data from Web services, and how to extend the power of SharePoint Designer's workflow capability with custom Actions.

Now that Microsoft has made SharePoint Designer available as a free download, having good documentation available is even more important than ever. I'm sure once you have checked out the samples, you're going to want to buy the rest!


Jun-142009

Move in Progress - You Found It!

MCj01051840000[1]

Congratulations! You've found my new site.

This article is just a place-holder while I'm waiting for DNS to update world-wide. Then I'll be able to update my RSS feed and get back into the swing of things. Until then, I've copied over most of my articles (even with their original publish dates). I'm still updating tags, my blog roll, etc... so you may see some more changes in the left column, but the main stuff is all here.

Enjoy!


Published: Jun-14-09 | 0 Comments | 0 Links to this post
Tagged as: Blog, General, Design