Microsoft do not recommend changing the port on a default instance, leave it at 1433.

Why do you want to change it

jamessdba (6/22/2016)

---

Hi experts please provide your inputs on below scenario

we have Server (A,B-one n/w)C--on diffrent n/w

A-> B Mirrorg Configured

A-> C Logshipping Configured

if AB server/n/w fails our intention is to ...

Hi Brandie

thank you for your responses, I'll address all of the questions here in this single post if that's ok.

Brandie Tarvin (6/22/2016)

---

Quick question on the backups... Does Always On take...

yes, it would

previously I've used powershell to do this, works very well

Is it a virtual environment?

is this a same-site or cross-site cluster?

how many NICs does each node have?

Leonard Rutkowski (6/1/2016)

---

1. Currently, we use cluster for HA, and SAN replication for DR. During a DR test, we 'break' replication, and mount the replicated LUNS on our UAT system....

Joie Andrew (6/2/2016)

---

When a node is the owner of the listener the NIC on that subnet is listening on the listener IP as well as the IP it is primarily...

SSRS security may also be used to provide separation for users within the same SSRS instance.

no real need for multiple instances or even multiple servers

importing the RAID array on the new server may be possible depending on the controller.

However, I would take a full backup of the drive first to prevent any data loss

as Kevin has said just be aware of the limitations before you set this all up

at a guess I would say the application is connecting to the primary instance, when failover occurs this is when it breaks.

Confirm the client connection string please

have you successfully joined the machine to the domain?

Can you provide a little more detail at all?

Siberian Khatru (5/24/2016)

---

Does anyone know for sure whether or not restarting the SQL Server service on the active node of a clustered SQL Server 2012 environment (2 nodes) will precipitate...

definitely states AG