SQL Server Service Group can't bring online on the second node
Hello everyone, Please I need a solution about my SQL cluster in test environnement. I have issues with the service group that I can"t bring it online on the second node. But in the first node its can be online without errors. For testing the intergity of the DATA on the ISCSI partition, I deleted the service group. And i mounted the partition on the second node, I recrated the service group, I can bring it online easily. When I switch it to the other node (first node on the cluster), same error, its can't be bring in online. Below some error on the event viewer about this problem : Thank you in advance for your helpSolved1.5KViews3likes5CommentsVCS system states in the state of ADMIN_WAIT
If you name the cluster name cluster while running VCW, then system states of all VCS nodes are going to the state of ADMIN_WAIT. If you try to start VCS with the "hastart -onenode" command after run "hastop -all", then hastatus will display "STALE_ADMIN_WAIT". Check the main.cf, you will see the cluster name is cluster. include "types.cf" cluster Cluster( UserNames = { admin = gJHkHEfFGjISjGFqJJeRJoJSiRJj } Administrators = { admin } ) system symantecha1( ) system symantecha2( )Solved1.5KViews3likes2CommentsImplementing SQL Server Transparent Data Encyrption (TDE)
We are trying to Implement Transparent Data Encyrption (TDE) on Microsoft SQL Server 2012 Enterprise Edition (64-bit) (SP2) (11.0.5343.0) under Veritas Cluster Server 5.1 with three nodes, but have had problems. The OS is Windows 2012 R2. Has anybody been able to successfully implement TDE? If so, can you give me any advice, tips, caveats, etc.? Neither Veritas support nor Microsoft have any answers. I haven't been able to find anything posted already in this community or forums. Thank you for your help.610Views2likes1Commentadd node to VCS for SQL
Hello Currently , I have 2 node cluser for SQL database. There are requirement to add new node to the existing cluster. If I install windows , sql installation & configuration as same as the exsing nodes. The finally step arejust adding the node to cluster and re-run the SQL agent configuration wizard to reconfigure the SQL service group. I am not sure about the additional step that must be concern. Thank you.Solved955Views2likes4CommentsSQL Server 2008 on Veritas Cluster
Hello, On the purpose of testing the new version of Veritas cluster, I created 2 nodes that contains SQL server binaries. This 2 nodes are identical on configuration, and attachement to the SAN over ISCSI. On the official documentation, they recommand to make the DATA of the instance from the first node on the shared storage. And for the second node, they DATA can be reside on the local disk. I do this, but when I was configuring the service group, and when selecting the systems (nodes) that can participate on the cluster service group. An error message appears telling man that the nodes are not identical, and the seconde node can't find the instance. Can you please help me about this problem. Thank you.Solved1.4KViews2likes8CommentsUn-clustering a simple 2 node SQL cluster
Can anyone point me in the direction of some good articles or info on removing clustering all together. Here is our setup, 2 physical nodes, SFHA 5.1 SP2, 2008 enterprise 64bit, SQL 2005. We just don't need the clustering component anymore and are looking to actually virtualize this workload at some point as well.Solved4.2KViews2likes11Commentshow to use a network share folder (CIFS) on a service group?
Hi, I have below environment, node 1 & node 2 SFW HA 6.0.1, Windows 2008 R2 node 3 with shared folder (\\node3\folder) use as Vault Store EV service group i need \\node3\folder to be part of EV service group and failed over between nodes as part of EV cluster. it should only be mounted on active node and not on the passive node. can i do this? if so, how? normal way i can mount a share via CLI like "c:\ net use Z: \\node3\folder", is there a resource where i can only specify this syntax so it will be part of the service group and the failover process?Solved1KViews2likes4CommentsVeritas Cluster license
I need to know the licensing method if i am planning to run 4 Node Window cluster on Virtual machine. 1) Physical Machine having Dual CPU with 12 core ( Intel Xeon E5). 2) Virtual Machine having 16 vcpu each . So need to understand how many license i need to buy to create 4 node Vertias Cluster and which license type . Quick help is appreciated.684Views1like1CommentV-16-20062-55 SVCCopyServices:online:Failed to get the cluster id
I am getting the following error when trying to online the SVCCopyService on windows, this comes up immediately there is no delay in receiving the message in the Status window. V-16-20062-55 (SERVERNAME) SVCCopyServices:RES-SVCCopyServices:online:Failed to get the cluster id We have exactly the same resource configuration on our UNIX system and this connects without any issues. We have also been able to run the plink command in an elevated command prompt window and this can connect to the SAN and run queries so I am a bit stumped. I have attached screenshots of the testing and error logs. Any suggestions would be greatly appreciated: OS - Windows 2012 R2 Standard VCS - 6.1 SAN - IBM V840Solved2.1KViews1like7CommentsMigration of VCS Cluster to new servers
Hello, I have a two nodes veritas cluster with SQL & file shares ressources. The goal is to migrate the data and ressources to a new servers. How can I create first a standalone node and trasport the data and configuration of the cluster. And recreate the cluster as the original one. Thank you in advance for your help.Solved4.3KViews1like10Comments