Ah ok no AO yet.

Has the mirros session ever successfully connected\synchronised?

What accounts are the sql server services running under?

Did you use gui or tsql to setup mirroring?

Susan-322874 (1/16/2014)

---

We use naming conventions for our SQL Servers and I'm having an issue getting the serverproperty(servername) match the @@servername.

I know that SQL controls the @@servername and I have that...

Sure, you can encrypt connections to SQL Server but it only uses 40 or 128 bit and based on the client. IMHO column level encryption is better, it's likely you...

In favour of TDE, it does also automatically encrypt any database backups, users may not just pilfer the backups and go restore them, they'll need the certificate that encrypts the...

New Born DBA (1/16/2014)

---

Which raises another question. Let's say if there is a DB which consist of 30 tables. All columns in those tables have to be encrypted. Why its...

crcoracle (1/16/2014)

---

Hi,

Do you guys know if I can set up a new SQL Server cluster with AlwaysOn Availability groups as follows:

- One node inside the local network

- Another node in...

Which replica is currently] the AO group primary, is it the FCI?

Have you configured a listener for the AO group?

if you encrypt the data at the column level you wont need TDE.

It may be that they want to encrypt certain data to stop people viewing it

Ted Zatopek (1/16/2014)

---

I did not capture the exact message at the time. It was sometime like "cannot establish mirroring on DB" I do all my mirroring...

asheppardwork (1/16/2014)

---

I apologize for the lack of clarity. The Stored Proc. that creates the table, drops it at the start. I scanned all the queries run around the time...

that covers a wide range of encryption options, is TDE the option you are seeking to implement?

GilaMonster (1/16/2014)

---

Prerequisites including reading up on how you...

There is a list of pre requesites that need to be met before you can enable TDE, have you performed these?

:Whistling: another totally useless option in respect of sql server that storage vendors plug to the nines claiming all sorts of benefits for sql server. Their detail in their plug...