Specifications

A Principled Technologies test report 19
Hardware upgrades to improve database, SharePoint, Exchange, and
file server performance with the Intel processor-powered Dell
PowerEdge T630
Configuring the third application VM for SharePoint Server 2010
We installed a separate instance of SQL Server 2012 for our SharePoint databases. This prevented creating an
unnecessary bottleneck by having WSSDW and DVD Store running against the same instance of SQL on the same
application server.
Installing Microsoft SQL Server 2012
1. Insert the installation DVD.
2. Click Run SETUP.EXE. If Autoplay does not begin the installation, navigate to the SQL Server 2012 DVD, and
double-click.
3. If the installer prompts you with a .NET installation prompt, click Yes to enable the .NET Framework Core role.
4. In the left pane, click Installation.
5. Click New SQL Server stand-alone installation or add features to an existing installation.
6. At the Setup Support Rules screen, wait for the rule check to complete. If there are no failures or relevant
warnings, click OK.
7. Select the Specify a free edition and select Evaluation from the drop-down menu. Click Next.
8. Click the checkbox to accept the license terms, and click Next.
9. If no failures are displayed after the setup support files are installed, click Next.
10. At the Setup Role screen, choose SQL Server Feature Installation.
11. At the Feature Selection screen, select Database Engine Services, Full-Text and Semantic Extractions for Search,
Client Tools Connectivity, Client Tools Backwards Compatibility, Management Tools – Basic, and Management
Tools – Complete. Click Next.
12. At the Installation Rules screen, click Next after the check completes.
13. At the Instance configuration screen, leave the default selection of default instance, and click Next.
14. At the Disk Space Requirements screen, click Next.
15. At the Server Configuration screen, check that NT Service\SQLSERVERAGENT is selected for SQL Server Agent,
and that NT Service\MSSQLSERVER is selected for SQL Server Database Engine. Click Next.
16. Assuming there are no failures, click Next.
17. At the Database Engine Configuration screen, select Mixed Mode.
18. Enter and confirm a password for the system administrator account.
19. Click Add Current user. This may take several seconds.
20. Click the Data Directories tab and enter the appropriate drive and folder to which you will eventually deploy the
SharePoint databases.
21. Click Next.
22. At the Error and usage reporting screen, click Next.
23. At the Installation Configuration Rules screen, check that there are no failures or relevant warnings, and click
Next.
24. At the Ready to Install screen, click Install.
25. After installation completes, click Close.
26. Close the installation window.