Hi Steve, Sorry I did not explain that clearly and thank you for your post.

I was restarting the Secondary (Synch) node of a AlwayOn cluster. On restart the secondary node...

Hi Sue,

Thank you for your guidance. 
Will I have these options (TrustStore, ValidateServerCertificate etc), if I was to do an OLEDB connection to the server having the certificate...

(Environment Details - 1 SQL Server, 1 Replay Controller & 16 Replay Client Servers)

Quick update -
Took a new trace using the TSQL_Replay template as suggested and...

Hi Gail,

Thank you for your reply. What is strange is that I can open the said trace file in profiler without any issues, it only fails in the preprocess stage.
Its...

Our issues got fixed once the queries were optimized by the Vendor.
Also remember fixing incorrect SQL Server configuration issues such as maxdop, cost threshold, Tempdb etc. on the said server.
Thank you...

Hi Kevin,

Thank you for the link. Really appreciate your help with this.

Regards,
Kailash.

Hi Kevin,

Thank you for your reply. I have looked online but I could not find a fix to the issue and hence this post. I will look again incase I have missed something that...

Hi Joie,

I have resolved the above issue by following your instructions therefore thank you for all your help and guidance.

Kind Regards,
Kailash Kanaya.

Hi Joie,
Thank you for your reply. This is a brand new AG that was being built using the wizard and the share where backups are stored lost connectivity while the database...

Thank you Perry Whittle and Joie Andrew for the guidance and links, will go through the Stairway and link above.
Thank you once again.

Regards,
Kailash.

Thank you for your replies Kevin, Jeff & Gail. Really appreciate the help and advice that you have given me.

This is a 3rd party application that I have recently...

Thank you Perry, have just read through them and they were very helpful.

Thank you once again for your help and guidance.

Having investigated further we have two options -

1) We could use a single certificate on all the SQL Servers that will have TDE setup and generate DEK on user...

Once you run DENY VIEW ANY DATABASE for the Developers user id, The developer will not be able to see any databases in SQL Server Management Studio unless they are...

SQL 2008R2 Express Edition has the following limitations -

Maximum 10 GB per database.

Uses no more than 1 processor.

Uses no more than 1 GB of internal memory.

Every user connection takes...