# Monday, February 15, 2010

Windows version/edition (64 bit only)

SharePoint 2010 support

Windows Server 2008 R2 Foundation

No

Windows Server 2008 R2 Standard

Yes

Windows Server 2008 R2 Enterprise

Yes

Windows Server 2008 R2 Datacenter

Yes

Windows Web Server 2008 R2

No

Windows HPC Server 2008

No

Windows Server 2008 R2 for Itanium-based systems

No

Windows Server 2008 Standard

Yes

Windows Server 2008 Enterprise

Yes

Windows Server 2008 Datacenter

Yes

Windows Web Server 2008

No

Windows Storage Server 2008

No

Windows Small Business Server 2008

Yes*

Windows Essential Business Server 2008

Yes*

Windows Server 2008 for Itanium-based systems

No

Windows Server 2008 Foundation

No

Windows Vista

Developer-only**

Windows 7

Developer-only**

posted on Monday, February 15, 2010 10:48:13 AM (GMT Standard Time, UTC+00:00)  #    Comments [2] Trackback
# Tuesday, January 12, 2010
  • The hardware and software must meet or exceed the minimum system requirements to run the new version.
    This includes the requirement for 64-bit hardware and 64-bit versions of the operating system and Microsoft SQL Server. For more information about minimum requirements click here

 

  • Office SharePoint Server 2007 must be updated to Service Pack 2
    Your environment must be updated to at least Service Pack 2 of Office SharePoint Server 2007 to run the upgrade process, either for an in-place or database attach upgrade.
posted on Tuesday, January 12, 2010 8:11:06 AM (GMT Standard Time, UTC+00:00)  #    Comments [1] Trackback
# Friday, January 08, 2010

Microsoft published model describes common ways to build and scale farm topologies by using Microsoft SharePoint Server 2010, including planning which servers to start services on.

You can download it as pdf, vsd or xps file.

posted on Friday, January 08, 2010 8:21:09 AM (GMT Standard Time, UTC+00:00)  #    Comments [1] Trackback

Access Services : Enables users to view, edit, and interact with Microsoft Access databases in a Web browser.

Application Registry Service : Enables users to search and collaborate around business data.

Business Connectivity Services : Enables structured data from line-of-business applications, such as SAP and Siebel systems, to be integrated into SharePoint Server "14".

Excel Services : Enables users to view and interact with Microsoft Excel spreadsheets in a Web browser.

Lotus Notes Connector : Enables users to search data on a Lotus Notes server.

Managed Metadata Service : Enables teams or departments to manage their own taxonomy, hierarchies, keywords, and social tagging infrastructure, so that, for example, taxonomies and content types can be shared across the organization (across site collections and web applications)

People : Enables users to search for people within their organization to, for example, find skills, memberships within enterprise communities, and shared interests.

Performance Point Service : Balanced scorecard and dynamic dashboard tool that allows power users/IT to create dynamic and highly interactive dashboards that display strategy to operations. Performance Point Services allows you to combine multiple data sources, and objects providing a single view of the business.

Search Service Application : Enables user to index content, gather information, and perform search queries.

Secure Store Service : Enables users to store data securely, and associate it to a specific identity or group of identities.

State Service : Enables users to temporarily store user session data for SharePoint Server "14" components.

Usage and Health Data Collection : Collects farm-wide usage and health data, so that users can view usage and health reports.

Visio Graphics Service : Enables users to view and refresh published Visio diagrams.

Word Conversion Service Application : Enables users to perform automated bulk document conversions.

References : http://sharepoint-sandbox.com

posted on Friday, January 08, 2010 7:13:29 AM (GMT Standard Time, UTC+00:00)  #    Comments [3] Trackback

The following tables have been added:

  1. AllFileFragments
  2. AllListAux
  3. AllListPlus
  4. AllListUniqueFields
  5. AllLookupRelationships
  6. AllWebParts (Renamed from WebParts)
  7. CustomActions
  8. Resources
  9. SharedAccessRequest
  10. SiteDeletion
  11. SolutionResourceUsageDaily
  12. SolutionResourceUsageDailyOriginal
  13. SolutionResourceUsageLog
  14. SolutionResourceUsageLogWindowed
  15. Solutions
  16. WebsPlus

