Cannot connect to named instances on AG all listening on 1433 using DNS records

• 
  Hi @TiborKaraszi,
  
  The default behaviour as you have seen is to connect to machine_name\instance_name (i.e. only connecting to the instance based on the IP of the host server.
  
  There is the ability to specify a connection string directly into the repository which I'll provide directions for below.  We always suggest taking a backup of the repository before modifying it directly.  If you run into any issues please revert this by setting the ConnectionString column back to NULL.
  
  To update the ConnectionString column, performing the following:
  

  1. Get the Id of the specific SQL instance to update by looking for it in the settings.SqlServers page. The instance on a cluster node will be machineName\instanceName (or just machineName\ if the default instance).  You may also want to confirm the ParentId matches the top level entity which you can find in the settings.Clusters table ON settings.SqlServer.ParentId = settings.Clusters.Id
     

     SELECT Id FROM settings.SqlServer 
     WHERE Name = 'myMachine\myInstance';

  2. Update the ConnectionString column for the given instance by Id
     

     UPDATE settings.SqlServers
     SET ConnectionString = 'Data Source=111.222.333.444;'
     WHERE Id = '<Id for specific Sql Instance>' ;

     
     

  Kind regards, Alex

  Alex B October 06, 2023 11:10

  - 0 +
• 
  That sounds promising. Thanks Alex! I'll get back when I've tested it. :-)
  

  TiborKaraszi October 06, 2023 14:05

  - 0 +

Add comment

Please sign in to leave a comment.