Showing posts with label MOSS 2007. Show all posts
Showing posts with label MOSS 2007. Show all posts

Jan 12, 2009

MOSS / WSS Language Packs

To use vairaitions feature of MOSS / WSS for multiple languages you need to install following components in your dev enviornment.

Below is the list of components for english and french. If you need to manage any other langauge then just specify appropiate value for 'displaylang' parameter in URL


-------------------------------------
WSS 3.0 English x32 language packs
-------------------------------------
#SharePointLanguagePack.exe
#wssv3lpsp1-kb936988-x86-fullfile-en-us.exe
    WSS Service Pack 1

-------------------------------------
WSS 3.0 French x32 language packs
-------------------------------------
#SharePointLanguagePack-fr.exe
WSS x32 Lang Pack
#wssv3lpsp1-kb936988-x86-fullfile-en-us.exe
WSS x32 Service Pack 1 

-------------------------------------
MOSS English x32 language packs
-------------------------------------
#Serverlanguagepack.img (english)
MOSS English Language Pack
#officeserverlp2007sp1-kb936984-x86-fullfile-en-us.exe
MOSS x32 Service Pack 1

-------------------------------------
MOSS French x32 language packs
-------------------------------------
#Serverlanguagepack.img (French)
MOSS French Language pack
#officeserverlp2007sp1-kb936984-x86-fullfile-fr-fr.exe
MOSS x32 Service Pack 1


Sep 13, 2008

How to rename SharePoint_AdminContent_someGUID database?

Problem:

  1. Unable to specify config database name when you install MOSS 2007 / WSS 3.0 with help of wizard psconfiggui.exe(that appear just after SharePoint setup, with check box “Run the SharePoint Products and Technologies Configuration Wizard”). Configuration database name by default has weird naming convention that is “SharePoint_AdminContent_”. Typically in SharePoint it’s called configdb.
  2. Second problem, you are unable to use same database instance for more than one SharePoint farm. Or let’s put in other words, I want to share single SQL server for multiple SharePoint farms (not a best practice but sometimes we have to do :) ).
Solution:
Note: Post installation you are not allowed to rename this database name. 
So only solution left is to configure MOSS 2007 / WSS 3.0 with help of command line, see below steps.
  1. Run SharePoint installation (Server type=complete), uncheck “Run the SharePoint Products and Technologies Configuration wizard now”

  1. Open command prompt Start > run > cmd > cd c:\program files\common files\Microsoft shared\web server extenstions\12\bin
  2. Type following command (text in red color will be as per your environment, rest all should be as-is)
psconfig -cmd configdb create server "SQLServer" database WSS-Farm-configdb user domain\spsetup password "p@ssword" admincontentdatabase WSS-Farm-CentralAdmin

SQLServer: Name of the machine where sql server is installed
WSS-Farm-confidb: Now this is what you are specifying, otherwise if you use wizard it will be “SharePoint_AdminContent_
Domin\spsetup: A domain user that should be member of administrator group of all servers in farm(WFE and DB). Secondly it should have “securityadmin” and “dbcreator” role on SQL server with windows authentication
WSS-Farm-CentralAdmin: Database name of central administration web site.

Finally to complete installation run following commands
psconfig.exe -cmd adminvs -provision -port 12345 -windowsauthprovider onlyusentlm
psconfig.exe -cmd services install
psconfig.exe -cmd secureresources

Note
: Description of above three commands are available here

Feb 19, 2008

MOSS 2007 / WSS 3.0 Performance Handbook

This whitepaper is a quick reference for Microsoft office SharePoint Server (MOSS 2007) and Windows SharePoint Services (WSS 3.0) performance and capacity planning. It is a good starting point for those whose who would like to work on these areas.
Download pdf


Feb 9, 2008

Hide default title column in sharepoint list

In MOSS 2007 or WSS 3.0 sometimes you would like to:

  • Hide 'title' column OR
  • Change 'title' column to optional

