Awesome video training covering manyy features active directory, iscsi, sql cluster. Thanks a lot for sharing Bro...
@LabsHandsOn
5 жыл бұрын
You are welcome... Glad to know you like it.
@SonnetGomes
6 жыл бұрын
Thank you very much for posting this video. This is a great step-by-step guide for beginners to setup Windows and SQL cluster.
@LabsHandsOn
6 жыл бұрын
+Sonnet Gomes thanks
@alphonsesossou4283
3 жыл бұрын
This is the best tutorial on the subject. All aspects explained very clearly. Thanks
@aarefsayyad8
4 жыл бұрын
Very Good & easy to understand complete training .. Thanks !! please keep it up & help us with such Awesome Vedio
@LabsHandsOn
4 жыл бұрын
Thanks Glad to know you like it
@ravindramahajan9017
2 жыл бұрын
Thank you so much for shairing a real knowledgebase video..Great efforts much appreciated
@ArvindKumar-xm3tl
5 жыл бұрын
Great video buddy. You should have also shown adding node to fail-over cluster in SQL server setup from secondary node. And then also do a fail-over by bringing active node down and showing that We are still able to connect to virtual sql server name.
@LabsHandsOn
5 жыл бұрын
Thank you very much, Glad to know you like it.. Thanks for your suggestion as well
@PrashantSinghpsp
8 жыл бұрын
by seeing videos all concept use to clear and it becomes easy to deployed.. Thanks Vikash.
@LabsHandsOn
8 жыл бұрын
Welcome good to know :)
@srinivasmerugu8029
7 жыл бұрын
Clear and Good explanation of cluster installation in step-by-step
@LabsHandsOn
7 жыл бұрын
+Srinivas Merugu thanks
@nadunsamarasinghe5592
5 жыл бұрын
Great .... we have tested its almost okay. thanks a lot Bro...
@LabsHandsOn
5 жыл бұрын
Thank you very much for your feedback, Glad to know you like it..
@premlalk1
6 жыл бұрын
Very well explained,...excellent..thanks much.
@LabsHandsOn
6 жыл бұрын
Thanks for feedback
@asimsami9014
4 жыл бұрын
Many thanks for your support and guidance
@LabsHandsOn
4 жыл бұрын
Thanks
@shivasubramaniamvenkatesan5835
4 жыл бұрын
Great Video
@LabsHandsOn
4 жыл бұрын
Glad you enjoyed it
@acislak
2 жыл бұрын
Very informative
@tiennamnguyeninh6174
3 жыл бұрын
Thank for your shared. just one question. How can you configuration Heartbeat network?
@fahadoutlook1241
5 жыл бұрын
الحمد الله Very very nice. Thanks a lot
@LabsHandsOn
5 жыл бұрын
Thanks glad to know you like it
@rehantayyab82
5 жыл бұрын
Dear Vikas , very nice video .. im totally new in learning sql server database , has some experience oracle db and linux ..... dont know much how to create AD and DNS 1.in real production env AD and DNS and service account access is created by network admin ? 2. did u make any doccument for above configuration ....... i mean any blog etc other than video
@amalnellickal
5 жыл бұрын
Really helpful. Much appreciated.
@LabsHandsOn
5 жыл бұрын
Thanks glad to know you like it
@satyakandikattu2572
7 жыл бұрын
Very Helpful this video for Creating Clusters.
@LabsHandsOn
7 жыл бұрын
+Satya Josh thanks
@fahadoutlook1241
5 жыл бұрын
V. Nice lectures Thanks a lot
@LabsHandsOn
5 жыл бұрын
Thanks... Glad to know you like it
@Cult-Fan
5 жыл бұрын
Thanks so much
@LabsHandsOn
5 жыл бұрын
Thanks Glad to know you like it
@ulaganathan8335
7 жыл бұрын
Great Video Vikash. Nice and excellent work
@LabsHandsOn
7 жыл бұрын
Thanks bro
@meghamisra5622
4 жыл бұрын
Awesome video that's what I was looking for Thank you so much. Can you please also tell us how to do Always on in SQL server?
@LabsHandsOn
4 жыл бұрын
Please check on my channel you will find videos for sql server always on as well
@meghamisra5622
4 жыл бұрын
@@LabsHandsOn just one question how did you assign IP address for heartbeat? also how did you configure cluster on node1 without AD account installed on node1 or 2?
@prashanthkumar3163
5 жыл бұрын
Awesome thanks ..
@LabsHandsOn
5 жыл бұрын
Thank you very much for your feedback, Glad to know you like it..
@dharmindergenda4285
7 жыл бұрын
Very nice step by step video,, have a question - do we need to install SQL on both nodes or just one?
@LabsHandsOn
7 жыл бұрын
Hi Thanks, You need to install SQL on both servers
@dharmindergenda4285
7 жыл бұрын
Vikas Singh OK thanks.
@AndyVallejo-andrew94
6 жыл бұрын
thanks... and with the same account example: victorinfo\sqladmin ?? for the agents??
@WayneBarroncffcs
5 жыл бұрын
@@AndyVallejo-andrew94 First, you install [New SQL Server Failover Cluster installation] Then you will, [Add node to a SQL Server failover Cluster]
@selvakumaraa
7 жыл бұрын
Thank you vikash .. Its helped me lot ..
@LabsHandsOn
7 жыл бұрын
Welcome :)
@anjaneyulubommanaboyina7469
7 жыл бұрын
HI VIKASH, NICE EXPLANATION
@LabsHandsOn
7 жыл бұрын
Thanks
@literalbuddha2921
6 жыл бұрын
Thank you very much for this journey.
@LabsHandsOn
6 жыл бұрын
Thanks.... :)
@771hussain
8 жыл бұрын
Nice Sir . Thankyou so much. Request to Please record step by step VMware Certified Professional 6 - Data Center Virtualization (VCP6-DCV). Sir continues your mission.....................
@LabsHandsOn
8 жыл бұрын
Thanks sure will try
@mainoddinkhazi5148
7 жыл бұрын
Great Video Brother. Nice and excellent work.
@LabsHandsOn
7 жыл бұрын
Thanks buddy
@meyndertiej
7 жыл бұрын
Thank you very much. Helped me allot
@LabsHandsOn
7 жыл бұрын
Welcome dear
@AnuragGawande
6 жыл бұрын
Great video, thanks Vikas 👍
@LabsHandsOn
6 жыл бұрын
Thanks
@doctordey6473
2 жыл бұрын
thanks for teaching, it is really helpful. but unfortunately do not have any other server in my environment using as a ISCSI target server, is there any other way to do clustering without having a 3rd server involvement as Storage server ... Please Answer
@chuonghuynh2011
7 жыл бұрын
Thank you!
@user-fo9yn5fm9s
6 жыл бұрын
So great! it's really great!
@LabsHandsOn
6 жыл бұрын
Thanks
@jograddeguzman948
6 жыл бұрын
very helpful..thanks for sharing this
@LabsHandsOn
6 жыл бұрын
Thanks
@bg28686
7 жыл бұрын
Nice Video...Grt..
@LabsHandsOn
7 жыл бұрын
Thanks
@CHAMPUDUDE
6 жыл бұрын
Nice Video Vikas
@LabsHandsOn
6 жыл бұрын
+CHAMPUDUDE thanks
@ramanarao9227
7 жыл бұрын
Excellent...
@LabsHandsOn
7 жыл бұрын
Thanks
@sournsarim1411
4 жыл бұрын
could i ask you something please : 1- Quorum Disk 01 used for? 2- Quorum Disk 02 used for? 3- How about the two network used for? 4- How about IP Address (192.168.1.251 , 192.168.1.250) these IP used for? Thanks for your sharing please.
@fahadoutlook1241
5 жыл бұрын
This is active sandby configuration ... how to make both or all server active in cluster. So that it may use round robin to connect connect with any server to give quick response. Since we have more than 3K users and 25 differenet web apps.
@LabsHandsOn
5 жыл бұрын
i will try to create video on this topic soon.
@meghamisra5622
3 жыл бұрын
What do you call Hearbeats? are they IP addresses which you give to your nodes? I am new to this thats why asking
@ramanarao9227
7 жыл бұрын
Nice video...
@LabsHandsOn
7 жыл бұрын
Thanks
@PankajSinghBundel
5 жыл бұрын
How cluster validation will know the quorum drive is that one specific to configure in validation. And this will show C drive also in validation.
@LabsHandsOn
5 жыл бұрын
By default quorum disk is going to assign which smallest one, however you can change quorum settings anytime.
@alialkaabi8429
7 жыл бұрын
well done friend :)
@LabsHandsOn
7 жыл бұрын
Hi, Thanks
@vishalk2798
7 жыл бұрын
what are the steps that we need to do to set up your environment before following your viedo sir
@LabsHandsOn
7 жыл бұрын
Hi you just need Active Directory & DNS in place before going for this lab
@AbdelghafourSaidi
5 жыл бұрын
@@LabsHandsOn what about the shared disk?no SanDisk option? Any ateps
@AbdelghafourSaidi
5 жыл бұрын
@@LabsHandsOn In my case when I try to create virtual iscsi disk it's not detecting any of my local drives...any prereqs for the disks to be detected? Thanks
@oldaccountnotvalid774
5 жыл бұрын
Hi Vikas! I have a question can we setup our wep application/ desktop application through failover cluster concept.
@LabsHandsOn
5 жыл бұрын
Yes you can
@muddasarmunir6939
4 жыл бұрын
Hi, what is next step to test this cluster if one sql server fails, do you have any video on this topic? Also, do you have any video in which any web application runs on these clustered servers?
@LabsHandsOn
4 жыл бұрын
To Test SQL Cluster you can migrate from one Cluster node to other Cluster node.
@muddasarmunir6939
4 жыл бұрын
@@LabsHandsOn Thanks.
@MohamedSalah-qv8mv
7 жыл бұрын
Great work , thanks a lot , just one questions : if i created a Database on the first server , so Can i see it immediately from the SQL server of the second one as the directory of it located in the Quorum storage ?
@LabsHandsOn
7 жыл бұрын
SQL Server will run on cluster, Create SQL Cluster or create High Availability group for SQL Database.
@AdamSkerven
5 жыл бұрын
Do you have a video explain what is needed when you need to add new columns to a table, change to view, and/or drop a SP.. thx
@LabsHandsOn
5 жыл бұрын
drop me email at vikas.9452@gmail.com
@AdamSkerven
5 жыл бұрын
@@LabsHandsOn , Done.. Thank you!
@sriharshap3961
5 жыл бұрын
If I have a failover cluster Between two SQL database servers..then is it necessary to have physical lan connectivity between two servers?
@vansavangthongpaseuth3046
6 жыл бұрын
Nice Video sir. but i need to ask some i've only 2 Server how can cluster 2 node like this ? thank you forward for answer
@matthewsummers6545
6 жыл бұрын
what would be the process for having a sql cluster, and setting up one SQL for application and hitting the other SQL for reporting but the same cluster? if that makes sense Application{SQL 1} --------->{iscsi data for sql}
@vignasivakara
5 жыл бұрын
Hi, AD DNS is mandatory for this setup? or can we do any other cluster setup for MsSQL
@LabsHandsOn
5 жыл бұрын
AD is mandatory
@sriharireddy877
6 жыл бұрын
Hi Vikas Singh, I have one doubt can u clarify please.... If suppose Active directory server (WIN2K12R2-DC01) "DOWN" means, then all the setup will not work Right. Then what is the solution for that? The Active directory server has to failover for me. Can u provide solution or any alternative for that?
@LabsHandsOn
6 жыл бұрын
Yes sql cluster depends on AD there is no other way
@rongqingzhu1341
7 жыл бұрын
Good for you
@LabsHandsOn
7 жыл бұрын
Thanks
@9813374818
3 жыл бұрын
Hi, we are using cluster due to unexpected restart of data centre now SQL node 1 is working fine but on node 2 SQL server service s not running.error 1067 .The process terminated unexpectedly.
@nazmulhossain6844
5 жыл бұрын
you are use Cluster IP : 192.168.1.251 but SqlServer you installed but you are use in IP : 192.168.1.250 .. That is ques? Mainly am i using cluster iP address ?
@LabsHandsOn
5 жыл бұрын
Cluster IP is for Windows Fail-over Cluster and Second IP is for SQL Server Fail-over cluster itself.
@oldaccountnotvalid774
5 жыл бұрын
because this is just a installation but how can i configure my real app db with this concept. I would thankful if you explain
@LabsHandsOn
5 жыл бұрын
You are most welcome.
@elmerben3365
7 жыл бұрын
Nice tutorial. How you configure if in the cluster you have 30 instances? Drive letters are not enough.
@LabsHandsOn
7 жыл бұрын
+El Ben please send me email on vikas.9452@gmail.com
@mjkhan368
3 жыл бұрын
Please make active active cluster
@maheshnaik0286
5 жыл бұрын
Hi i think failover sql server node need to be install on Secondary server
@LabsHandsOn
5 жыл бұрын
I followed the same... please watch again... and let me know if you still having any query.
@ratanrabha9790
4 жыл бұрын
Thats what i was wondering if i missed that part.. Replayed many times but couldn't find.. Btw great presentation
@krupana
8 жыл бұрын
Excellent vikas. mean while can i know the fail-over trouble shooting
@LabsHandsOn
8 жыл бұрын
Thanks,Email me on vikas.9452@gmail.com
@Umair-3M
7 жыл бұрын
My question is that you have add to pcs in cluster when 1 pc writes to the shared disk dos it replicate on the 2 pc at runtime?
@LabsHandsOn
7 жыл бұрын
+Muhammad Umair yes if its part for sql cluster
@vaibhavwalavande3328
7 жыл бұрын
hi vikas, but producation work use storage not isci iniator right..one more thing Quarum why use and advantage
@LabsHandsOn
7 жыл бұрын
Hi, Please send me your query on vikas.9452@gmail.com
@louiegiberson1518
5 жыл бұрын
Can i use this configuration for workgroup Setup?..
@LabsHandsOn
5 жыл бұрын
no
@palocloud
5 жыл бұрын
what will be the network connection type for HB and iSCSI
@LabsHandsOn
5 жыл бұрын
HBA will be directly connected by HBA Adapter on servers. iSCSI will be connected over IP, from any network adapter.
@palocloud
5 жыл бұрын
@@LabsHandsOn I am talking about vmware workstation adapter type for HB.
@fahadoutlook1241
5 жыл бұрын
Brother! Do you have SCCM , SCPM Tutorial
@LabsHandsOn
5 жыл бұрын
Check my channel... you will got few videos on these topics for sure.
@zarteem
7 жыл бұрын
if I have only two servers (without storage server) and I need to configure failover between them (if one of them get down the other will continue to work) how i could do it ? can i make the target of any of them the other one ? thank you
@LabsHandsOn
7 жыл бұрын
+Ziyad A.Radhi yes u can but if target server goes down everything is down
@dmac5808
5 жыл бұрын
How can i practice this setup at home ?
@LabsHandsOn
5 жыл бұрын
You can build same infra on one physical machine for practice
@vishalk2798
7 жыл бұрын
sir dns viedo have u shown in your viedo series anywhere??
@LabsHandsOn
7 жыл бұрын
u can check here kzitem.info/news/bejne/t2Ns0IR8hmeWaKA
@reachchandu786
6 жыл бұрын
I am getting the following error message (unable to determine IQN for servername) .But configure the ISCSI Targate disk it's ok with me. Please help me what could be the reason.
@LabsHandsOn
6 жыл бұрын
Hi, Please send me more details and screenshot at vikas.9452@gmail.com
@dannyanicamamasgo6482
6 жыл бұрын
Hi Vikas, please, May you help me with this error? when trying to connect from another instance SQL Server... IP,1433 . SSMS show me the following error message... ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054) ------------------------------ An existing connection was forcibly closed by the remote host Information: WS2012 - SQL Server 2012
@KaranBhansali08
7 жыл бұрын
Does it work on azure the same way?
@LabsHandsOn
7 жыл бұрын
+Karan Bhansali yes it will but azure have also dedicated sql cluster options
@embentil
7 жыл бұрын
Hi Sir, during adding my NOD1 to query initiator, i get unable to determine IQN, please how do i resolve this.
@LabsHandsOn
7 жыл бұрын
Hi, send me issue details on vikas.9452@gmail.com
@nguyenhuucuong8775
7 жыл бұрын
Do we need install SQL Server in node2 (SQL-SRV02)?
@LabsHandsOn
7 жыл бұрын
+Nguyen Huu Cuong yes on all sql servers node
@nguyenhuucuong8775
7 жыл бұрын
Thank you so much. It's very useful and easy to deploy.
@fahadoutlook1241
5 жыл бұрын
You did not configure multi path
@LabsHandsOn
5 жыл бұрын
Its configured on windows cluster.
@gdevelek
6 жыл бұрын
I see you setting IP 1.251 in the Windows cluster, but then in the SQL cluster you set 1.250, am I missing something??
@LabsHandsOn
6 жыл бұрын
Please check video again, may be you can understand.
@gdevelek
6 жыл бұрын
If you could actually explain, I'd certainly understand.
@ancynoel5132
6 жыл бұрын
I think 192.168.1.251 is Windows Cluster IP n 192.168.1.250 SQL Cluster IP which clients can use to connect.
@NARENDRA24.
7 жыл бұрын
Very helpful but finally failed for path folder of documents and settings error code :-0x84CF0007
@archangel1100
6 жыл бұрын
FQDN Validation failed, While creating iSCSI disk. Help me to fix this.
@LabsHandsOn
6 жыл бұрын
Send me screenshot on vikas.9452@gmail.com
@bextla3737
7 жыл бұрын
is it need another server for check? so may l test this on my computer which ofcourse onlye have sql 2012
@LabsHandsOn
7 жыл бұрын
Fail Over requires two server to check fail over for sure, Please follow the video
@udaykirankoganti
6 жыл бұрын
Seems to be you forgot to add second node SQL-SRV02 to SQL Server failover cluster..
@LabsHandsOn
6 жыл бұрын
Hi Uday, Its there in video.
@udaykirankoganti
6 жыл бұрын
Thank you Mr.Vikas Singh.
@santoshbagwe9382
7 жыл бұрын
its half video u have to show node2 installation also...
@LabsHandsOn
7 жыл бұрын
Hi Santosh, On Node-2 we have to follow the same way. Please watch full video. You will get to know & understand.
@santoshbagwe9382
7 жыл бұрын
ok
@AnjiDudigam
6 жыл бұрын
after adding the drives in both failover cluster nodes. shared drives goes offline. if i bring online in server it is going offline in another server vice-versa
Пікірлер: 173