Renaming a MOSS server

By peter.stilgoe









Steps necessary to rename your MOSS server:

NOTE: Use only letters, digits and minus for the machine name (so no underscores), max 15 characters.

Change each alternate access mapping for your MOSS/WSS deployment in Central Administration:
Open Central Administration, “Operations” Tab, “Alternate access mappings” link

Modify each mapping item to reflect your newly chosen server name

Use stsadm.exe to invoke the “renameserver” command option:

Open a command prompt window

cd “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN”

stsadm -o renameserver -newservername -oldservername

Rename your Server via Change Name Operation in Windows Server 2003:

Start Menu | Control Panel | System, “Computer Name” tab, “Change” button.

Input your new server name

Reboot the server NOW.

After reboot, open command prompt

cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

stsadm -o updatefarmcredentials -userlogin -password

iisreset /noforce

Check all application pool identities in IIS, update where the old machine name is still there.

If you already have a search index drop this, and rebuild it

Your server is now renamed.

Thanks to Mirjam Rename MOSS Server

Share

Leggi tutto

Why carry out regular ‘Full Crawls’ on your MOSS / Sharepoint farm

By peter.stilgoe









To be updated:

Reasons for an SSP administrator to do a full crawl include:

One or more QFE or service pack was installed on servers in the farm. See the instructions for the hotfix or service pack for more information.
An SSP administrator added a new managed property.
To re-index ASPX pages on Windows SharePoint Services 3.0 or Office SharePoint Server 2007 sites.
Note: The crawler cannot discover when ASPX pages on Windows SharePoint Services 3.0 or Office SharePoint Server 2007 sites have changed. Because of this, incremental crawls do not re-index views or home pages when individual list items are deleted. We recommend that you periodically do full crawls of sites that contain ASPX files to ensure that these pages are re-indexed.

To resolve consecutive incremental crawl failures. In rare cases, if an incremental crawl fails one hundred consecutive times at any level in a repository, the index server removes the affected content from the index.
One or more crawl rules have been added or modified
To repair a corrupted index
The system does a full crawl even when an incremental crawl is requested under the following circumstances:

An SSP administrator stopped the previous crawl.
A content database was restored.
A full crawl of the site has never been done.
To repair a corrupted index. Depending upon the severity of the corruption, the system might attempt to perform a full crawl if corruption is detected in the index

Share

Leggi tutto

The ‘not so talked about’ limitations of MOSS 2007

By peter.stilgoe









1. 600 to 1000 unique list-item permissions. If you do a lot of “inheritance breaking” to create unique permissions within a list or library, this limit might hit you. A common scenario involves a list where a user can add an item, then a custom workflow is used to change permissions on that item to provide Edit Item permission to a “reviewer,” while preventing other non-reviewers in the list from modifying that item. But if you end up with more than 600 to 1000 items with unique permissions in a list, it will start to be problematic.

2. 1500 to 2000 contributing users in a site collection. Yup, you read that right. You can’t have more than 1500-2000 users contributing in a site. The limit is really 1500-2000 identities in the Site Collection User Info Gallery, aka the “SPWeb.SiteUsers.” A user ends up in this list if you add them directly to the site collection user list; create a permission for an object assigned to a user who’s not already in the list; or if the user is in a group that has permissions to the site and the user contributes to the site—is added to the Created By, Last Modified By, or Assigned To fields. The key here is those three fields. You can expose your site to millions of readers by using groups, or with anonymous access.

3. Approx. 2000 users or groups per SharePoint group. This is actually related to the 2000 item limit in list views.

4. Unique permissions (Access Control Entries or ACEs) per Access Control List (ACL). Behind the scenes, an ACL cannot be larger than 64KB. This translates to roughly 1000 users being individually assigned permissions on one object.

5. 1024 total (nested) Active Directory (AD) group memberships per user. This is a limit that affects other Windows technologies as well.

Are you likely to be “hit” by one of these limits? Some can be worked around through informed design. Others cannot. If these limits are in your present or future, then you must read Eli Robillard’s detailed coverage of the limits at Eli’s blog. Eli Robillard, also a SharePoint MVP, is a popular speaker, co-author of Professional SharePoint 2007 Development (Wrox), the founder of the Toronto SharePoint Users Group. The work he’s done, and the great contributions of Todd Bleeker, Todd Klindt, Joel Oleson and Keith Ritchie deserve a huge “shout out.” I know the details about these issues will evolve as more feedback is obtained from customers and as the SharePoint code and architecture is examined in more detail.

Read more HERE

Share

Leggi tutto

Hard coded limitations in WSS 3.0

By peter.stilgoe









