Software Application Support: February 2009

Wednesday, February 25, 2009

Configuring SharePoint Server 2007 (Part: 4)

Part 4: Configuring SQL Server 2005
Select Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration:

On the SQL Server 2005 Surface Area Configuration screen, click the Surface Area Configuration for Services and Connections link:

In the left pane, expand MSSQLSERVER, expand Database Engine, then select Remote Connections:

In the right pane, select the Local and remote connections option, select the Using TCP/IP and named pipes option, then click the Apply button.

In the Connection Settings Change Alert dialog box, click the OK button:

Click the OK button to close the SQL Server 2005 Surface Area Configuration screen:

Select Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio:

In the Connect to Server dialog box, leave the default settings and click the Connect button:

In the Microsoft SQL Server Management Studio window, right-click on the server name in the left pane, then select Properties:

In the Server Properties dialog box, select Memory in the left pane:

In the right pane, adjust the Maximum server memory to a value which is half of the memory allocated to your data tire server machine, then click the OK button; in this case, we’ve allocated 1000MB of memory to server, so the SQL Server memory was set to 500MB:

You should now have a fully-functional SQL Server 2005 installed inside datatire for storing SharePoint Server 2007 data.

Configuring SharePoint Server 2007 (Part: 3)

Part 3: Installing SQL Server 2005
As you read in my earlier post, we can configure SharePoint Server by two ways.
Refer: http://software-applications.blogspot.com/2009/02/determine-hardware-and-software.html
Before proceeding, here are a couple of assumptions:
1. You are configuring MOSS as server farm.
2. You are preparing database server as separate than application tire.

Insert the SQL Server 2005 installation media, start the installation, and then click Install: Server components, tools, Books Online, and samples:

In the End User License Agreement dialog box, read the agreement very carefully, select the I accept the licensing terms and conditions checkbox, then click the Next button:

In the Installing Prerequisites dialog box, click the Install button:

When the components are successfully installed, click the Next button:

On the installation wizard welcome screen, click the Next button:

On the System Configuration Check screen, after all tests have finished successfully, click the Next button:

On the Registration Information screen, enter your Name and Company, then click the Next button:

On the Components to Install screen, click the Advanced button:

On the Feature Selection screen, select the following features to be installed on the local hard drive, then click the Next button:

Database Services (all)

Analysis Services (all)

Reportiong Services (all)

Integration Services (all)

Client Components (all)

Documentation, Samples and Sample Databases

SQL Server Books Online

Sample Databases

AdventureWorks Sample QLTP

On the Instance Name screen, select Default instance, then click the Next button:

On the Service Account screen, select Use the built-in System account: Network service, select the SQL Server Agent and Analysis Services to start at the end of setup, then click the Next button:

On the Authentication Mode screen, select Windows Authentication Mode, then click the Next button:

On the Collation Settings screen, select Collation designator and sort order: Latin1_General, then click the Next button:

On the Report Server Installation Options screen, select the Install but do not configure the server option, then click the Next button:

On the Error and Usage Report Settings screen, deselect both options, then click the Next button:

On the Ready to Install screen, review the selected installation options, then click the Install button:

When component installation is complete, click the Next button:

When setup is complete, click the Finish button:

You should now have a fully-functional SQL Server 2005 installed inside your data tire.

Determine hardware and software requirements (Office SharePoint Server 2007)

This post describes the hardware and software requirements for installing Microsoft Office SharePoint Server 2007.

About hardware and software requirements

An installation of Office SharePoint Server 2007 can range from a single computer (stand-alone installation) to many computers (server farm). The requirements for your installation will depend on the availability and scale requirements for your solution. This post describes the minimum and recommended hardware requirements based on whether you are deploying a stand-alone installation or a server farm. This article also lists the software prerequisites for installing Office SharePoint Server 2007.

The hardware and software requirements described in this article apply to both x32-bit–based and x64-bit–based systems.

Note: Itanium-based systems are not supported.

Hardware requirements:

You can configure SharePoint server by two methods.

Standalone installation, in which you can use one server.
Server farm installation, in which you need to use minimum 2 servers and maximum 3 servers (Application Tire and Database Tire).

For both installation methods see the following table for min and max hardware requirement.

Component	Minimum	Recommended
Processor	2.5 GHz	Dual processors that are each faster than 2.5 GHz
RAM	2 GB	4 GB
Disk	NTFS file system–formatted partition with a minimum of 3 GB of free space	NTFS file system–formatted partition with 3 GB of free space plus adequate free space for your data storage requirements
Drive	DVD drive	DVD drive or the source copied to a local or network-accessible drive
Display	1024 × 768	1024 × 768 or higher resolution monitor
Network	 56 Kbps connection between client computers and server  For connections between computers in your server farm, 100 megabits per second (Mbps) connection	 56 Kbps or faster connection between client computers and server  For connections between computers in your server farm, 1 gigabit per second (Gbps) connection

Software Requirements:

Because Office SharePoint Server 2007 is built on Windows SharePoint Services 3.0, the requirements that apply to Windows SharePoint Services 3.0 also apply to Office SharePoint Server 2007.

I recommend that you install Office SharePoint Server 2007 on a computer that has a new installation of Windows Server 2003 with SP1 or later and all critical updates.

Operating system

Office SharePoint Server 2007 runs on Windows Server 2003 with SP1 or later. We recommend that you apply all critical updates. You can use the following Windows Server 2003 editions:

Windows Server 2003, Standard Edition
Windows Server 2003, Enterprise Edition
Windows Server 2003, Datacenter Edition
Windows Server 2003, Web Edition

Office SharePoint Server 2007 administration functions require Internet Explorer 6.0 with the most recent service packs or Internet Explorer 7.0.

