fbpx
Change SQL Server instance name after installation

Change server name – How to Modify SQL Server Instance Name?

STEPS TO CHANGE SERVER NAME OR MODIFY SQL SERVER INSTANCE NAME

Today at The Email Shop, I will guide you on why you should change server name and modify SQL Server Instance Name running on a Linux Server. Moreover, you will know how the server name for the BMC Remedy AR System (BMC Remedy Action Request System) can be modified in the configuration process.

How to Modify SQL Server Instance Name working on a Linux Server

Issue:

Often we have to rename the name of a SQL Server instance to comply with our server environment. We must also adjust the name of the SQL Server instance to prevent problems when it comes to the change server name Linux. This tip will describe how to rename a Linux-based SQL Server case.

When modifying the hostname of a SQL Server operating computer system, metadata must be changed to avoid access loss for remote connections and applications.

change server name

Settlement

The method of changing an instance name of the SQL Server has not been modified as it is performed on the SQL Server in Windows. We must remove the current SQL Server Instance name with SP drop server method stored procedure and add a new SQL Server instance name with SP add server method stored procedure.

You need to update SQL Server’s instance if you have already changed the Linux server’s name where SQL Server is running. I’d teach you how to change server name SQL server in the following parts step by step. I will show you the method.

You must guarantee you do not affect a title when modifying a SQL server instance name.

NOTE: Test in the lower life of Cycle FIRST.  Do not make changes in production without Testing in a lower life cycle environment. 

Retitle SQL Server Instance Running on a Linux Server

Step 1:

The first move is to search the current Linux hostname and the instance name of SQL Server. Start the PuTTY console to bind to the Linux service that installs SQL Server. You can also log-in and connect directly to the Linux server. For the links, I’ve used PuTTY. Enter the log-in name and password for you. We can bind to the SQL Server instance until you are linked to the Linux server.

Use the sqlcmd value to link to the SQL Server instance and enter a password whenever requested.

-S192.168.209.133 -Usa Sqlcmd 

Once linked to SQL Server, check the name of the SQL Server instance by executing the instruction beneath.

@@SERVERNAME SELECT 

Quit the sqlcmd prompt to search the hostname of the Linux server by typing the code.

Step 2:

Again, log in to SQL Server’s instance using sqlcmd to bind to SQL Server with the following command.

Transfer the IP and password of your SQL Server instance to an account.

-S192.168.209.133-Usa -Usa Sqlcmd 

Once attached to the SQL Server, we remove the original name of the system metadata from the SQL Server’s instance name and then apply a new name utilizing system-save procedures. After you have linked to the SQL Server instance, you have to execute the following commands to modify them.

Run the command below to drop the current SQL Server instance name SQLServerRHEL.

SQLServerRHEL sp_dropserver 

Using the command below, add the latest techyrhel instance name to the device metadata.

Techyrhel, local sp_addserver 

The SQL Server Instance Post can be checked using the above instructions, but it may indicate the old name. To add a new name, we have to restart the SQL Server operation.

Step 3:

The following command is used to restart the SQL Server operation.

  • Reset operation of SQL Server.
  • Restart MySQL server by Systemctl
  • You will be asked to enter your password after executing the order above. Enter your passcode for this procedure. It would help if you searched again the change SQL server instance name after installation to verify the modifications when the SQL Server operation is resumed. Use the sqlcmd utility to connect to the SQL Server instance on your Linux terminal.
  • Connect to SQL Server with sqlcmd.

Sqlcmd -S192.168.209.133 -Usa 

Enter the same code, then execute the following command until attached to search the name of the instance of a SQL Server.

Perceive the name of the instance SQL Server.

@@SERVERNAME Choose 

Your instance name on a Linux server has now been modified.

Other steps to Change server name

To allow SQL Server database connections for apps using an older SQL Server Instance Name, you need to update the application’s reference string according to the current name. If not, the connection problems could be faced with your submission.

While using a duplicated or moved environment, modifying the server name.

This section explains how the BMC Remedy AR System (BMC Remedy Action Request System) can be modified in the configuration process. Some or all of the following things must be updated:

  • (Single Windows) Registry detail by using Regedit
  • Registry detail by using Regedit

Form data utilizing a client like the browser of BMC Remedy AR System 

User Name is the alias name that an AR System Server recognizes. You will need to update the name of a server because:

Use case 1

By upgrading all items first and then restoring the development server’s database, you set a staging server (as part of the update process). The database may contain references to the production server that could not be used with the staging area. You only have to modify the type of details in this situation.

Use case 2

You set up an update server by first restoring the database and then install the latest BMC Remedy AR system environment (this is called an accelerated installation). You only have to modify the type of details in this situation.

Use case 3

A policy or a hostname alters the name of the server. You have to update the register, the setup files, and the type of data in that case (on Windows).

Use case 4

You move the server to a third party and use a different name alias for the server. You have to update the register, the setup files, and the type of data in that case (on Windows).

Finishing line 

Today The Email Shop, I have guided how to change server name. Moreover, there’s something you need to remember if you wonder why you should use a private nameserver:

To represent their company, certain resellers prefer to use a personal name server, which means, as one customer checks WHOIS, it shows the reseller’s nameservers rather than the hosting companies’ nameservers.

Apart from “appearance,” you won’t have to call all your customers and ask them to update their names to new nameservers when you choose to change servers or switch hosts. All you do is refresh the IPs of your private nameserver as you change servers or switch hosts. As soon as you change your name server’s IP addresses, domains continue to spread to your new server.

No Comments

Sorry, the comment form is closed at this time.