Sorry. Granting view permission meaning is connect access right?

Thanks for you're input's. So you're saying  specific to View any database and view any definition is not recommended? How about read and Granting Connect access?

This is like you can't have 2 same instances on one server right.

Thank you! How about cname1\inst and cname2\inst?

Thanks a lot! I really appreciate to everyone and it's very helpful.

Question regarding data synchronization. Actually we are migrating data from different database system to SQL Server which would be...

Thanks. I am looking for HA option with Automatic failover in the event of a system outage instead of manual failover. How about preferred methodology for patching if I go...

Thanks! Probably one last question. How would you handle the backups in Availability group when there is a flip between datacenters in a regular fashion?

Not sure why I said SAN replication. My apologies, I mean to say data replication at storage level. The idea is to be able to flip between datacenters on a...

Thanks. I will plan on using expert help. However, I am not sure either how failover works when SAN repl is at storage level. Would you see any benefits of...

Thanks! Data replication mechanism between the sites would you go with AOAG or SAN replication or any other method?