Hi Guys, When we are setting up SharePoint Server. We have two options: Setup as Farm And Setup as Standalone What are the real differences and impact on it will have? ta

Standalone will install SQL Express on your machine and use it for your Sharepoint instance. No other SP machines can join, its standalone not a farm. Farm will install Sharepoint on existing SQL Server instance if you already have one on either your machine or somewhere else on the network. You can join other machines to this SP installation.ore More details I found on a site: When installing SharePoint Server 2010, there are primarily three setup options. Following is a short description of each type of installation: Standalone Installation : · SQL Server 2008 Express Edition is the database type automatically installed (instead of Windows Internal Database/SQL Server 2005 Embedded Edition used in Windows SharePoint Services 3.0). · This is almost a “one-click” installation, no questions are asked during setup or during Post Setup Configuration Wizard (PSConfig) · A Web application and team site collection are automatically created in the newly created farm. The search service is started automatically. · Cannot add servers to join a farm. · When the installation is complete, the browser opens taking you to a newly created site collection. · Installer is not prompted for farm passphrase, it is automatically generated. Server Farm Standalone · Same as Basic installation, except it allows changing installation directory location. Server Farm Complete · SQL Server 2005 SP2/SQL Server 2008 is the database type, not installed by setup. · Administrator can pick whether or not to create a site and the site template to use. · Prompted for farm passphrase during PSConfig phase of installation. -Ankit Nigam | MCITP SQL Server 2005

Hi I have found a very good article at the following link, I hope it clear your queries http://www.ipsure.com/blog/2010/step-by-step-installation-of-sharepoint-server-2007-on-windows-server-2008-r2-and-ms-sql-2008-1/ JNIKHIL Jnikhil

JNIKHIL, your reference is about 2007 .. ta

Hi ta, Which product are you using, SharePoint 2010 or 2007? Thanks, Pengyu Zhao

Hi ta its about differences between Setup as Farm And Setup as Standalone. JNIKHIL Jnikhil

> your reference is about 2007 .. So it should be. This is NOT a SP 2010 forum. (Look at the title of the forum which clearly says "pre-SharePoint 2010". Moderator Note: I have deleted the off-topic post from Ankit Nigam which was about SP 2010 installation and therefore off-topic here. He also proposed his own post as answer which is very bad forum behaviour. SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters