How can I install SharePoint 2010 using PowerShell to create database with out GUID’ed?
If you don’t want to have GUID’ed databases after installing SharePoint 2010, you should use PowerShell scripts installation. In this blog, I am using SharePoint Auto Installer from Codeplex
This project consists of PowerShell scripts, an XML input file, and a standard windows batch file (to kick off the process) which together provide a quick and near-unattended installation and initial config (Service Apps, My Sites) of Microsoft SharePoint Server 2010. Works on both Windows 2008 and 2008 R2 (x64 only of course).
1. Download SharePoint 2010 Auto Installer
2. Unzip the files and this is what you will see. You have four folder
AutoSPInstaller: This folder contain all the configuration files
OfficeWebApps: Put SharePoint 2010 Files Here
PrerequisteInstallerFiles: Put Prerequisite Files Here
LanguagePacks: Put Language Packs here
Instead of putting files in each of these folder,
I opened SharePoint Splash file and installed prerequisite files and installed SharePoint binaries.
When you install software prerequisites, it will download all the files you needed and prepare you IIS for SharePoint installation.
Once the prerequisites are completed, just install SharePoint 2010 Server but don’t run the configuration wizard.
Installing SharePoint 2010 Server
1. Enter the product key and click continue
2. Accept the term agreement and click continue
3. In this case, I am installing Server Farm (One Front End and Backed End Server)
4. Complete installation: Install all components, can add servers to form and SharePoint farm
5. Installing SharePoint 2010
6. Installation completed and DO NOT RUN the SharePoint Products Configuration Wizard NOW.
Now we are going to use the SharePoint SharePoint 2010 Auto Installer
2. SharePoint Installation using SharePoint 2010 Auto Installer Scripts
1. Go to Auto Installer Folder
Enter your product Key here: This is where you have to enter your SharePoint 2010 product KEY.
In this case we already installed SharePoint using the product you and you may not needed but if you installing everything using script, this is where you need to input product key.
2. Now open AutoInstallerInput.xml file. This is where you need to add all your configuration.
I am using Dreamweaver but you can open using your notepad
Input your information about your farm. Your domain name/user name, password, SQL Server Name, etc..
If your using separate account for SQL Server, make sure you give proper permissions in SQL server.
Once you make all the changes, save the file and launch Auto SharePoint Installer to Install SharePoint 2010
3. SharePoint 2010 installation with Power Shell in progress
1. SharePoint 2010 Auto Installer, Testing SQL server access and trying to connect to SQL Server
2. SharePoint 2010 Auto Installer skipping prerequisites and binaries. Enter your pass phrase now to move on
3. Creating Config Database and joining to a farm
4. Adding managed accounts and creating web applications
5. Configuring the SharePoint farm servers using using Auto SharePoint installer
6. Completing the installation.
Once you install SharePoint 2010 using SharePoint Auto Installer, your database will be clean and no more GUIDS.