SQL SERVER BUILD STEPS

 

1 ST STEP

============ Window server build =======
INstall the VM and assign the storage to local drive .
2 gb RAM
25 GB DISK SPACE.

One is Domain server                   80 GB OF STORAGE AND IP 10.10.10.1    TCS.COM domain.
One is db server for PROD    	       25 GB OF STORAGE AND IP 10.10.10.2
One is db server for TEST              25 GB OF STORAGE AND IP 10.10.10.3
One is db server for DEv               25 GB OF STORAGE AND IP 10.10.10.4

2 ND STEP
=======  Creating Domain name server as Active Directory service  ===========

click on server manager ->add roles and features->next->next->active directory domain servic->add features ->next->next->next->Install..
Click on Flag symbol->promote this servers as a Domain ->Add new forest->Root domain name->TCS.COM->next->password ->confirm password ->next->next->next>next->Install===Domain server
 
Domain server completed .

3 RD STEP
========Network configuration & Storage addition to prod,test,dev servers ======

Install the Guest addition  on vm 
Disabled the Firewall...Run->Firewall->double click->properties->domaon profile off,private profile off,public profile off.
change the hostname  right click on my computer->change the computer name.

1,Down the VM->GO settings-> Network settings  ->Hostonly adapter -> allow all.

2,Storage addition.  Go to VM->settings->storage->add storage-> click on + symbol assingn 2 disk for D for data and E for log and H for backups . each with the size of 10 gb .
same for prod server and prod-DR server .

3.Assign the IP using ncpa.cpl--- In run ->ncpa.cpl  double click->assign the IP adrress. on TEST,DEV,PROD servers and also for DOAMIN SERVER .

4 Th STEP   

====================  Add the servers into Domain server ie Active Directoty ====================
Add the domain server ip in PROD,DEV,TEST servers.

Right click on server ->go to my computer right click ->properties -> change settings -> change -> TCS.COM->USERNAME AND PASSWORD ....

5 TH STEP
======= ============= Now add the software folder to be sharable. ==========

on VM ->Device ->shared folder->click on + symbol->add the folder (inside you cannot see anything while adding )  read only and make permanent.
Now go to server ->click on PC->Richt click-> map the drive ->browse->select the folder->ok  
Now copy sql server 2016 software to local server ie prod server .

6 TH STEP:  server copy to remote servers is done

connect to prod server to use the network ip OF TEST AND PROD  in run promt to copy the software in TEST AND DEV servers.
From prod server to copy the software in TEST AND DEV server using network  run->(control+R) \\10.10.10.6\C$
If you  dont know the IP address of the test and dev go to that perticular server open run promt ->ncpa.ctl->double click on ethernet->properties->ipv4-> to see the IP.

7  Now assigned  disks to the servers to make them online and rename the volume name :

In prod server run promt diskmgmt.msc   Here you could see already added disks to the server. just click on ok.Now made the disks to online..
you could see the disks which are unallocated ->right click on it ->click on -> (1st option)new single volume->next->validate the size ->next->here you can change drive letter if want ->click on next->select format the volume with the following settings ->change the volume lable as-> DATA->next->Finish.   we have to do it same for all unallocated disks.
D drive -DATA
E drive -LOG
H drive -BACKUP.

same step follow in DEV & TEST servers. for all unallocated disks. and rename the volume with new names.

Now cluster and after that Failover cluster.

8) power off the servers.

Power of the servers PROD,DEV,TEST Not required for DOMAIN SERVER .
Now add the Private IP's for internal node comminication for CLUSTER . For that we need to give the new adapter2. 
go to vm->click on prod node->settings->network->choose adapter2 ->Enable the adapter->host only adapter->allow all.

9) Now we have the storage point, cluster should have the common storage to acces the data from both the nodes.
using ISCSI target create on DOMAIN SERVER .
STAR WIND software used before for  lower version sql server softwares from 2012 onwards its not required. we can directly do it DC. domain controler server .

ISCSI IS STORAGE RELEATED MUST BE DO IT ON DOMAIN SERVER .FOR COMMON STORAGE

Failover cluster  install on the prod,dev,test


Enable the in
ncpa.cpl->double click on Ethernet 2->properties->ipv4->select use the following address  192.168.1.10   (This is internal IP for local node communication).=====for PROD
ncpa.cpl->double click on Ethernet 2->properties->ipv4->select use the following address  192.168.1.11   (This is internal IP for local node communication).=====for DEV
ncpa.cpl->double click on Ethernet 2->properties->ipv4->select use the following address  192.168.1.12   (This is internal IP for local node communication).=====for TEST

ON domain server ONLY ONE TIME ACTIVITY. ->

click on server manager(or) search in run ->file and storae ->ISCSI  To install ISCSI TARGET server start the active new feature window add roles .
check  ISCSI target server(Automatically it will select) ->next->next-> restar the installation server automatically if required ->install..

ON domain server ONLY 

After this on same screen right side corner ->click on under view option.select TASKS->	New ISICI virtual disk will come enable.
Now again go to same TASKS->CLICK ON-> New ISICI virtual disk here we can see the avaialable storage ..ie 12 gb click on next->give the name->DATA->SIZE 10 GB->FIXED DISK->NEXT-

After this on same screen right side corner ->click on under view option.select TASKS->	New ISICI virtual disk will come enable.
Now again go to same TASKS->CLICK ON-> New ISICI virtual disk here we can see the avaialable storage ..ie 12 gb click on next->give the name->QUORUM->SIZE 10 GB->FIXED DISK->NEXT-
NEXT->NEW

=============== ON domain server ONLY   THis is for take the drives to reflect into the servers. ==================

Again Next->add->Enter a value for the second type->ip address->Value->give the prod IP -> Again add 
Again Next->add->Enter a value for the second type->ip address->Value->give the Dev Ip ->  Again add
Again Next->add->Enter a value for the second type->ip address->Value->give the Test IP -> Again add  NEXT->NEXT->CREATE
9 gb for sql server 
1 gb for quorum disk

THose disks DATA AND QUORUN DISK  which we have added in domain server need to be accessile/IDENTIFED here..

now on PROD,DEV,TEST  Take prod server ->server manager->Tools(right  corner)->ISCSC Initiator->yes->choose discovery ->discovery portal->give the IP of DOMAIN SERVER IP. OK
Then click on target (1 st TAB)-> here we can see both the disks DATA AND QUORUM DIDKS..click on any of the disk  and click on connect->ok
nect click on DATA disk ->connect ->ok just ENTER (Here we cannot see ok button bcz its alredy just close it )

on same prod server in server manager ->go to DISKS->you can see all the disks offline.
just right click on disk and make it online for both the disks.

on PROD server .

Now right click on 10 gb data disk ->new volume ->Next->ok->next->drive Letter ->F->next->volume lable ->SQLDATA->NEXT->CREATE   SAME DO IT FOR QUORUM DISK.
NO NEED TO DO THIS FOR ANOTHER TEST AND DEV SERVERS .


on test or dev.  server ->server manager->Tools->ISCSC Initiator->YES->give the domain server IP. now you could see the both the disks ->click on any disk ->connect->choose another disk and connect->done.
now go to disks->make them online