0

We are running SharePoint 2010 server farm locally. Now it is our requirement to move SQL Server 2012 on Amazon EC2.

Requirement: We want to connect SharePoint 2010 server on-premise with Amazon EC2 SQL server 2012 (Cloud).

I've googled a lot but can not find the hybrid connection between them. I found many blogs in which they are showing to move SharePoint server along with SQL in the cloud but couldn't able to find for hybrid connection.

My question are:

  • Is it possible to do hybrid connection between SharePoint and SQL as mentioned above?
  • How to connect SharePoint 2010 local server 2012 with Amazon EC2 SQL server?
  • 1
    I don't think it's doable, and it is certainly not recommended even if doable. The best practice is to keep your database farm as close to your SharePoint servers as possible to minimize lag and round trip times. – tekiegreg Jun 9 '16 at 12:25
  • Thanks for the reply. It is very helpful but could you please provide some msdn links or blogs on that so that I can pass it to my client? – Dikesh Gandhi Jun 9 '16 at 12:42
4

It is possible but it is not supported( if not meet the requirement). Your topology falls under the stretched farm which has very high requirement.

There is a highly consistent intra-farm latency of <1ms (one way), 99.9% of the time over a period of ten minutes. (Intra-farm latency is commonly defined as the latency between the front-end web servers and the database servers.) The bandwidth speed must be at least 1 gigabit per second. Read more here

Also check this

  • Thanks for the reply. Information is very useful to me.:) – Dikesh Gandhi Jun 10 '16 at 4:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.