- 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