Tools used when building Windows cluster with iscsi
Posted: January 6, 2016 Filed under: active directory, Uncategorized, Windows ACtive Directory, Windows Clustering, Windows Domain Controller Setup Leave a commentTools used when building Windows cluster with iscsi:
- Control Panel -> Network and Internet -> View network status and tasks including Change adapter settings
- Control Panel -> System -> Device Manager including View -> show hidden devices
- Disk Management
- Server Manager -> Manage -> Add roles and features
- Server Manager -> Tools -> Failover Cluster Manager
- Server Manager -> Tools -> iSCSI Initiator
- Server Manager->Tools->Routing and Remote Access
- Server Manager -> File and Storage Services on left panel -> iSCSI
- Server Manager->Tools-> Group Policy Management
- Server Manager->Tools-> Active Directory Users and Computers
- diskpart
- sysprep
Tip and undo hints when things go wrong!:
- Sysprep everything, see below, technically I read only DC needs sysprep but I was safe.
- diskpart – to remove GPT protected or recovery partitions – list disk – select disk N – list partitions – select partition N- delete partition override
- Server Manager->Tools-> Active Directory Users and Computers -> expand domain -> expand computers -> delete computer to allow retry – not only done on my play setup!
- Backup all VMs BEFORE installing Failover Clustering features
Sysprep myth
After a lot of reading I found Mark Russinovich’s answer.
So sysprep is only needed when 1 machine will reference another machine’s SID :
- The first domain controller in a domainhas a machine SID and this becomes the “Domain SID”.
- All DCs have the their machine SID matching the “Domain SID”.Machines
- All machines which are not a Domain Controller MUST not have a machine SID matching the “Domain SID”.
I sysprep’ed everything in my cluster builds so I have not tested this!
SQL Server Clustering (FCI) setup using Cluster Shared Volumes with multipathed iSCSI disks
Posted: January 5, 2016 Filed under: SQL Server FCI, SQL Server Management Studio, Uncategorized, Windows ACtive Directory, Windows Clustering, Windows Domain Controller Setup | Tags: Microsoft SQL Server, Microsoft SQL Server 2016, Microsoft SQL Server Management Studio, Windows Active Directory, Windows Clustering Leave a commentJust finished an article on SQL Server Clustering (FCI) setup using
- Windows Server 2016 Preview 4 cluster nodes
- SQL Server 2016 CTP 3.2
- Windows Server 2016 Preview 4 iSCSI storage using iSCSI targets as disks
- Cluster Shared Volumes on top of the iSCSI disks
- Multi-subnet setup
- Domain Controller Setup
- SSMS December 2015 release to test connections
http://smooth1.co.uk/installs/dbinstalls.html#3.1.14
SQL Server Clustering (FCI) setup using multipathed iSCSI disks
Posted: January 5, 2016 Filed under: Microsoft SQL Server 2016, Microsoft SQL Server future, Microsoft SQL Server Management Studio, SQL Server FCI, Uncategorized, Windows ACtive Directory, Windows Clustering, Windows Domain Controller Setup | Tags: Microsoft SQL Server, Microsoft SQL Server 2016, Microsoft SQL Server Management Studio, Windows Active Directory, Windows Clustering Leave a commentJust finished an article on SQL Server Clustering (FCI) setup using
- Windows Server 2016 Preview 4 cluster nodes
- SQL Server 2016 CTP 3.2
- Windows Server 2016 Preview 4 iSCSI storage using iSCSI targets as disks
- Multi-subnet setup
- Domain Controller Setup
- SSMS December 2015 release to test connections
http://smooth1.co.uk/installs/dbinstalls.html#3.1.13
NOTE: Only DB Engine and Analysis Services are supported as clustered.