See solution here:

http://rehmangul.sauftveyr.com/2008/04/23/can-not-add-the-user-because-a-user-with-that-name-already-exists/

Worked for me.

Thanks to Rob Fisch at LinkedIN.

It’s true. Even with WSS2 (Sharepoint 2003) and Outlook 2003 there was an ability to view SharePoint calendars, right from Outlook. But there was no way to overlay the information together all in one calendar view. With WSS3 (or MOSS 2007) and Outlook 2007, we have the ability to not only view activity from multiple calendar sources in one virtual calendar view, but we can also edit these SharePoint calendars directly from Outlook. We can also tack on Outlook reminders to SharePoint Calendar events.

Read the full article:

http://www.mssharepointtips.com/tip.asp?id=927

Here is a list of common illegal characters that must not be included in web urls – - – and not used when creating file names that will be used on the web:

# % & * { } \ : < > ? / +

In addition to this list it is prohibited to have consecutive periods in the URL (or file name). It’s also prohibited to start or end with a space or underline, or to end with a period.

Even though it isn’t illegal to use commas or spaces in a url – it is best to not use them for consistency across different server platforms.

These rules are Web Standards.

Important things too know about using TODAY in a calculated column!

http://www.linkedin.com/news?viewArticle=&articleID=185992482&gid=93094&type=member&item=28659782&articleURL=http%3A%2F%2Fblog%2Epentalogic%2Enet%2F2010%2F09%2Ftoday-sharepoint-calculated-default-values%2F&urlhash=q1qF&goback=%2Egde_93094_member_28659782

A life saver of an article from Ben.  I used these steps to recreate the default dispform.aspx page!

You need to edit a line of code in SharePoint Designer

• Go to Code View
• FIND:  “Placeholderleftnavbar”
• Delete Row (approx. line 47) that has that above code
• OK to Change site definition

SSO Single Server Sign On

Add Application Services in Central Admin

1. Operations Tab
2. Manage Settings for SSO

Ensure SSO Service is Running (If you get a “Failed to Connect…”)

1. Start/ Admin Tools/ Services
2. Open Microsoft Single Sign On Services
3. Log On Tab
4. Best Practice to use to Server Admin Account (from A.D.) not the Local System Account
   1. Provide Name Password
5. General Tab
   1. Start Service/ OK

1. Manage Settings for SSO
   1. Manage Server Settings
   2. Provide an SP SSO Admin Account
   3. Provide Enterprise Application Definition Admin Account (usually the same as SSO Admin Account)
   4. Creates a SSO DB (Server Name, DB name)
   5. Click OK
2. Manage Settings for Enterprise Application Definitions (link)
   1. Create a New Item for Each Back end system that will be used to with each application requiring connection.
   2. Display Name for SSO Admin
   3. Application Name that Site Admins will use to connect (No Spaces)
   4. Contact e-mail for back end db
   5. Account Type (best practice GROUP)
   6. Authentication Type (Leave blank so that no authentication is required).  This will allow for the passing of credentials
   7. Create a SP Name and Password for this Application Definition.  Ok to leave defaults (“Username” [mask NO], “Password” [mask YES]).  Not a best practice!
3. Manage Settings for SSO
4. Manage Account Info for Enterprise Application Definitions
   1. Provide account information that is going to be passed.
   2. Pick Enterprise App Definition created in Step 3.
   3. Provide Group name (See step 6 below)
   4. Click SET to provide User Name and Password for Enterprise Application.  (Best Practice to not provide Enterpise App Sys Admin.  Use a Enterpise App Read Only Account),
   5. Click OK/ Done

Active Directory (use to find AD Groups)

1. 1. Start/ Admin Tools/ AD Users and Computers
   2. Get name and verify membership

1. Manage Encryption Key
   1. Click Create Encryption Key
   2. Click OK/ OK

• • NOW TO USE SSO!

1. You will be using the Application Name (not Display Name) to make a connection to the db)

In SP Designer

1. 1. Go to Data View Menu
   2. Click Insert Data View
   3. From Task Pane Connect to a Data Base
   4. Click Configure Database Connection
   5. Server Info is where (SQL Server is running)
   6. Authentication (USE SSO)
   7. Click Settings
   8. Provide Application Name (Step 3c, no spaces) and
      Application Username and Password (Step 3g)
   9. Click Next/ Select Database/ Select Table
   10. Click Finish/ Ok to make the connection

Another GREAT tip from Christophe at Path to SharePoint

=IF([Status]=””,”Black”,IF([Status]=”Choice1?,”Red”,IF([Status]=”Choice2?,”Gold”,IF([Status]=”Choice3?,”Green”,IF([Status]=”Choice4?,”DarkBlue”,IF([Status]=”Choice5?,”DarkCyan”,IF([Status]=”Choice6?,”DarkRed”,IF([Status]=”Choice7?,”Gray”,””))))))))&IF([Status]=”Choice8?,”MediumSlateBlue”,IF([Status]=”Choice9?,”SpringGreen”,IF([Status]=”Choice10?,”MidnightBlue”,IF([Status]=”Choice11?,”Sienna”,IF([Status]=”Choice12?,”SlateGray”,IF([Status]=”Choice13?,”OliveDrab”,IF([Status]=”Choice14?,”Gray”,””)))))))

Published Excel Spreadsheets do NOT support

• VBA macros
• Toolbox controls
• XLM Sheets
• Embedded Clip art
• Cell and Sheet BG Pictures
• IRM Enabled Workbooks
• Forms Controls
• MS 5.0 Dialogues
• Active X Controls
• DDE Links
• Query Tables
• Split Panes
• Headers Footers
• Page Layout View
• Cell Patterns
• Zoom

http://www.5min.com/Video/How-to-Modify-the-Layout-of-a-Defaultaspx-Page-in-MS-SharePoint-Designer-80729198?

Good demo for SPD beginners.

http://www.5min.com/Video/How-to-Customize-List-View-Pages-in-MS-SharePoint-Designer-80729533

I’ve used this before. Great solution for collapsing a multiple-line of text field. Solution created by Paul Grenier and enhanced by Pater Allen.

Haven’t tried this, but posting it here for future reference. The one shortcome in converting a list into XSLT in SPD is the fact that the grouping will not count the number of items for its group. This SharePoint Designer trick looks to be the solution.

Thanks Tudor!

Another great solution from Path To SharePoint. This links also includes a screen cast.

The Web Part can be used on a SharePoint 2007 site by anybody who has design or full control permissions (it is actually based on a Content Editor Web Part). The installation does not require server access.

Great idea from Jim Howard for creating section breaks in a Display Form or Edit Form.

Sometimes there are instances where page functionality is not operating as it should. The GUI is not letting you edit a page or remove a corrupt web part. Here I will start listing those URL appendices that will get you to the mode you need:

Put a page in EDIT mode.

Index Crawl: minimum 15 min.
5,000 sites takes 15 min. to replicate

When you create an SSP you need to create a crawl account
If crawl account is Admin Right, then it will crawl major and minor versions.

stsadm-0 command resets Admin password

Manage File Type to include PDFs

ifilter.org: install on front end server.

Thanks to Rob Fisch on LinkedIN.

With WSS3 (or MOSS 2007) and Outlook 2007, we have the ability to not only view activity from multiple calendar sources in one virtual calendar view, but we can also edit these SharePoint calendars directly from Outlook. We can also tack on Outlook reminders to SharePoint Calendar events.

Read the full article:

http://www.mssharepointtips.com/tip.asp?id=927

See discussion at microsoft.public.sharepoint.portalserver

Solution provided by Dessie Lunsford at EndUserSharePoint.com.