Sql server 2012 AlwaysOn Availability Group deploy note

【声明】本文为AdamsLee原创,转载请注明出自围炉网并保留本文有效链接:Sql server 2012 AlwaysOn Availability Group deploy note, 转载请保留本声明!
  • deploy with only 2 VM in failover cluster. restarted one VM but another VM is still installing Sql Server 2012. And it got this error. Maybe it's caused by FailOver Cluster down.

TITLE: SQL Server Setup failure.
——————————
SQL Server Setup has encountered the following error:
There was an error to lookup cluster nodes. Error: There was a failure to call cluster code from a provider. Exception message: There are no more endpoints available from the endpoint mapper.
.
Error code 0x86D80011.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xD760FD9B%25400x300AF5FE
——————————
BUTTONS:
OK
——————————

  • add firewall exception after sql server installed 

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN
netsh advfirewall firewall add rule name="SQL Mirror Port" dir=in protocol=tcp action=allow localport=5022 remoteip=localsubnet profile=domain

  • Configure Route for ApplicationIntent = ReadOnly 

connection string e.g. Server=tcp:AGTest,1433;Database=DDMM;Integrated Security=SSPI;ApplicationIntent=ReadOnly

see detail from http://scottless.com/blog/archive/2012/01/25/sql-server-2012-configuring-alwayson-read-only-routing.aspx

此条目发表在未分类分类目录,贴了, 标签。将固定链接加入收藏夹。