SQL SERVER 1 PART 1

This page is continuation to Domain Controller Part 1

Below are the task that have been performed : 

1. Creating SQL SERVER 1 (SQL1)

2. Using sysprep to clear configured settings.

3. Change the IP Address on Ethernet0 and Computer Name

4. Add a network adapter to the SQL1

5. Install .Net Framework 3.5

6. Change IP Address on Ethernet1

7. Discover,format, attach iSCSI virtual disk created during DC1

8. Install failover clustering feature on SQL1 

1. Creating SQL SERVER 1 (SQL1)

SQL server creation using OVF file.

Browse to the location of OVF file

Name for the new virtual machine: SQL1
Storage Path for the new virtual machine: D:/SQLServer1

2. Using sysprep to clear configured settings.

sysprep is used to deploy a Windows image to different PCs, you have to first generalize the image to remove computer-specific information such as installed drivers and the computer security identifier (SID). You can either use Sysprep by itself or Sysprep with an unattend answer file to generalize your image and make it ready for deployment.

System Cleanup Action : Enter System Out-of-BoxExperience(OOBE)

Check :Generalize 

Shutdown Options: Reboot

3. Change the IP Address of Ethernet0 and Computer Name

On Ethernet0

IP Adrress: 192.168.10.1

Subnet Mask: 255.255.255.0

Preferred DNS Server: 192.168.10.100

Computer name : SQL1

Member of : sql.local

Joining to the Domain sql.local

Welcome message from sql.local domain

Restart the server

4. Add a network adapter to the SQL1 server

Connect at power on

custom: Specific virtual network

VMnet4

5. Install .Net Framework 3.5

Make sure that the .net framework is installed on the server 

6. Change IP Address of Ethernet1

On Ethernet1

IP Adrress: 192.168.20.1

Subnet Mask: 255.255.255.0

Append Primary and connection specific DNS suffixes

Append parent suffixes of the primary DNS suffix

Enable LMHOSTS lookup

Disable NetBIOS over TCP/IP

7. Discover, format, attach iSCSI virtual disk created during DC1

Open the iSCSi initiator and target 

Disk Management

Disk1 unknown and offline

Bring the disk online

Once the disk is online, then Initiate the disk. Create a new simple volume

The newly created disk volume is available on the system.

8. Install fail-over clustering feature on SQL1 

Tools > click on add roles and features wizard

Select Role-based or feature-based installation

Select SQL1.sql.local

Select Failover Clustering feature

.