Entity Max Permissible Size
Site Name 128 characters
Site URL 255 characters
Display name 128 characters
Connection string 384 characters
Email address 128 characters
Version numbers 064 characters
Virtual Server Friendly Name 064 characters
SQL Database Name 123 characters
SQL Database Column 128 characters
SQL Database Table Name 128 characters
SQL Role Name 128 characters
Server Name 128 characters
Windows User Name 300 characters
Windows Password 300 characters
Dependencies per object 032 objects
Zone enumeration value 004 zones
Default SQL command timeout 300 seconds
Number of simultaneous
workflows that can be run 015

Share

Leggi tutto

Customising people seach results in MOSS / Sharepoint

By peter.stilgoe









To customize the People Search Results:

1) Pull up a search results page by searching for a user

2) Click Site Actions > Edit Page

3) Modify the webpart called ‘People Search Core Results’

4) Expand “Results Query Options”, there is a field called “Selected Columns.” Click into this field and then click on the “…” that appears next to it.

5) In the Text Entry box you will be able to include new columns based on the columns you can reference from the user profile database. For example if you wanted to include a person’s mobile phone you’ll want to include

6) Now you’ll be able to edit the XSL to display the phone number using something like this:

<xsl:text>Mobile Phone: </xsl:text>
<xsl:call-template name=”DisplayOfficeProfile”>
<xsl:with-param name=”mobile” select=”mobilephone” />

(Example from Henry Ong)

For further customisation using SPD click here

Share

Leggi tutto

Using People Search in Sharepoint for Department Contacts

By peter.stilgoe









A simple yet effective solution from Paul Galvin:

This article describes how to use Microsoft Office SharePoint Server (MOSS) People Search to display department-level contacts in a simple-to-read grid format.

This solution arose from a consulting engagement. The client’s portal taxonomy included many corporate departments. Most departments wanted to display member’s contact information on their site’s main page. The client’s first impulse was to use a Contacts web part. That is not usually the best approach, however. Instead, leverage the People Search Core Results web part.

To achieve that result, we use the following SharePoint features and technology:

1. People Search Core Results web part

2. XSL

3. Visual Studio (optional but recommended)

