Wednesday, March 24, 2010

Some helpful Links for MOSS Administrators

Administrator Guides
· MOSS 2007 - Administrator Guide
· WSS 3.0 - SDK
· WSS 3.0 - Technical Library
· MOSS 2007 - Newly published content
· WSS 3.0 - Newly published content
· WSS 3.0 - SharePoint Server 2007 Developer Portal
· WSS 3.0/MOSS 2007 - Office SharePoint Server 2007 Administrator's Companion
· Complete reference of all PSCONFIG operations


Best Practices
· Before You Begin with SharePoint Server 2007
· Best Practices Analyzer for WSS 3.0 and MOSS2007
· Writing SQL Syntax Queries for Relevant Results in MOSS2007
· Backing Up and Restoring Web Sites w/ Stsadm
· MOSS 2007 - Planning and Architecture for Office SharePoint Server 2007


Search
· Configure the Office SharePoint Server Search service
· Configure Office SharePoint Server Search to crawl Lotus Notes
· Security considerations for search
· Overview: Plan search
· White paper: Evaluation guide for search in Office SharePoint Server
· Plan to deploy index and query servers

STSADM Commands
· Jose Barreto's Blog Complete reference of all STSADM operations (with parameters) in MOSS 2007 SP1

Publishing Templates

When you are working with MOSS 2007 there are two different templates you need to be able to deploy; application templates (WSP files) and site templates (STP files).

While creating an STP file from a site is easy and it makes it available within SharePoint for use, if you script any of your actions, you need to deploy your STP file globally. To do that you are going to need to download the STP file from the site Gallery and then delete it for the gallery. If you don't delete it you will have duplicate templates when we are done.

Once you have the file downloaded you will need to copy it to your web front end server. Once copied we will do the following from the command line using stsadm:

1. Check if the template already exists:
stsadm -o enumtemplates
2. If the template exists, you will need to delete the current copy:
stsadm -o deletetemplate -title {template title}
3. Now you can add the template:
stsadm -o addtemplate -filename {template filename & location} -title {template title} -description {template description}

It will prompt you that an IIS reset is needed at each of these steps, but in reality it is not required and can wait until a time that works for your environment.

The other deployment that you will need to be able to perform is a GAC deployment of an application template. This is also done on the web front end server using stsadm.

1. Add the application template to the solutions list:
stsadm.exe -o addsolution -filename {template filename & location}
2. Deploy the solution to the GAC:
stsadm.exe -o deploysolution -name {template filename} -immediate -allowgacdeployment
3. Copy the Binary Content:
stsadm -o copyappbincontent


So now you know how to deploy global site templates and applicaion template solutions.

Wednesday, March 10, 2010

My Site Link is broken!

So the other day I had to delete the My Site of a couple users who had left, I have done it a million times and never had a problem. That day a couple hours after the deletion, I get a communicator from a user, I can't edit My Links, it keeps asking for a username and password, but won't take it... Further investigation reveals that when clicking on My Site on the title bar does the same thing. What was strange was it worked if you used the actual URL.

Time to do some research, here is what I found...
Sometime when you are using Site Settings -> Delete this Site it accidentally deletes the My Site Host. Not a big deal but a pain in the butt, so here is how to fix that pain without Preparation H.

1. Go to Central Administration and click on Application Management.
2. Under SharePoint Site Management click Create Site Collection.
3. Choose your My Site Web Application and give it a title of My Site
4. Choose the My Site Root (should be there by default)
5. For Template, under the Enterprise Tab -> choose My Site Host
6. Enter in your Site Collection Administrator Account and an Alternate
7. Choose a Quota (if Applicable)
8. Click OK.

It will plug away and when completed should show you a link to your My Site. Test it out, it should now work.

Hope that helps someone out there.

Monday, March 8, 2010

My Links are Broken!

Ever have a user come to you and say "My Links are broken!"? If you haven't, just wait, you will...

My Links is a different animal from other Links in MOSS, the actual list behaves differently and if you ever tried to find it in the SQL server you know it is stored differently as well.

To answer your first question... Where is My Links stored? It can be found in your Default SSP inside the UserLinks table, that's right I said the Default SSP.

Now the way the table is built is quite simple, you have your Id, which is the Row identifier and primary key.
The RecordId, which is actually used to identify who owns the link stored in the row. It is not the User's actual Id, but is an Id that is arbitrarily assigned to each user (Makes it tough to find things...).
The Title, which is the first peice of usable information you can use to identify what needs to be changed, this information is the Title the User entered for the name of the Link.
The GroupType identified whether the link is part of a subgroup or not (2 - No Group, 0 - is a Group Member).
The GroupTitle is the name of the Group, it is only populated when the group type is value 0.
The URL is the place we need to go to fix the link. It contains the link info.
The ContentClass and PolicyId must serve a purpose, but I am unconcerned with them right now...
Lastly is the ItemSecurity, which identifies how the user intended to share the link.

To correct a broken link you will need to find the culprit, the user usually knows what link they entered that broke it, but in some cases they may be blissfully ignorant of what they did. A few hints into what breaks my links. The link needs to be invalid, but not a broken link... That means it is valid in most situations, just not in My Links. As an example using file: requires three slashes /// not two, as some people may enter, in most situations two slashes work, but not here... So you should look for any links that are file:// and replace them with file:///.

How do you do that? First you need to run SQL Server Management Studio (for 2005 or 2008) as a user with update permissions to the database, find the link that is causing the problem using either a Script table as -> SELECT TO -> New query editor window or using Open Table. Once you have identified the problem, either delete the row or fix the problem and commit the change.

Hope that helps...

Dave