Windows components

After you have installed the operating system and applied all critical updates, you must configure the computer to be a Web server by enabling IIS 6.0, including:

Common files
WWW
SMTP

You must configure the server to use IIS 6.0 worker process isolation mode. This is the default setting in new installations. However, if you have upgraded from IIS 5.0 on Windows Server 2000, Run WWW in IIS 5.0 isolation mode is enabled, and you must change this setting to use IIS 6.0 worker process isolation mode.

To enable e-mail notifications, you need to configure incoming and outgoing e-mail settings. To configure sending e-mail alerts and notifications, you can use your mail server or you must specify an SMTP e-mail server. To configure your installation so that your SharePoint sites can accept and archive incoming e-mail, you must install the IIS SMTP service.

Microsoft .NET Framework 3.0

After you have configured the server as a Web server, you must install the Microsoft .NET Framework 3.0 and then ensure that ASP.NET 2.0 is enabled.

To enable ASP.NET v2.0.50727, open the Web service extension in the IIS snap-in on the MMC. If ASP.NET 2.0 is installed on the computer before IIS is enabled, you must enable ASP.NET 2.0 by running the command aspnet_regiis -i.

Database server

The computer that hosts the database server role must have SQL Server 2000 with SP3a or later or Microsoft SQL Server 2005 SP1 or later. Some advanced features required SQL Server 2005 Analysis Services SP1 or later.

For information about the hardware and software required to deploy a database server

http://go.microsoft.com/fwlink/?LinkID=75010&clcid=0x409

Configuring SharePint Server 2007 (Part:2)

Install the .NET 3.0 Framework
Download the .NET 3.0 Framework:
Filename: dotnetfx3setup.exe
Download URL: http://www.microsoft.com/downloads/details.aspx?familyid=10CC340B-F857-4A14-83F5-25634C3BF043
Copy the dotnetfx3setup.exe file into the application server and execute the file:

In the Welcome to Setup dialog box, read the license agreement very carefully, select the I have read and ACCEPT the terms of the License Agreement option, and click the Install button.

When the setup is complete, click the Exit button.

Allow ASP.NET 2.0 Web Service Extensions in IIS:

Select Start > Administrative Tools > Internet Information Services (IIS) Manager

In the Internet Information Services management console, expand the server name in the left pane, then select Web Service Extensions.

In the right pane, select ASP.NET v2.0.50727, then click the Allow button:

You should now have a fully-functional .NET framework installed inside your application tire.

Wednesday, February 11, 2009

Configuring SharePoint Server 2007 (Part:1)

How to Configure MOSS 2007?
I have finally been able to create a fully-functional MOSS 2007 server, including testing MOSS email functions. To share this achievement, I have decided to share my process, step-by-step, screenshots included. Because documenting this process with screenshots is so lengthy, it will be broken into a series of posts on this blog.Before proceeding, here are a couple of assumptions:

Before proceeding, here are a couple of assumptions:

A. You have access to all of the required software:

Windows Server 2003 with SP1 or more
SQL Server 2005 with SP1
MOSS 2007 Enterprise
SharePoint Designer 2007
Microsoft Office 2007
Internet access

B. This will not be a lesson on how to configure windows server 2003; I am assuming that you are already familiar with configuring Windows Server 2003.

Part 1: Installing IIS, and installing .NET Framework 2.0

Perform Windows Update for your windows server 2003 machine.

http://software-applications.blogspot.com/2009/02/microsoft-windows-updates.html

Install IIS with .NET Framework 2.0

Select Start > Control Panel > Add or Remove Programs:

In the Add or Remove Programs dialog box, click the Add / Remove Windows Components button on the left side:

In the Windows Components Wizard dialog box, highlight the Application Server option, then click the Details button:

In the Application Server dialog box, highlight the Internet Information Services (IIS) option, then click the Details button:

In the Internet Information Services (IIS) dialog box, highlight the World Wide Web Service option, then click the Details button:

In the World Wide Web Service dialog box, select the Active Server Pages option, the Server Side Includes option, and the World Wide Web Service option, then click the OK button:

Click OK twice more to close the dialog boxes and return to the Windows Components Wizard dialog box:

Scrolling down the list of options, locate and deselect the Internet Explorer Enhanced Security Configuration option:

Scrolling a bit further down the list of options, locate and select the Microsoft .NET Framework 2.0 option:

Click the Next button to begin the IIS installation; you may be asked to insert the Windows Server installation media.
When the installation is complete, click the Finish button:

You should now have a fully-functional IIS web server installed inside your Windows Server 2003.

Tuesday, February 10, 2009

Microsoft Windows Updates

Getting Windows Updates from Microsoft Site:

Windows Update is a service provided by Microsoft that provides updates for the Microsoft Windows operating system and its installed components. An optional feature provides updates for other Microsoft Windows software, such as Microsoft Office, Microsoft Visual Studio, SQL Server and many more.

Security updates are delivered on the second Tuesday of each month, but security updates can be delivered whenever a software update is required to prevent an exploit targeting Windows users. Windows Update can be configured to install updates automatically, ensuring that a computer is always up-to-date and not vulnerable to computer worms and other malware.

There are two ways for getting update from Microsoft.
1. Windows Server Update Services (In my coming post we’ll look how to install and configure WSUS server)
2. Microsoft website
Select Start > All Programs > Windows Update
Follow the instructions and install all available updates, including Internet Explorer 7

For getting update automatically you need to do some changes as follows,
1. Configure ‘AutoUpdate’ ON.
Right Click My computer > Properties > Windows Updates > Click Automatic Updates (Recommended) > Apply > Ok.

2. Make changes in Local Group Policy as,
Start > Run > Type gpedit.msc > Enter and make change as follows,