I know I can use CNAME alis to point from one SQL Server to another for upgrade or such log shipping, but what if one is named instance and other is default instance?

Do I need SQL alias?

Do i need such like this answer?

Create an alias for a SQL Server named instance pointing to sql default instance


  • The accepted answer on the link you provided worked for me. It should be something that is easily tested. Commented Feb 15, 2019 at 14:40
  • The main thing to remember is that the alias needs to be created on the servers that are trying to access the SQL Server instance - not (necessarily) on the server that hosts the SQL Server instance. Also make sure you address both 32 bit and 64 bit configs. Commented Feb 15, 2019 at 14:43
  • You might want to have a look at my Q & A related to What are valid connection strings for SSMS login box?. Basically the <SERVER>\<INSTANCE> syntax is telling the client to 1.) connect to the SERVER and then 2.) Contact the Browswer Service which will redirect the INSTANCE bit to the correct SQL Server instance. If you have configured your instances to listen to dedicated IP addresses and ports, then you could just use a CNAME and no further configuration is required.
    – John K. N.
    Commented Feb 15, 2019 at 14:46
  • @ScottHodgin ok ty if you want to add an answer or close?
    – user172612
    Commented Feb 15, 2019 at 14:58
  • @hot2use ty will read
    – user172612
    Commented Feb 15, 2019 at 14:58


Browse other questions tagged or ask your own question.