New answers tagged

1

As per Microsoft documentation, under SQL Server Editions: SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build ...


0

This seems to be caused by limited resources (CPU, RAM) of my test environment. When I repeated this setup in a cloud with ample resources, the problem disappeared.


1

I'm assuming the title is the question... Ensure that cluster name object (CNO) is granted permissions to the Secure DNS Zone You'll need to check with whatever you're using for secure dns (SecureDNS, Infoblox, etc.) and either allow access using that computer account or create the DNS entries and don't give it access. The error is just stating it can't ...


0

Go to your Roles, click on AG and on the bottom you have resources - click on it. Then open properties of Other resource - Your AG and go to Policies and play with those values.


0

I can launch SQL Server FCI over the existing EC2 Windows Server with SQL. I have two node cluster (This is a limitation of Microsoft for Standard Edition). The SQL Installation file is present in the C: drive of the Windows Machine. You can use this installation file and launch more SQL Server Instances.


2

If you want to mix FCI and AG, you can do so and it is supported. Below is a hypothetical configuration. Failover Cluster Instance (Node A, Node B), addressed as Server 1. All clients connect to Server 1. Only one Node is live at a time (i.e. only one node has control of the storage that has the databases on it. Node C lives in your Disaster Recovery ...


2

You cannot convert an existing standalone instance to an Failover Clustered Instance (FCI). You can configure standalone instances to be part of an Availability Group, but FCIs use a separate install path, and must be configured from the point of install. From the AWS docs FCIs require some form of shared storage—disks on a storage area network (SAN), file ...


Top 50 recent answers are included