Follow these easy steps:-

  1. Enable content type for list:-

    1. GoTo: List > Settings > List settings> Advanced settings

    2. Under “Content Types” change “Allow management of content types?” to “Yes”

    3. Click Ok

  2. Change “Title” column to optional/Hidden.

    1. On “list information” page, click “Item” link under “Content type” section

    2. On “List Content Type Information” page, under columns section click “Title”

    3. On “Change List Content Type Column: Item” page, click “edit column in new window”

    4. Under “Additional Column Settings” Change the “Require that this column contains information:” to “No”

    5. Click “Ok”

    6. Close window

    7. On “Change List Content Type Column: Item” page, under column settings select “hidden”


Feb 7, 2008

Show error details on MOSS / WSS site

Follow these easy steps

  1. Start > Run > inetmgr
  2. Right click on web application for which you want to enable error details.
  3. ASP.NET Tab, copy file location for web.config file
  4. Open file in notepad
  5. Make following changes

Old Value

New value

<SafeMode MaxControls="200" CallStack="false"><SafeMode MaxControls="200" CallStack="true">
<customErrors mode="On" /><customErrors mode="Off" />
<compilation batch="false" debug="false"><compilation batch="true" debug="true">




Jan 15, 2008

MOSS 2007 / WSS 3.0 site on Port 80 Internet and Intranet

Introduction
This post describes on how to configure Microsoft Office SharePoint Server (MOSS) 2007 site on port 80 for internet and intranet scenario.
It has following main five task:-

  1. Create Web application
  2. Extend Web application
  3. Configure IIS 6.0
  4. Alternate access mappings
  5. FQDN entry in DNS server

Prerequisites

  • Stop ‘Default web site’ in IIS 6.0.

Task1: Create Web application
In this task you will create web application.

  1. Central administration > Application Management > Create or Extend web application > Create web application
  2. The below table consists of values which will be required during the course of creating the “MOSS80” web application.

IIS Web Site 1. Create a New Web Site:
Description : ‘MOSS80’
Port : 80
Host Header: MYHOME
Security configuration 1. Authentication provider : NTLM
2. Allow Anonymous Access : No
3. User Security Socket Layer: No
Application Pool 1. Configurable
User name: <DomainAccount>
Password:<password>
Database Name and Authentication Database Server : MYDBSERVER
Database Name: MYHOME_Content_80
SQL Authentication: sa/password

Task2: Extend web application
In this task you will extend existing web application (the one which is created in task1)
  1. Central administration > Application Management > Create or Extend web application > Extend an existing web application
  2. The below table consists of values which will be required during the course of creating the “MOSS80Ex” web application.

IIS Web Site 1. Create a New Web Site:
Description : ‘MOSS80Ex’
Port : 80
Host Header: MYSTUDIO
Security configuration 1. Authentication provider : NTLM
2. Allow Anonymous Access : No
3. User Security Socket Layer: No
Load Balanced URL ZONE : Extranet

Task3: Configure IIS6.0
In this task you will enter additional host header values for two web applications which were created in task 1 and 2.

  1. Start > Run > inetmgr.exe
  2. Right click propertiese on “MOSS80” and then click ‘Advanced’ button as show below.
  3. Click Add and enter port 80 and host header MYHOME.datamatics.com as shown above.
  4. Right click propertiese on “MOSS80Ex” and then click ‘Advanced’ button.
  5. Click Add and enter port 80 and host header MYSTUDIO.datamatics.com as shown below

Task4: Alternate access mappings (AAM)
In this task you will add AAM for ‘MOSS80’ web application in SharePoint administration.

  1. Central administration > Operations > Allternate Acces mappings > Click on http://MYHOME
  2. Click Cancel button
  3. Click “Edit Public Zone URLs” as shown below

Task5: FQDN entry in DNS server
In this task you will enter host(MYHOME/MYSTUDIO) entries in DNS server
Adding Address and Pointer Records. The A record maps a host name to an IP address and the PTR record creates a pointer to the host for reverse lookups. Address and pointer records can be created together using the New Host option or separately using the New Record option.
Create a new host entry with A and PTR records by doing the following:

  1. In DNS Manager, right-click on the zone you want to update and then choose New Host from the pop-up menu. This opens the dialog box shown below.
  2. Enter the host name(MYHOME/MYSTUDIO) and IP address and then select the check Associated PTR Record check box as shown below.
  3. Click Done when you are finished.

That's it, this will enable your MOSS 2007 site on port 80 for internet and intranet scenario.