This solution does not require any programming (at least in a C#/VB.NET sense). It does not require SharePoint Designer.

Overall, we follow these steps:

1. Locate the page where we want to add the department contacts.

2. Edit the page and add a People Search Core Results web part where appropriate.

3. Modify the web part for look and feel and query parameters.

4. Modify the web part’s XSL to display the data in a grid format (best done in visual studio, but any text editor will do).

Read the rest over at Pauls Blog Here

Share

Leggi tutto

Best Practices Resource Center for SharePoint Server 2007

By peter.stilgoe









To avoid common pitfalls and keep your Office SharePoint Server 2007 environment available and performing well, follow these best practices based on real-world experience from Microsoft Consulting Services and the product team.

Operational Excellence

Use 64-bit hardware, plenty of memory, and fast network cards

Stay close: Do not put too much network distance between front-end Web servers, application servers, and database servers

Configure front-end Web servers and application servers with performance and availability in mind

Team Collaboration Sites

Deploy 64-bit architecture across the farm

Plan and allocate database servers to support collaboration

Monitor sites and content and perform clean-ups regularly

Publishing Portals

Deploy at least three front-end Web servers

Make query-driven Web Parts efficient

Make sure that lists and databases follow recommended limits to optimize query performance

Search

Plan your deployment

Start with a well-configured infrastructure

Manage access by using Windows security groups

My Sites

Consider My Sites to be mini “team collaboration sites”

Plan for My Site content databases

Plan for My Site storage quotas

Read more here Best Practices Resource Center for SharePoint Server 2007

Share

Leggi tutto

Error: There is no file with URL ‘http://test-url’ in this Web.

By peter.stilgoe









This error seems to be related to document libraries where versioning is enabled or where content types are inheriting from other content types, more to follow shortly…..

Share

Leggi tutto

TIFF or PDF for your document imaging needs ?

By peter.stilgoe









PDF

An advantage of the PDF file format is that anyone can view the document using Adobe Acrobat® Reader, which is free software that can be downloaded from the Internet. This feature makes it very easy to share documents within or outside of an organization because everyone can view the document at no additional cost.

The PDF file format has become the de facto file format for the Internet. This is due to its small file size and the ability to begin viewing the document as soon as the first page downloads (other file formats require you to download the entire file before you can begin viewing the document).

A significant advantage of the PDF file format is that you can add document security at document level. Using Adobe Acrobat® and other third party plug-ins allows you to add file security to prevent unauthorized viewing of the document.

In addition, you cannot alter a PDF document without leaving an electronic footprint. This is a major reason why the U.S. Federal Judiciary has mandated its use for electronic filing of case documents. It also gives an organization the freedom to keep the scanned PDF images on a server to be shared throughout the organization, without the fear of document manipulation.

TIFF

Many document imaging companies that use the TIFF file format use proprietary software to view the TIFF images because the TIFF file format can utilize a variety of compression ratios. This can create a problem for your organization if you were to migrate your imaging system to a different vendor in the future. Your new vendor must have the ability to open and view your archived TIFF documents, which is frequently impossible.

Because of the requirement for proprietary viewing software, it may be difficult to share TIFF files with people outside of your organization. It is important to find out the cost of providing viewing software to outside parties that will be accessing and viewing your documents.

Since a TIFF image can be altered without leaving an electronic footprint, it will require you to save the document to an optical disk or a WORM drive as a read-only file. These devices restrict the ability to alter the document.

You can easily annotate TIFF files where as you can’t with PDF files without 3rd party tools.

Share

Leggi tutto

MOSS 2007 Enterprise search example SQL queries

By peter.stilgoe









Finds relevant results containing the keyword SharePoint.

SELECT WorkId,Path,Title,Write,Author,HitHighlightedSummary, HitHighlightedProperties,CollapsingStatusFROM Scope()WHERE FREETEXT(defaultproperties, ‘SharePoint’) ORDER BY Rank DescFinds relevant results containing at least one of the keywords SharePoint and Search.

SELECT WorkId,Path,Title,Write,Author,…FROM Scope()WHERE FREETEXT(defaultproperties, ‘SharePoint Search’) ORDER BY Rank DescFinds relevant results containing both the keywords SharePoint and Search.

SELECT WorkId,Path,Title,Write,Author,…FROM Scope()WHERE FREETEXT(defaultproperties, ‘+SharePoint +Search’) ORDER BY Rank DescFinds relevant results containing the exact phrase SharePoint Search.

SELECT WorkId,Path,Title,Write,Author,…FROM Scope()WHERE FREETEXT(defaultproperties, ‘ “SharePoint Search” ‘) ORDER BY Rank DescFinds relevant results containing both the keywords SharePoint and Search but not the keyword WSS.

SELECT WorkId,Path,Title,Write,Author,…FROM Scope()WHERE FREETEXT(defaultproperties, ‘+SharePoint +Search -WSS’) ORDER BY Rank DescFinds relevant SharePoint results authored by persons named John.

SELECT WorkId,Path,Title,Write,Author,…FROM Scope()WHERE FREETEXT(defaultproperties, ‘SharePoint’) AND CONTAINS(Author,’ “John” ‘)ORDER BY Rank DescFinds relevant SharePoint results modified within the last 30 days.

SELECT WorkId,Path,Title,Write,Author,…FROM Scope()WHERE FREETEXT(defaultproperties, ‘SharePoint’) AND Write<=DATEADD(DAY,30,GETGMTDATE())ORDER BY Rank Desc

Share

Leggi tutto

MOSS 2007 Search Query Web Service Test Tool

By peter.stilgoe









The search web service is located at http://your-portal/_vti_bin/search.asmx. It has been developed as a UI test tool for the WSS 3.0 and MOSS 2007 search web service. It allows you to change property flags, generate the request XML, send the string to the web service and see the results in the UI. The accessible methods include Query, QueryEx, GetSearchMetaData (available for MOSS only) and GetPortalSearchInfo (available for MOSS only).

Download here MOSS 2007 Search Query Web Service Test Tool

Share

Leggi tutto

SharePoint/MOSS Active Directory Self Service Web Part

By peter.stilgoe









A useful webpart from codeplex for allowing users to selfservice / update the following Active Directory info:

Fullname

Title

Work Phone

Department

Manager

SharePoint Active Directory Self Service Web Part

Share

Leggi tutto

Migrating an Access Database to MOSS / Sharepoint

By peter.stilgoe









You have an Access database which is currently being used within your company ie. Contacts, Sales Order Processing, Asset Logging etc etc…..And you now want to migrate it to Sharepoint/MOSS

You open your Access Database in Office 2007

You click the ‘External Data’ ribbon then select ‘Move to Sharepoint’

Now choose the Sharepoint site you wish to migrate the DB to & select the Document Library where you want to hold the access DB for linking back to Access forms & reports.

Click ‘Next’ then after a few minutes the migration completes with no errors…..good job!

That is until you goto access your views in Sharepoint & there is none there, then you realise your Access DB file hasnt actually uploaded.

Two reasons for this:

1) mdb files are restricted in Sharepoint by default so you need to remove mdb from the block list.

2) If your document library template has required columns set on it you will need to go into your document library settings & manage checked out files.

Note: If the ‘move to sharepoint’ feature is greyed out you need to convert your Access database to an Access 2007 database.

Share

Leggi tutto

Installing AvePoint 5.0

By peter.stilgoe









Update: After completely removing AvePoint & reinstalling with the new patches all works fine now.