Removed Tables:

  1. Categories
  2. Image0x
  3. WebCat
posted on Friday, January 08, 2010 7:07:59 AM (GMT Standard Time, UTC+00:00)  #    Comments [1] Trackback
# Sunday, February 15, 2009

If you want to import a site, only a site you can use the following stsadm commands to export it from the old system and import it to the new Sharepoint system.

Export Site 

stsadm.exe -o export -url  http://localhost/<your_site>  -filename c:\folder\your_site.cab  

Import Site 

stsadm.exe -o import -url  http://localhost/<your_site>  -filename c:\folder\your_site.cab

posted on Sunday, February 15, 2009 9:32:43 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback
# Thursday, February 12, 2009

Alternate Access Mapping enables you to access your Sharepoint site via url like http://myPortal instead of hiting the server name at http://moss01server.

To fix it, you can define DNS (A) host entries, you can also define URL's like http://myPortal.myDomain.com. And then you can configure the alternate access mapping.

1. Go to Central Administration for your WSS or MOSS instance.

2. Click on the Operations Tab

3. Click on Alternate Access Mappings under Global Configuration

4. You should now see a list of your web applications, switch over to the one you want to map to the new URL by selecting it from the drop down on the right side.

5. Click on Edit Public URLs and change the desired zone URL type to your new domain name. You can also change your internal URLs also by clicking Add Internal URLs.

posted on Thursday, February 12, 2009 9:47:02 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback
# Monday, February 02, 2009

If you want to learn about the auditing support built into Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007, and how to extend this support with the custom Item-Level Auditing solution, you must read this interesting article on MSDN by Ted Pattison from the Ted Pattison Group and Joanna Bichsel, Microsoft.

Article : http://msdn2.microsoft.com/en-us/library/bb397403.aspx?wt.slv=topsectionsee

posted on Monday, February 02, 2009 9:05:17 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback
# Wednesday, January 28, 2009

The workbooks that you want to access must be placed in a trusted location. If not, the calls to open the workbook will fail. You can add a URL to the trusted location list by using the SharePoint 3.0 Central Administration page. Alternatively, you can use script to create a batch file.

-----------------------------------------------
@ECHO off
REM
REM Script to add a URL or site to the trusted location list
REM Last Updated: 11/2/05
if "%1" == "/?" GOTO Help
if "%1" == "" GOTO Help
SET LocationType=SharePoint
for /f "usebackq skip=3" %%i in (`%windir%\system32\cscript /nologo %windir%\system32\iisvdir.vbs /query "Office Web Services"`) do set variable=%%i
set sspname=%variable:~1%
:Arguments
if "%2" == "Unc" SET LocationType=Unc
if "%2" == "UNC" SET LocationType=Unc
if "%2" == "unc" SET LocationType=Unc
if EXIST "%commonprogramfiles%\Microsoft Shared Debug\web server extensions\12\BIN\stsadm.exe" (
SET STSADM="%commonprogramfiles%\Microsoft Shared Debug\web server extensions\12\BIN\stsadm.exe")
if EXIST "%commonprogramfiles%\Microsoft Shared\web server extensions\12\BIN\stsadm.exe" (
SET STSADM="%commonprogramfiles%\Microsoft Shared\web server extensions\12\BIN\stsadm.exe")
if NOT EXIST %STSADM% (
ECHO Error: STSADM.EXE cannot be found in your system.
GOTO Error
)
ECHO.ECHO Adding %1 to the Trusted Locations list ...
ECHO Type = %LocationType%
ECHO SSP Name = %sspname%
%STSADM% -o add-ecsfiletrustedlocation -ssp %sspname% -location %1 -includechildren true -locationtype
%LocationType% -allowexternaldata dclandembedded
-warnondatarefresh true -abortonrefreshonopenfail false
if NOT %ERRORLEVEL% == 0 (
ECHO Error: Error running stsAdm
GOTO Error
)
ECHO.
ECHO ********************************
ECHO %1 has been added
ECHO ********************************
ECHO.
PAUSE
GOTO End
:Error
ECHO.
ECHO ********************************
ECHO Failed!
ECHO ********************************
ECHO.
PAUSE
GOTO End
:Help
ECHO.
ECHO The command line syntax:
ECHO AddToTrusted
http:///customsite>
ECHO AddToTrusted
\\\foldername> unc
ECHO.
ECHO Examples:
ECHO C:\AddToTrusted
http:///customsite>
ECHO C:\AddToTrusted
\\\foldername> unc
PAUSE
GOTO End:
End

