Are you trying to create SQL server alias?
This guide is for you.
SQL Server alias provides us the flexibility to choose a familiar name for the SQL Server instance.
It is very difficult to manage multiple servers as we have to remember the names of each and every server. To overcome this difficulty we can create SQL server alias.
Here at Ibmi Media, as part of our Server Management Services, we regularly help our Customers to perform SQL related queries.
In this context, we shall look into how to create SQL server alias.
Create SQL server alias using SQL Server Configuration Manager
SQL Server provides a configuration utility- SQL Server Configuration Manager with which we can either create an alias for the SQL server or delete the alias that was set previously.
The SQL Server Configuration Manager can also allows us to start/stop, pause/resume, and view the status of SQL Server services.
Managing server and client protocols and specifying SQL Server port can be done easily with SQL Server Configuration Manager.
We can launch the SQL Server configuration manager from the start menu.
Alternatively, we can look for it in the following directory if Windows is in the C drive:
SQL Server 2019
SQL Server 2017
SQL Server 2016
Steps for Creating an alias using SQL Server Configuration Manager ?
1. Take SQL Server Configuration Manager and go to SQL Server Native Client Configuration, from there check for subfolder Alias.
2. Then right-click on Aliases and click on New Alias.
3. We can give any name we wish to in the Alias Name box.
4. In the Server box, type the name or IP address of the server.
5. Next in the Protocol box, we can provide the protocol for this alias.
6. After filling in all the details we click on Apply and OK to see SQL Server alias in the Aliases list.