61 questions
0
votes
1
answer
234
views
creating storage replica issue
i am trying to create a failover cluster with active/passive configuration.
and currently i am using two virtual machines on laptop for this.
as i don't have iSCSI, so i am trying to use storage ...
-1
votes
1
answer
1k
views
PowerShell command to add a new IP\Subnet to Windows Cluster
I have a working 2 node Windows Cluster that runs SQL Server Always On Cluster. This cluster is sitting on 10.11.x.x subnet.
I need to get this cluster ready for possible DR scenario.
I need to add a ...
- 9
0
votes
0
answers
146
views
How to configure World Wide Web Publishing service as Generic service in Microsoft Failover Clustering
When I try to configure a role - Generic service for World wide Web Publishing service, it doesn't start at all
Remains in pending state
I have web applications that will be hosted in IIS with ...
0
votes
0
answers
1k
views
SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)
We're running SQL Server 2017 Enterprise Edition on a pair of EC2 instances (we'll call them "P1" and "P3" here) in AWS. Each EC2 instance runs two instances of SQL Server (one ...
- 1
0
votes
0
answers
2k
views
Default "Cluster Group" showing offline in SQL Cluster
I've been trying to find out why the default "cluster group" is showing as offline when I run Get-ClusterGroup.
It shows Available Storage and Cluster Group. I found that "Available ...
- 57
0
votes
1
answer
1k
views
BizTalk Server 2020 Single Sign On (SSO) not working on clustered environment
I've got the following set up of servers:
Server A & Server B = Microsoft BizTalk 2020 servers
Server C & Server D = Microsoft SQL Server 2019 AlwaysOn Availability Group
I've set up a ...
- 2,176
-1
votes
1
answer
659
views
S2D and fault Domain
I am running 2 vm (Windows 2022 datacentre) with 1 OS drive and two drives presented as RAW disks. I created the cluster successfully without storage. When I try the enable StorageSpaceDirect
Enable-...
- 17
0
votes
0
answers
114
views
generic script fails to restart tomcat
I want to restart PrTomcat service in Primary node on failover using generic script in windows failover cluster with below code but tomcat is taking some time to stop (5 seconds to 150 seconds ...
- 21
0
votes
1
answer
3k
views
How do I create a shared disk for a cluster running under Hyper-V in an Azure virtual machine?
I've spent ages going around in circles on this so I'm hoping someone will point me in the right direction.
I'm creating a SQL Server lab running under Hyper-V on an Azure Windows Server 2016 ...
- 101
1
vote
1
answer
842
views
Hyper-V Anti Affinity
I'm trying to setup anti affinity with a cluster Hyper-V setup but am struggling to get any VMs to stay apart. It seems to be that the anti affinity is simply not honored.
Setup:
3 x Hyper-V servers (...
- 102
1
vote
1
answer
321
views
Is it possible to create SQL always on configuration in Windows 2016 cluster with no LB ip?
don´t know if this possible or not.
client wants to create a Windows 2016 cluster with 2 different vms/nodes that are in Azure which are in different subscriptions and virtual networks. No shared ...
- 69
1
vote
0
answers
312
views
PowerShell to create a directory within a junction point; or within a volume with no drive letter?
I'm working with Hyper-V and clustering in a Server 2016 environment. This is something I'm new to, and I'm trying to utilize some of my PowerShell experience to script the creation of a new folder ...
- 33
2
votes
1
answer
908
views
Custom psobject truncating the results that are added using add-member
I have two clusters, cluster1 with 5 nodes and cluster2 with 4 nodes. With below script the cluster1 output is getting truncated. How to address this problem?
PS C:\WINDOWS\system32> $temp = @()
...
- 1,201
0
votes
1
answer
1k
views
Creating Windows Cluster with Powershell
I have a Windows cluster provisioning script. I am not able to execute the New-Cluster command as Administrator. It says that the user should be a domain user to be able to execute the command.
I m ...
- 2,144
2
votes
1
answer
6k
views
Powershell command to update name of a Cluster IP Resource in Windows Server Failover Clustering
Hopefully this one is easy-
I am scripting a method to update clustered Windows servers in the event of an IP change. I am nearly done, but for display and monitoring purposes, I would like to ...
1
vote
2
answers
8k
views
Failover clustering validation report error: Validate Active Directory Configuration
I am deploying failover clustering on windows server 2016 enterprise
When validate configuration, failover cluster validation report an error
At system configuration > Validate Active Directory ...
- 232
0
votes
0
answers
44
views
Duplicate IPs for nodes causing backup issues
We have a four node cluster (SQL Server 2014 on Windows 12) and we recently setup heart beat network on the nodes following a best practices source after experiencing some cluster instability issues. ...
1
vote
1
answer
1k
views
How to set cluster resource "Use Network Name for computer name" checkbox programmatically?
I am programmatically setting up a cluster resource (specifically, a Generic Service), using the Windows MI API (Microsoft.Management.Infrastructure).
I can add the service resource just fine. ...
- 434
0
votes
1
answer
671
views
SymmetricDS clustering for high availability
I have setup a SymmetricDS node on Azure Windows Server 2016 using Azure SQL for both master and slave databases. I now want to setup SymmetricDS Clustering in high availability mode. I went through ...
- 367
2
votes
2
answers
5k
views
Unable to create availability group - tried all suggestions on the net
After several trials I keep getting this error message when setting new availablity group, please help me out.
Create failed for Availability Group 'SQLAVG'. (Microsoft.SqlServer.Management....
- 3,348
0
votes
0
answers
63
views
Windows Server 2012 R2 + SQL Server cluster failover with 2 node
Now i have 2 Servers on same network 1. Windows Server 2012 r2 and 2. Windows Server 2016.
i need to make both server run together i'm not sure and if the first node is down the second node can be ...
0
votes
1
answer
175
views
MSMQ in cluster behavior on node switch
I just installed MSMQ in cluster and now test how it behaves. It appears, that when active cluster node is switched all messages, which were in the queue, are lost (even when we switch back to ...
0
votes
1
answer
3k
views
MSMQ in cluster
I configured MSMQ to run in cluster. Cluster consists of two Hyper-V virtual machines and uses common storage on third virtual machine (all virtual machines share windows domain and they see each ...
0
votes
0
answers
524
views
Can not start application pool error: Cannot write configuration file due to insufficient permissions
I have 2 nodes configured in clustered environment, Both the nodes are running IIS with shared configuration stored in storage disk accessible to both the nodes. But when My cluster is connected to ...
- 1
0
votes
1
answer
23
views
Add reporting Services After SQL Installed (update ?)
I installed à cluster of SQL Server 2016. After installing SP1 and cumulative update 8, I would like to add reporting service.
Question : do I have to reinstall each update after installing reporting ...
- 3
0
votes
1
answer
4k
views
How to configure a Generic Service in Windows Failover Cluster to use clustered instead of local MSMQ
Running Windows 2008 R2 Datacenter. We have Windows services that receive messages via MSMQ. We are adding a two node cluster and trying to get the services running there. We have added Message ...
- 23
0
votes
1
answer
317
views
Windows Server 2012 R2 OS and oracle 12 C cluster configuration
I want know how to build oracle 12c Cluster on windows server 2012 R2.(for two node cluster)
1
vote
1
answer
3k
views
How to get addresses of SQL Server cluster nodes through sql query
Is there any way to get addresses of cluster's nodes via SQL query for SQL Server cluster?
- 23
0
votes
1
answer
638
views
SQL Server Geo Clustering
I want to have SQL Server Multi Site Clustering. I have experience with single site 2 node cluster but i have a scenario where i have a secondary site. In case of network failure on Site1 My ISP is ...
- 1
1
vote
0
answers
285
views
Windows Server 2016 Active Directory-Detached Cluster - Cannot add a Client Access Point
I am setting up a Windows Server 2016 cluster detached from an active directory (so called Workgroup Cluster, i.e. nodes are not added to an active directory). I cannot add a Client Access Point to ...
- 1,776
0
votes
1
answer
326
views
Availability Group replica failover connection issue
I uploaded a video explaining what happens: https://www.youtube.com/watch?v=eDuRxJAdsLw&feature=youtu.be
When I first try to connect to the failover replica SQL02 under the availability group ...
- 43
0
votes
0
answers
281
views
SQL Server Failover Cluster Setup Report
Purpose: to find all the SQL Server Failover Cluster installation details for an existing cluster setup. I am trying to document the process for disaster recovery purposes and recreate a mirrored ...
0
votes
0
answers
913
views
WMI-Query Powershell - Read printerport on printcluster (Windows Server 2008 R2)
I want to get the printerport information from a printcluster on windows server 2008 r2. On a normal printserver I do this with powershell and a wmi-query, something like this:
Get-WmiObject -...
- 132
0
votes
0
answers
159
views
Powershell - Clustered DIsk Info - Duplicates
I have the following little code which collects disk space info from standalone and clustered environments (MS SQL Servers):
Get-WMIObject -query "select * from Win32_Volume where DriveType=3 and not ...
- 11
0
votes
1
answer
419
views
Can I Run Windows Service with Quartz scheduler on 2 machines?
Is this available in the free version? or if in Enterprise version, any details/guide to install it?
How does Quartz pick up the jobs? Is it possible that both instances run the same job?
If a job is ...
- 446
-1
votes
1
answer
76
views
SSAS clustering algorithm results vary with same input
I am quite new to data mining and statistics.
I've built a Data mining model in Visual Studio. I am using Microsoft clustering algorithm and I got some issues.
I have modified some default ...
- 181
0
votes
0
answers
2k
views
How to configure Windows servers for Tomcat clustering with non-Apache web server for load balance
I have four Windows servers (2012 R2 Standard) and Tomcat (8.0.32) runs on each of them. The servers are fronted with a Kemp LoadMaster for load balancing. Currently, the load balancer and four web ...
- 14.9k
0
votes
1
answer
78
views
algorithm to find blocks of trends
Let's say I have a a 24 lines of data, such that each line represents an hour in the day. What I want to achieve is to implement an algorithm that can detect trends in the data and can divide it into ...
- 69
2
votes
0
answers
207
views
How to get cluster Id with WMI?
There is cluster ID property that can be retrieved with Get-Cluster | fl Id powershell command. How to get it with WMI? Looks like MSCluster_Cluster doesn't have ID field.
- 659
1
vote
1
answer
6k
views
delete WSFC 2012 cluster role fails
PS C:\Windows\system32> get-cluster
Name
----
sql2012poc_cl1
PS C:\Windows\system32> get-clustergroup
Name OwnerNode State
---- ...
- 21
0
votes
1
answer
2k
views
How can one query the Cluster .etl logs thru Powershell?
Server 2008 onward the cluster log is stored in 3 different .etl files at "%WinDir%\System32\winevt\logs\"
Microsoft-Windows-FailoverClustering Diagnostic.etl.001
Microsoft-Windows-...
- 162
16
votes
0
answers
771
views
Accessing performance counters through a cluster
I am trying to find how to make performance monitoring available over a cluster, and I can't find seem to find anything while searching other than how to access performance counters for a cluster.
...
- 5,636
1
vote
1
answer
627
views
Run task on all available cores - Windows HPC Pack 2008 R2 SP4
I'm using Windows HPC Pack 2008 R2 SP4 to run a MPI application. I'm having problems getting the Job Scheduler to run the app on all available cores. Here's my code...
using (IScheduler ...
- 1,104
1
vote
2
answers
1k
views
PowerShell 'get-ClusterQuorum' output is not showing 'QuorumType' column
PowerShell cmdlet 'get-ClusterQuorum' output is not showing "QuorumType" column. Has anybody seen this before? Thanks
- 11
0
votes
2
answers
315
views
Hosted Powershell from C#, permissions questions, impersonated as domain user
I know this is a bit basic, but I'll be eternally grateful if someone could set me straight on this.
I have a bunch of Windows 2012 R2 servers running Hyper-V.
An XML-RPC web service runs on these ...
- 141
0
votes
1
answer
3k
views
Getting access to a SAN disk / LUN from a virtual machine. Is it possible?
Resources:
node1: Physical cluster node 1.
node2: Physical cluster node 2.
cluster1: Cluster containing node1 and node2 used to host virtual machines.
san1: Dell md3200 highly available ...
- 4,968
2
votes
1
answer
256
views
Setting up 2 node Hadoop Cluster in heterogeneous environment i.e one 64 bit machine and another 32 bit machine?
For my learning I am planning to create a 2 node Cloudera Hadoop cluster. I have a 32 bit Windows XP machine and now I have bought a 64 bit Windows 8 machine (as now all machines are found in 64 bit ...
- 36
2
votes
2
answers
19k
views
Remove SQL cluster node
I am trying to remove a SQL 2012 cluster node from a Server 2012 R2 machine. However the windows and cluster itself has already been destoyed so when trying to remove the node the setup is erroring ...
- 3,223
-1
votes
1
answer
74
views
Strange performance data instance Volume1#1 - what does it mean?
When I'm monitoring a Hyper-V cluster through WMI, the WMI performance provider provides one extra performance data for cluster shared volume instance named "Volume1#1". The original instance "Volume1"...
- 6,965
1
vote
1
answer
4k
views
How to get the drive letter such as "c:", "d:" etc from the PowerShell get-clusterresource cmdlet?
Let's say I have some clustered disks and I can get them out from the cmdlet get-clusterresource.
PS N:\> get-clusterresource | ?{$_.resourcetype.name -eq "Physical Disk"}
Name State ...
- 29k