-----------------------------------------------

Save the file as AddToTrusted.bat and run it (Start>Run>cmd)

posted on Wednesday, January 28, 2009 8:54:55 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback
# Sunday, January 25, 2009

1. On the SharePoint Central Administration home page, click the Operations tab on the top navigation bar.
2. On the Operations page, in Topology and Services, click Servers in farm.
3. On the Servers in Farm page, click the server on which you want to configure the search service.
4. Click Start next to Office SharePoint Server Search.
5. On the Office SharePoint Server Search Settings page, in the Query and Indexing section, make sure that the Use this server for indexing content and Use this server for serving search queries check boxes are selected.
6. In the Default Catalog Location section, type a path to a physical folder to store the index files, or use the default location that is specified.
7. In the Contact E-Mail Address section, specify a valid e-mail address.
8. In the Service Account section, click Configurable, and in User name and Password, type the user name and password for the user account under which you want the Search service to run. The user account must be a member of the Administrators group on the computer that is running the Search service. If you want to use the principle of least privilege and select a unique user account that does not have administrative rights on your front-end servers or on your back-end database servers, see the Known Issues/Readme for Office SharePoint Server 2007 Beta 2. The user name must be in the format DOMAIN\username.
9. In the Web Front End And Crawling section, do one of the following:
If you are configuring the search service on a server that provides Web services and renders Web content, click No dedicated Web front-end computer for crawling

If you are configuring the search service on a server that is a standalone search server that does not provide Web services and render Web content, click Use a dedicated web front end computer for crawling, and then, in Select a web front end computer, click the computer you want to use for crawling.

posted on Sunday, January 25, 2009 12:34:47 PM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback

1. On the SharePoint Central Administration home page, click the Application Management tab on the navigation bar.
2. On the Application Management page, in the Office SharePoint Server Shared Services section, click Create or configure this farm's shared services.
3. On the Manage this Farm's Shared Services page, click SharedServices1.
4. On the Shared Services Administration page, in Search, click Search Settings.
5. On the Configure Search Settings page, in the Crawl Settings section, click Default content access account.
6. In the Default content access account section, in Account, Password, and Confirm Password, type the user name and password for the user account that you want to use to crawl content on your sites. This account must be a domain user account. It is recommended that you use the principle of least privilege and select a unique user account that cannot modify content and does not have administrative rights on your front-end servers or on your back-end database servers.
7. You can use the user account that you specified as the Office SharePoint Server 2007 service account; however, if that user account is a member of a security group that has administrative rights on your front-end servers or your back-end database servers, you will not be following the principle of least privilege. The user account that you specify will be added to the Web application Full Read policy for your farm. The user name must be in the format DOMAIN\username.
8. Click OK.
9. In the Crawl Settings section, click Content sources.
10. On the Manage Content Sources page, click Local Office SharePoint Server sites.
11. On the Edit Content Source page, in the Crawl Schedules section, under Full Crawl, click Create schedule.
12. In the Manage Schedules dialog box, configure schedule settings for full crawls of your content, and then click OK.
13. In the Crawl Schedules section, under Incremental Crawl, click Create schedule.
14. In the Manage Schedules dialog box, configure schedule settings for incremental crawls of your content, and then click OK.
15. In the Start Full Crawl section, select the Start full crawl of this content source check box, and then click OK.

posted on Sunday, January 25, 2009 12:30:40 PM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback

Configure surface area settings in SQL Server 2005 
      - Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
      - In the SQL Server Surface Area Configuration dialog box, click Surface Area Configuration for Services and Connections.
      - In the tree, open your instance of SQL Server, open Database Engine, and then click Remote Connections.
      - Click Local and Remote Connections, click Using both TCP/IP and named pipes, and then click OK.

