SQL Server

• Windows Server 2012
• SQL Server 2012 Standard SP1
• Memory: 8GB RAM
• CPU: 4
• Drive: 1x80GB, 1x40GB
• IP Address: 192.168.67.12
• Domain: contoso.com
• Name: server2012sql
• Target Drive: 2 (OS and SQL Server install)
• Target Drive: 1 (Database install)

Note the following in the Virtual Machine Settings. I set up one processor with four cores.

Add a Second Hard Disk

I set up a second Hard Disk by clicking on Add… at the bottom of the Virtual Machine Settings screen. The Add Hardware Wizard screen appears. I select Hard Disk and click Next. I click Create a new virtual disk in the Select a Disk screen and click Next. I leave the settings in the Select a Disk Type screen as is and click Next. I change the Maximum disk size to 40.0 in the Specify Disk Capacity screen and click Next to continue. I specify the location and filename for the virtual disk file in the Specify Disk File screen. I click Finish to continue. I click OK to close the Virtual Machine Settings screen. I want to restart the server to apply the changes. I click on Local Server. I click on Tasks and select Shut Down Local Server. I select Restart on the What do you want the computer to do? drop down list. I change the option to Hardware: Installation (Planned), add a comment, and click OK to continue. The server restarts. I logon with the local Admin account. I click on Tools \ Computer Management to finish adding the second disk. The Computer Management screen appears. I click on Storage \ Disk Management. I right-click on Disk 1 and select Online. The status of the drive changes to “Not Initialized”. I right-click again and select Initialize Disk. The Initialize Disk screen appears. I leave the settings as is and click OK to continue. The status of the drive changes to Online. I right-click on the drive and select New Simple Volume. The New Simple Volume Wizard screen appears. I click Next to continue. I leave the settings in the Specify Volume Size screen as is and click Next to continue. I leave the settings in the Assign Drive Letter or Path as is and click Next to continue. I change the Volume Label in the Format Partition screen and click Next to continue. I click Finish in the Completing the New Simple Volume Wizard screen. The second hard disk appears in the list. I close the Computer Management screen.

Change the Server Name and the IP Address

I want to change the server name and IP address. I click on Local Server. I click on the displayed computer name and the System Properties appears. I click on Change and the Computer Name / Domain Changes dialog box is displayed. I update the computer name as displayed below. I click OK to continue. I will update the domain later. Computer name: server2012sql I click OK when asked to restart the computer. I click on Close to close the Systems Properties screen. I click on Restart Now. The computer immediately restarts. I confirm that the computer name has changed. I click on the Ethernet setting to change the IP address. The Network Connections screen is displayed. I double-click on the Ethernet icon and the Ethernet Status window is displayed. I click on Properties and the Ethernet Properties dialog box is displayed. I click on Internet Protocol Version 4 and Properties. I select Use the following IP address and enter the IP address displayed below. Note that I added the Domain Controller server as the preferred DNS server address and I added the IP address of my home router as the alternate DNS server. I click OK to accept the changes and continue. I click Close to close the Ethernet Properties dialog box. I click Close to close the Ethernet Status dialog box. I close the Network Connections window and I am returned to the Local Server dashboard. I can see that my change is applied. I click on WORKGROUP in the Properties display. The System Properties screen is displayed again. I click on Change… and the Computer Name / Domain Changes screen is displayed. I select Domain and enter contoso.com. I click OK to continue. The Windows Security screen appears. I enter the Administrator account on the domain controller and click OK to continue. A Welcome screen appears. I click OK to close the screen. I click OK to restart the computer. The System Properties screen shows the updated Domain. I click Close to close the System Properties screen. I can see that the Local Server properties is also updated. I click Restart Now on the Restart screen to restart the server. The server restarts immediately. I logon with the local Admin account. I check the Local Server Properties. I want to add SQL_Admin as a Local Administrator on the SQL Server. I click on Tools \ Computer Management. The Computer Management screen opens and I select Local Users and Groups. I expand and select Groups. I double-click on Administrators and the Administrators Properties screen appears. I click on Add... and add Contoso\SQL_Admin to the Enter the object names to select box. I click Check Names and the Windows Security screen appears. I enter the credentials for Administrator and click OK. The name is validated. I click OK to continue. The SQL_Admin account appears as a member of the Administrators group. I click OK to close the Administrators Properties screen. I close the Computer Management screen.

Windows Firewall

I need to configure Windows Firewall to open a port for SQL Server. I click on Domain: On beside Windows Firewall in Server Manager \ Local Server. The Windows Firewall screen opens. I click on Advanced Settings The Windows Firewall with Advanced Security screen opens. I click on Inbound Rules I click on New Rule … under Actions on the right menu The New Inbound Rule Wizard screen appears. I select Port and click Next. I keep TCP selected and enter 1433 as the local port. I click Next to continue. I keep Allow the connection selected and click Next to continue. I keep all of the settings on the screen and click Next to continue. I enter values for Name and Description and click Finish. The Inbound Rule is saved. I will create additional Inbound Rules: Port Description TCP 2383 Microsoft SQL Server 2012 Analysis Services with Default instance TCP 2382 SQL Server Browser service TCP xxxx SQL Server 2011 Analysis Services (if used) TCP 80 SQL Server 2012 Reporting Services (SSRS) TCP 135 SQL Server 2012 Integration Services (SSIS) I close the Windows Firewall with Advanced Security screen. I close the Windows Firewall screen.

