Thanks for the information, Eddie!

After creating the SQL Server certificate, from the Windows certificate, is there a security risk with keeping the complete certificate in the Windows store (cert &...

If you are in fact using a domain account, try using the following command in command prompt:
setspn -L <account_name>
example:    setspn -L srv_sqlaccount

What this will do...

Thanks goher2000, that'll be handy

Thanks Alejandro.  After further trial/error I found that it was DATABASE_ROLE_MEMBER_CHANGE_GROUP that logged the permission changes (dummy mistake on my part).  I've also added the ones you suggested just in...

Thanks Lynn & Jeff for your input.  I too will stick with using T-SQL over Standard SQL.  I do find it interesting that this book suggests using Standard SQL over...

I think this is a face-palm moment.  The FOR word resolved it.  Thanks Perry.

This does resolve the problem, the log file is no longer growing.  The database was initially set to the SIMPLE recovery mode.  

Dan

The solution was to, in short, back up the Subscriber database.  Since our log file was so large, and since we don't want to keep the backup of it, the...

I might have the solution but I'm going to wait until tomorrow to see if it fully works.  I'll post my findings here afterward.

If you're talking about Availability Groups then all AG Listeners for all SQL Server instances can be on port 1433 as long as ONLY the listeners are using port 1433....

Thanks VastSQL and Ricky

When adding the AG the Primary's "Endpoint URL" textbox is locked.  Any secondary I add the textbox is editable.

I found the problem that was restricting me from adding a secondary replica.  First to mention, this was a second instance on this node, the first instance was already in...

Beatrix Kiddo- The following worked with no errors:
  ALTER AVAILABILITY GROUP AvailGroup1 ADD REPLICA ON 'Node2\instance1'
  WITH (
  ENDPOINT_URL = 'TCP://Node2.xyz.com:5022',
  AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,
  FAILOVER_MODE...

VastSQL- It does not already exist on this instance, however there is a different instance that it does already exist on, and works on.
Beatric Kiddo- It is in the...