PS: There are also SQL-native log backups every 15 minutes.

Veeam is "targeting" the Hyper-V cluster, in that the ONLY object in Veeam is the cluster name computer object. So Veeam is interacting with the Hypervisor to enumerate VMs, and...

• This reply was modified 1 year, 10 months ago by  lanky_doodle.
• This reply was modified 1 year, 10 months ago by  lanky_doodle.

also the OS is generally not great - none of the application shortcut icons from start menu show properly. Considering cutting my losses with this VM!

yeah the OS disk needed a chkdsk (I split out SQL data files as per best practice).

Actually - I've just done this last test:

The AGL IP that worked in INSTANCE1 was x.x.x.100

The AGL IP that didn't work in INSTANCE2 was x.x.x.101

x.x.x.101 does not respond to a...

Another update;

we have stacked instances on the Windows hosts. I've just tried with what was the first named instance to be installed and it worked perfectly first time.

So I then...

I'm planning to trash all the Windows Failover Cluster config. (none of the SQL is using it yet) and start again, but would ideally like to know the root cause.

The hosts the VMs are running on are connected to the same network switches as the current physical SQL servers. Cluster.log is giving false information as well since it's complaining...

Hi!

Thanks for the replies.

Have an update on this...

created 2 new servers (VMs)

added Failover Clustering

created Cluster

installed SQL

enabled AlwaysOn in Configuration Manager

boom - creating an AG with an AGL during the wizard...

Hi, sorry for the late response.

SCCM was working one day then stopped literally the next. On inspecting the original SCCM config. (its connection string in Site Manager) it was set...

"Not trying to second guess your work, but usually when I hit odd snags like this, going back and double checking the "simple" stuff can lead me in the right...

PS: The permissions to AD/OU/DNS are exactly the same I have set in previous environments, and there it worked 100% of the time. I had to build about 20 AGs.

Weirdly, last week the AG Wizard was successful in creating the AG, but failed as above with the Listener. Yesterday I manually created the Listener and it worked (nothing was...

Yes I've read that article before. By "very well", I mean the "flow" of things in terms of what happens, i.e. the WSFC computer object is what needs access to...

Yes it is. As mentioned, I can connect to all instances (standalone and AG) from SSMS just fine.

The problem on AG instances is expanding the Databases node and querying user...