Security account requirements
To install Office SharePoint Server 2007 in a server farm environment, at-least 2 accounts are required:

      - A user account that you can use to install Office SharePoint Server 2007 and run the SharePoint Products and Technologies Configuration Wizard. This account must be:
            - A domain user account.
            - A member of the Administrators group on each of your front-end servers.
            - A member of the SQL Server Logins, which grants login access to your SQL Server instance.
            - A member of the SQL Server Database Creator server role, which grants permission to create and alter databases.
            - A member of the SQL Server Security Administrators server role, which grants permission to manage server logins.
      - A unique domain user account that you can specify as the Office SharePoint Server 2007 service account. This user account is used to access your SharePoint configuration database. It also acts as the application pool identity for the SharePoint Central Administration application pool and it is the account under which the Windows SharePoint Services Timer service runs. The SharePoint Products and Technologies Configuration Wizard adds this account to the SQL Server Logins, the SQL Server Database Creator server role, and the SQL Server Security Administrators server role. It is recommended that you follow the principle of least privilege and do not make this user account a member of any particular security group on your front-end servers or your back-end servers.

posted on Sunday, January 25, 2009 12:24:23 PM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback

Before you install and configure Office SharePoint Server 2007, make sure your servers have the recommended hardware and software. To deploy a server farm, you need at least one server computer acting as a Web server and an application server, and one server computer acting as a database server. The server computers must meet the following requirements:

Hardware requirements

    Front-end Web server and application server computers: a dual-processor computer with processor clock speeds of 2.5-gigahertz (GHz) or higher and a minimum of 2 gigabytes (GB) of RAM. Back-end database server: a dual-processor computer with processor clock speeds of 2.0 GHz or higher and a minimum of 2 GB of RAM.

Software requirements Web and Application Server

    Microsoft Windows Server 2003 (Standard, Enterprise, Datacenter, or Web Edition) with Service Pack 1 (SP1) Microsoft .Net Framework 2.0 Microsoft .Net Framework 3.0 The Web server and application server computers must be configured as Web servers running Microsoft Internet Information Services (IIS) in IIS 6.0 worker process isolation mode. Each of the computers must be using the NTFS file system. Windows Server 2003 includes a conversion utility (Convert.exe) that you can use to convert an existing file allocation table (FAT) volume to NTFS without losing data.

Back-End Database Server
The back-end database server computer must be running Microsoft SQL Server 2005 or Microsoft SQL Server 2000 with Service Pack 3 (SP3) or later. It is assumed that you have installed and configured the database program on the back-end server computer. You do not need to set up or create specific databases for Office SharePoint Server 2007. The Office SharePoint Server 2007 Setup program will create the necessary databases when you install and configure Office SharePoint Server 2007.

posted on Sunday, January 25, 2009 12:11:57 PM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback

It's easy!!!
You can execute STSADM Utility with following parameters :

stsadm.exe -o backup -directory C:\BackupFolder -backupmethod full -url http://SiteURL -filename backup.dat -overwrite

posted on Sunday, January 25, 2009 8:51:34 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback

If you get "Enable ASP.NET extensions" message while installing MOSS 2007, run the following command:

aspnet_regiis -iru

You will find this utility in the following folders:

C:\Windows\Microsoft.NET\Framework\v1.1.4322
C:\Windows\Microsoft.NET\Framework\v2.0.50727

posted on Sunday, January 25, 2009 8:36:04 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback

If you installed and configured Office SharePoint Server 2007 on a single front-end server, and a user browses to your server, the server will render the content that is in your Web application. However, if you added subsequent front-end servers to your server farm, the newly-added servers will not have alternate access mappings configured to your Web application. To map newly-added front-end servers to your existing Web application, you need to configure alternate access mappings.

Before you configure alternate access mappings, install and configure Office SharePoint Server 2007 on all of the front-end servers that you want to add to your server farm, and make sure that the servers are joined to your server farm. See "Run Windows SharePoint Services Setup" and "Run the SharePoint Products and Technologies Configuration Wizard" for information about installing and configuring Office SharePoint Server 2007.
To configure alternate access mappings 


1. On the SharePoint Central Administration home page, click the Operations tab.

2. On the Operations page, in the Global Configuration section, click Alternate access mappings.

3. In Alternate Access Mapping Collection, click Change Alternate Access Mapping Collection.