AvePoint has just released version 5.0 of its SharePoint infrastructure management and protection solution. I recently installed this & for the short time I got to use it, it did look like a good product, a nice improvment on previous versions. I only got to use it for a short time because its management application, in particular the DocAveControl.exe process was using 100% CPU usage after a few minutes of operation.

After speaking to AvePoint support they have supplied me with a patch to upgrade the managment & agent applications to 5.0.0.1

The management server which we have the problem with is running Windows 2003 server SE SP1, .NET Framework 3.0

I will post back with more once the patches have been applied.

Share

Leggi tutto

Five tips to improve document management in MOSS 2007

By peter.stilgoe









Here are 5 tips Bob English gave about document management in Sharepoint at the Best Practices SharePoint Conference. Bob English is founder over at Mindsharp.

* Most important, English said, is to define a document’s lifecycle. This includes determining where a document will be incubated, what metadata will be in the document, who owns the document and when it should expire, among a number of other important details — all throughout its lifecycle.

* Be cautious of how you bestow access permissions to individual site administrators. Not every site administrator should be privy to all corporate information. With that in mind, when there is a different relationship between a document’s security, security nodes and site collection ownership, you need a different site collection. A site collection is a group of sites built on SharePoint that exist under a top-level site. Individuals have permission rights for sites and content within a site collection. “There are still people out there who think you need only one site collection, but it’s not true,” English said.

* Match the findability architecture with the metadata that is applied to the document. If people are going to find a document using the Advanced Search Web Part tool, the document’s metadata needs to be exposed to that tool. If you know that a document is in a particular department, with a particular security clearance and the author’s name and the topic, it’s more easily found in the Advanced Search Web Part than in simple search. But other methods of finding the document are helpful too. Pairing up how a document is described with the findability tools is imperative to helping achieve a fully functioning collaboration system.

* Make sure IT managers set the document library security settings before the document is put into the library. Some document library security settings are applied to the document when it is created and uploaded. The settings can’t be changed on documents that exist in the library. “Understand and know what security settings you want in your library settings,” he said.

Source: http://searchwinit.techtarget.com/news/article/0,289142,sid1_gci1332665,00.html

Share

Leggi tutto

Convert you physical MOSS machine to a virtual machine

By peter.stilgoe









You can do this using VMware Converter which will convert your physical machine into the VMware format which can then be run on VMware Server. Both of these products are free.

VMware Server

Begin enjoying the benefits of server virtualization with the free VMware Server. VMware Server is a hosted virtualization platform that installs like an application on any existing server hardware and partitions a physical server into multiple virtual machines. This next-generation version introduces an intuitive web-based management interface to provide a consistent management experience for Windows or Linux users.

- Provision a new server in minutes without investing in new hardware

- Simplify IT testing of patches, new applications and operating systems

- Run Windows, Linux, Solaris and Netware operating systems and applications concurrently on the same physical server

VMware Converter

Use the intuitive wizard-driven interface of VMware Converter to convert your physical machines to virtual machines. VMware Converter quickly converts Microsoft Windows based physical machines and third party image formats to VMware virtual machines. It also converts virtual machines between VMware platforms. Automate and simplify physical to virtual machine conversions as well as conversions between virtual machine formats with VMware Converter.

- Convert Microsoft Windows based physical machines and third party
image formats to VMware virtual machines

- Complete multiple conversions simultaneously with a centralized management console

- Easy to use wizards to minimize the number of steps to conversion

Share

Leggi tutto

SharePoint SUSHI – SharePoint Utility with a Smart, Helpful Interface

By peter.stilgoe









SUSHI is a powerful, user-friendly SharePoint application enabling you to accomplish common SharePoint administrative and development tasks. You can think of SUSHI as a Swiss army knife for SharePoint.

What does the name SUSHI stand for?

SUSHI = SharePoint Utility with a Smart, Helpful Interface

SUSHI Features

Copy View – Copy a view from one SharePoint list to another.

Security Reports – View all sites and lists a user has access to.

Import Documents – Upload entire file structures from a file share into a document library.

Meta Data – Get detailed information about metadata in a list. Move metadata from one column to another for all items in a list. And more.

Backup – Backup a site.

Restore – Restore site from backup.

Profile Images – Import Upload Profile Images and Apply them to User Profiles.

Delete Old Documents – Delete documents older than a given date. This feature can also be used to copy all files and folders of a document library to a file share.

Bulk Site – Creation Create a large number of subsites based on a site template.

Bulk List – Creation Create a large number of subsites based on a site template.

Bulk Webpart Customization – If you have lots of sites with the same webpart(s) and want to make changes to all of them, this tool can help you customize all the webparts at once.

Themes – Apply a Theme to many sites at once.

Email Test – Send a test email to make sure outbound email is set up correctly.

Help & Settings – We said SUSHI was helpful, here is the proof.

Sharepoint SUSHI

Share

Leggi tutto