Got into a production down scenario when AD scavenging removed the SQL Server's Virual Server Name got removed from DNS. This made the TCP connetivity failures (both windows and SQL, so this is not SSPI context issue) when the client's tried to connect using
the Name. The connectivity succeeded on IP address and we have got Alias as a remedy for now.
We are asking the AD guys to add the record into Active Directory. But the AD guys are asking for an official documentation that says that there is no straight method from inside SQL to add the name to DNS (just like what the cluster setup
does) and we have add it manually to DNS. Does anyone know of an "official microsoft" documentation around this?
View Complete Post