4. In the Select an Alternate Access Mapping Collection dialog box, click the Web application that you want to modify. If you have created only one Web application, and you specified port 80 for the Web application, the Web application should be listed as SharePoint (80).

5. Click Edit Outbound URLs, and verify that your Web application is listed in the Default zone for outbound URLs. The outbound URL is the URL that you want users to use to access your Web application.

Note: If you have a load-balanced configuration with a host name, add the host name to the Outbound URL for the Default zone.

6. Click Save.

7. Click Add Incoming URLs.

8. On the Add Incoming URLs page, in New default zone URL protocol, host and port type the URL for the server that you want to map to your Web application. Typically, this is http://servername:portnumber/.

Note: If you have a load-balanced configuration, you should add the server name of each of your front-end Web servers to the list of internal URLs. This will allow each of your Web servers to reach the content in your common Web application. Also, make sure the zone you selected for the incoming URL matches the zone of the outbound URL for the load balancer. You can have multiple incoming URLs associated with a single outbound URL.

9. In Zone, make sure that Default is selected.
10. Click Save.
posted on Sunday, January 25, 2009 8:21:49 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback

1. On the SharePoint Central Administration home page, click the Application Management tab on the top navigation bar.
2. On the Application Management page, in the Office SharePoint Server Shared Services section, click Create or configure this farm's shared services.
3. On the Manage this Farm's Shared Services page, click New SSP.

Important: If you have not created a Web application for the SSP administration site, you need to create one before you create the SSP. If you have already created a Web application for the SSP administration site, skip to step 14.

4. On the New Shared Services Provider page, click Create a new Web application.
5. On the Create New Web Application page, in the IIS Web Site section, click Create a new IIS web site, and do not modify the default settings in this section.
6. In the Security Configuration section, under Authentication provider, select the appropriate option for your environment, and do not modify the default settings in the remainder of this section.
7. In the Load Balanced URL section, do not modify the default settings.
8. In the Application Pool section, click Create new application pool.
9. In Application pool name, enter the name of your application pool or use the default name.
10. Click Configurable, and in User name and Password, type the user name and password for the user account under which you want the application pool to run. The user account does not have to be a member of any particular security group. It is recommended that you use the principle of least privilege and select a unique user account that does not have administrative rights on your front-end servers or on your back-end database servers. You can use the user account that you specified as the Office SharePoint Server 2007 service account; however, if that user account is a member of a security group that has administrative rights on your front-end servers or your back-end database servers, you will not be following the principle of least privilege. The user name must be in the format DOMAIN\username.

11. In the Database Name and Authentication section, verify the database information and make sure that Windows Authentication (recommended)is selected.
12. In the Search Server section, do not modify the default settings.
13. Click OK. Upon successful creation of the Web application, the New Shared Services Provider page appears.
14. In the SSP Name section, in Web Application, select the Web application that you created for the SSP, and do not modify any of the default settings in this section.
15. In the My Site Location section, do not modify any of the default settings.
16. In the SSP Service Credentials section, in User name and Password, type the user name and password for the user account under which you want the SSP to run. The user account does not have to be a member of any particular security group. It is recommended that you use the principle of least privilege and select a unique user account that does not have administrative rights on your front-end servers or on your back-end database servers. You can use the user account that you specified as the Office SharePoint Server 2007 service account; however, if that user account is a member of a security group that has administrative rights on your front-end servers or your back-end database servers, you will not be following the principle of least privilege. The user name must be in the format DOMAIN\username.
17. In the SSP Database section, you can either accept the default settings (recommended), or specify your own settings for the database server, the database name, or the SQL authentication credentials.
18. In the Search Database section, you can either accept the default settings (recommended), or specify your own settings for the search database server, the database name, or the SQL Server authentication credentials.
19. In the Index Server section, in Index Server, click the server on which you configured the Search service.

Note: If there is no index server listed in the Index Server section, then no server in your farm has been assigned the index server role. To assign the index server role to a server in your farm, follow the instructions in the "Configure the Search service" section earlier in this topic.

20. In the SSL for Web Services section, click No.
21. Click OK. Upon successful creation of the SSP, the Success page appears.
22. On the Success page, click OK to return to the Manage this Farm's Core Services page

posted on Sunday, January 25, 2009 8:21:00 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] Trackback