Hi,

on a failover Cluster, every node got a sql server Installation. If a failover occours  the Cluster Manager will Start the services.

There are patches wich are installed on the passive...

Hi,

are you talking about windows failover cluster, or about always on availibility groups?

These anwsers are for the fail over cluster, not for the aoag.

1)

standard edition is able to create a...

Hi,

no, do not change the user on the primary.

If this would be my own sql server, I would walk trought this steps.

1. drop the wrong user on the secondary

2.  create...

Hi,

I think, this won't work. Just drop the wrong user, and create the new user with the script and the right SID.

Kind regards,

Andreas

Hi,

take a look at this topic:

https://www.sqlservercentral.com/forums/topic/database-mail-not-working-after-sql-server-2016-sp3

Kind regards,

Andreas

Hi,

have you checked, if your profile is "public" or "private"?

And is there an default profile?

Kind regards,

Andreas

Hi,

are you able to send e-mail from the windows server with bmail?

I would try, if the problem is maybe the e-mailserver, or the ssrs.

https://github.com/RussellGrew/bmailv107

Good luck

Andreas

Hi,

if your sql server and your workstation are in different domains, you may start your powershell with a run as command.

runas /netonly /user:your_domain\your_user path to powershell

Your are not able to...

Hi,

try this link, maybe there are some usefull information for you:

https://docs.microsoft.com/en-us/answers/questions/662469/log4j-vulnerability-concerns.html

Kind regards,

Andreas

PS: sorry, I should read your topic until the end, there is the same link like in...

• This reply was modified 3 years ago by  andreas.kreuzberg.

Hi,

have you checked your cluster error log?

I think there should be some usefull information.

Kind regards,

Andreas

Hi,

you should take a look at this parameters:

Cost Threshold for Parallelism

Max Degree of Parallelism

With these parameters, you are able to tell the sql server, how many of your cpu the...

Hi,

please choose different times for your backups. On our backups with a snapshot of VM, your database were "frozen" for some seconds. If this appears in the night, nobody cares.

But...

Hi,

have you changed the connection string at your application?

I think, this would only work, if you aoag is ready for read only, and if the connection string got the following...

Hi,

if you like powershell, take a look at this page:

https://docs.dbatools.io/Backup-DbaDatabase

It is quite simple and easy to use. Just build your script and use the windows scheduler.

Kind regards,

Andreas

Hi,

are you able to ping the listener name from your workstation. If the listner is correct in the AOAG, maybe there are some error in the AD or in your...