Install SQL Server 2012

I click on VM \ Settings on the VMWare toolbar. The Virtual Machine Settings screen appears. I click on Add… and the Add Hardware Wizard screen appears. I click on CD\DVD Drive and click Next. I select Use ISO image and click Next. I browse to the ISO image (en_sql_server_2012_standard_edition_with_sp1_x64_dvd_1228198.iso) that I have for SQL Server 2012 Standard. I click Finish to continue. I click OK to close the Virtual Machine Settings screen. A message appears in the top right corner of the screen. I ignore it for now (because I want to switch user accounts). I click CTRL-ALT-DEL in the VMWare toolbar. I click Switch user in the screen. I click Other user. I enter the credentials for SQL_Admin and click the arrow. I click the Libraries folder on the task bar at the bottom of the screen. The Drive Tools screen appears. I select the F: drive that I just mapped to the SQL Server ISO file. I double-click the setup file. The User Account Control screen appears and I click Yes to continue. The installation process begins. The SQL Server Installation Center screen appears. I click on Installation and New SQL Server stand-alone installation …. The Setup Support Rules screen opens. It shows that all rules passed. I click OK to continue. The Product Key screen is displayed, I enter a product key, and I click Next to continue. The License Terms screen is displayed. I click on I accept the license terms and click Next to continue. I see two recommended product updates on the Product Updates screen. I click Next to continue. The installation process continues. A message box appeared during the installation. I clicked OK to close it and continue. Another message briefly appeared and then closed. The Setup Support Rules screen lists warnings. There is one warning about Windows Firewall; but I already made the required changes. I click Next to continue. The Setup Role screen appears. I leave the settings as is (because I want to customize and configure). I click Next to continue. The Feature Selection screen appears. I select the following Microsoft SQL Server 2012 features for a fast SQL Server setup :

• Database Engine Services
• Client Tools Connectivity
• Client Tools Backwards Compability
• Management Tools – Basic

I change the directories to point to my second drive (E). I click Next to continue. The Installation Rules screen appears. I click on Show Details to see the details. I click Next to continue. Note: I did have a problem reported with installing Microsoft .NET Framework 3.5 one time. I did not get the problem again when I added my home router as the second DNS server in the IP address configuration. So I think the solution is to have an Internet connection available to the Windows 2012 Server. The Instance Configuration screen opens. I change the Instance root directory to point to the second drive (E). I click Next to continue. The Disk Space Requirements screen displays the disk summary. I know that I have plenty of disk space (for now). I click Next to continue. The Server Configuration screen opens. I change the settings by changing two of the account names and include the passwords. I display the Locations and Select User screens below. I click Next in the Server Configuration screen to continue. The Database Engine Configuration screen opens. I add Contoso\SQL_Admin as a SQL Server Administrator. I select Mixed Mode and enter the password for the SQL Server system administrator. I click Next in the Database Engine Configuration screen to continue. The Error Reporting screen opens. I click Next to continue. The Installation Configuration Rules screen opens. I click Show Details to see the details. I click Next to continue. The Ready to Install screen opens. I click Install to continue. The Installation Progress screen opens and the installation process begins. As a side note, my Lenovo ThinkPad looks like it is working for a change. The Complete screen appears. The status of every feature is Succeeded. I click Close and the screen closes. I close the SQL Server Installation Center screen. I click on the Windows Start button on the keyboard. I can see new icons for SQL Server programs. I click on the [ESC] key on the keyboard.

Max Degree of Parallelism Setting

I need to change the setting for max degree of parallelism. I click on the SQL Server Management icon. SQL Server Management Studio starts up. The Connect to Server screen is displayed. I click Connect. The Object Explorer pane shows the SQL Server listed. I right click on the SQL Server SERVER2012SQL and select Properties. The Server Properties screen appears. In the Select a page section, I click Advanced. I scroll to the bottom and change the Max Degree of Parallelism value from 0 to 1. I click OK to continue. I keep the Microsoft SQL Server Management Studio screen open for the next step.

SQL Permissions for sp_install

I need to set the following roles on the SQL Server for sp_install:

• DB_Creator
• Security_Admin
• Public

In the Object Explorer, I expand Security and Logins. I right-click on Logins and select New Login. The Login – New screen appears. I enter the account (CONTOSO\sp_install) that I will use for the SharePoint installation into the Login name field. I click on Server Roles and select dbcreator and securityadmin. I keep public selected. I click OK to continue. The screen closes.

SQL Permissions for sp_farm

I need to set the following roles on the SQL Server for sp_farm:

• DB_Creator
• Security_Admin
• Public

In the Object Explorer, I expand Security and Logins. I right-click on Logins and select New Login. The Login – New screen appears. I enter the account (CONTOSO\sp_farm) that I will use for the SharePoint farm administrator into the Login name field. I click on Server Roles and select dbcreator and securityadmin. I keep public selected. I click OK to continue. The screen closes. I