Eprs_Admin
asked on
How to install SQL2014 on two nodes ?
Hi Experts,
I have two new servers for my SQL DB.
Can you help me to install SQL 2014 in the right way ?
The servers are physical and the DB should be installed on premise.
I have heard the Availability Groups are best here, right ?
Do I need a cluster for it ?
I hope you can guide me with this installation.
I have two new servers for my SQL DB.
Can you help me to install SQL 2014 in the right way ?
The servers are physical and the DB should be installed on premise.
I have heard the Availability Groups are best here, right ?
Do I need a cluster for it ?
I hope you can guide me with this installation.
ASKER
I want to have my DBs on locally disks on my two sql servers.
But when one fails, the other server should take over without mentioned by the clients.
Is it possible ?
But when one fails, the other server should take over without mentioned by the clients.
Is it possible ?
Hi,
From SQL Server 2012, Microsoft introduced ALWAYSON GROUP for High Availability and Disaster Recovery. Depending on your SQL Server version:
Standard: supports two nodes
Business Intelligence: supports two nodes
Enterprise: maximum OS supports
Thanks,
From SQL Server 2012, Microsoft introduced ALWAYSON GROUP for High Availability and Disaster Recovery. Depending on your SQL Server version:
Standard: supports two nodes
Business Intelligence: supports two nodes
Enterprise: maximum OS supports
Thanks,
You mean, use AlwaysOn for High Availability solution. Yes, it's possible.
ASKER
Yes I have just two nodes. So STD version is enough.
I want to realize this scenario:
When one node crash, the user should still work.
The DB needs to be the same on both nodes.
When I am correct, this is possible with Availability Groups.
Can you help me step by step to set this up ?
What do I have to install first, second and so on.
Maybe you have a nice video or manual for all.
Since now, I have installed WIN2012R2 on both nodes, with the same partition setup :
C : OS
D: DATA
E: TempDB
T: LOGs
I want to realize this scenario:
When one node crash, the user should still work.
The DB needs to be the same on both nodes.
When I am correct, this is possible with Availability Groups.
Can you help me step by step to set this up ?
What do I have to install first, second and so on.
Maybe you have a nice video or manual for all.
Since now, I have installed WIN2012R2 on both nodes, with the same partition setup :
C : OS
D: DATA
E: TempDB
T: LOGs
Those node supports that Dung Dinh posted is only matter if you are going to use SQL Server Failover Cluster instances. You won't need node supports if your SQL Server instances are stand alones.
Since now, I have installed WIN2012R2 on both nodesAre the Windows a cluster?
ASKER
not yet.
Do you have an easy manual to create the Windows Cluster ?
Do you have an easy manual to create the Windows Cluster ?
You can search in the internet.
Here's one of many: Creating a Windows Server 2012 Failover Cluster
Here's one of many: Creating a Windows Server 2012 Failover Cluster
ASKER
ok I go through this link, thanks.
ASKER
ASKER
Do I need Storage in this cluster ?
Depends on what kind of solution you'll install for SQL Server.
If it's a Failover Cluster instance then yes, you'll need to add disk resources.
If it's stand alone instances then you don't need to add disk resources.
If it's a Failover Cluster instance then yes, you'll need to add disk resources.
If it's stand alone instances then you don't need to add disk resources.
ASKER
I want to install AlwaysOn for my SQL solutuion.
So I have to install SQL on each node as a single instance.
Right ?
About storage pools or disks, I cannot add these resources.
My resources just local storage.
Do you have a step by step guide for SQL2014 installation ?
So I have to install SQL on each node as a single instance.
Right ?
About storage pools or disks, I cannot add these resources.
My resources just local storage.
Do you have a step by step guide for SQL2014 installation ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok I am going to install it now.
I have to do this two times on both nodes.
I have to do this two times on both nodes.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, make sure you set up a witness for your cluster. If you're not going with shared storage and an AlwaysOn Availability group deployment, a fileshare witness is what you'll use. WSFC in Server 2012 and up does a lovely job of dynamic quorum calculation where it will dynamically modify the voting rights of the nodes/witness in order to always maintain an odd number of votes.
ASKER
ok, this is done.
Now I have to setup the feature AlwaysOn.
Do you have a link for step by step guide ?
Now I have to setup the feature AlwaysOn.
Do you have a link for step by step guide ?
You should open a question how to use an internet search engine? :)
MSDN has everything about AlwaysOn. You can start with this one and if you get issues return here so we can help you going through.
MSDN has everything about AlwaysOn. You can start with this one and if you get issues return here so we can help you going through.
ASKER
I want the info from the experts :-)
Therefore I am asking you, because you have often better links and infos.
Therefore I am asking you, because you have often better links and infos.
ASKER
Hi what kind of SQL version I need for AlwaysOn feature ?
ASKER
I have seen, AlwaysON Availability Groups are just possible with ENT version, right ?
So what can I do with my STD version ?
So what can I do with my STD version ?
I have seen, AlwaysON Availability Groups are just possible with ENT version, right ?Right
So what can I do with my STD version ?For AlwaysOn, nothing. But you can use it for clustering, mirroring or log shipping.
ASKER
OK when I use FCI I need a shared storage right ? -> I have now two servers with disks.
What about mirroring ? Is this also HA ?
What about mirroring ? Is this also HA ?
OK when I use FCI I need a shared storage right ? -> I have now two servers with disks.Right.
What about mirroring ? Is this also HA ?Yes. AlwaysOn it's a better version of mirroring. In Mirror solution the secondary database is not available. And before you ask here's the MSDN article to set up database mirroring :)
ASKER
I asked my customer support for a ENT version SQL 2014 ENT Server/CAL.
They told me, an ENT version for CALs are not available.
Is it right ?
They told me, an ENT version for CALs are not available.
Is it right ?
They're right. Server+CAL is only for Standard and BI editions.
For Enterprise Edition it's only available licensing by Processor.
For Enterprise Edition it's only available licensing by Processor.
ASKER
OK, in my case I can still use the old version SQL 2014 ENT Server CAL.
And I can use my CALs here.
Tanks.
And I can use my CALs here.
Tanks.
ASKER
What do you think, is a listener needed ?
When yes, what kind of IP address is needed ? same subnet ?
When yes, what kind of IP address is needed ? same subnet ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What I don´t understand, Where the client has to connect ?
With the clustername or with the Listener name ?
With the clustername or with the Listener name ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok thanks.
now just a question about the share which is needed.
I have read it is used to create backups of the primary DBs.
Can I use a share on one of my SQL nodes, because here I have a partition for backups?
Or is it better to create this share on my netapp storage ?
now just a question about the share which is needed.
I have read it is used to create backups of the primary DBs.
Can I use a share on one of my SQL nodes, because here I have a partition for backups?
Or is it better to create this share on my netapp storage ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have an error on creating the AG -> Error 35250
Do I have to create the AG on both nodes or is enough on the first node ?
Do I have to create the AG on both nodes or is enough on the first node ?
Never saw that error but found an article that could be helpful to you. Try to follow those instructions and see if it solves your issue.
ASKER
ok solved
ASKER
Man you helped me a lot.
Thanks for all
Thanks for all
I'm glad that I could helped you.
Cheers.
Cheers.
Yes, you do need a Windows Cluster. No, you don't need SQL Server cluster instances.