# Changing MSSQL Server Host

{% if "OpsHub Migrator for Microsoft Azure DevOps" === space.vars.SITENAME %}
\* Close OM4ADO application before execution of the utility.
{% endif %}

{% if "OpsHub Integration Manager" === space.vars.SITENAME %}

* Stop OpsHub Server Service before execution of the utility.
  {% endif %}

* Go to <code class="expression">space.vars.SITENAME</code>'s `<Installation Folder>/Other_Resources/Resources`

* Unzip `HostChange.zip`

{% if "OpsHub Integration Manager" === space.vars.SITENAME %}

* Open Command Prompt with administrator privileges and go to <code class="expression">space.vars.SITENAME</code>'s directory `<Installation Folder or OpsHub>/Other_Resources/Resources/HostChange` using command **`cd <Installation Folder or OpsHub>/Other_Resources/Resources/HostChange`**
  {% endif %}

\* Run \`HostChange.bat\` for Windows system.

{% if "OpsHub Integration Manager" === space.vars.SITENAME %}

* In case of linux system, run `HostChange.sh`
  {% endif %}

* Enter the path for <code class="expression">space.vars.SITENAME</code>'s Installation Directory

<div align="center"><img src="/files/fbgcCpaTSl6O9NqJSdip" alt=""></div>

### HostChange with MYSQL

* Enter the new Host Name for MYSQL:

<div align="center"><img src="/files/Fg81Xnsxpc1Et5CIjhPQ" alt=""></div>

* If the Host Name input is not entered in the above step, then user will get the notification mentioned in the screen shot below. As the Host Name is a mandatory input that defines the new Host Name you want <code class="expression">space.vars.SITENAME</code> database to refer to:

<div align="center"><img src="/files/WzmEDnY3Lh6pgdjACcCd" alt=""></div>

* Enter the Port for MYSQL:

<div align="center"><img src="/files/ps0dbTIJPgnXAJ7F3RtB" alt=""></div>

* If the Port input is not entered in the above step, then utility will use the existing Port \[entered at a time of <code class="expression">space.vars.SITENAME</code> installation]. If that is not the case, then enter the Port here:

<div align="center"><img src="/files/IDVP1FIbdSoETz3JJLCt" alt=""></div>

* Utility will check the connection with new Host Name:

<div align="center"><img src="/files/lsDVwa376kdo10L8vkod" alt=""></div>

### HostChange with ORACLE

* Enter the new Host Name for ORACLE:

<div align="center"><img src="/files/yDxbODKyNUynKXxnUPp6" alt=""></div>

* If the Host Name input is not entered in the above step, then user will get the notification mentioned in the screen shot below. As the Host Name is a mandatory input that defines the new Host Name you want <code class="expression">space.vars.SITENAME</code> database to refer to:

<div align="center"><img src="/files/oi5RNorNDlSGApB8k6WX" alt=""></div>

* Enter the Port for ORACLE:

<div align="center"><img src="/files/zhHr8FoCHweZTkF8RCUP" alt=""></div>

* If the Port input is not entered in the above step, then utility will use the existing Port \[entered at the time of <code class="expression">space.vars.SITENAME</code> installation]. If that is not the case, then enter the Port here:

<div align="center"><img src="/files/dBdBlu0Hnd7YWVoszXLE" alt=""></div>

* Utility will check the connection with new Host Name:

<div align="center"><img src="/files/lrDGdWeYZaxeWcJ2oUDc" alt=""></div>

### HostChange with MSSQL Server

* **Note**: If <code class="expression">space.vars.SITENAME</code> is installed with Windows Authentication mode, then before running the utility, the user needs to make sure that the user who is logged into the Windows \[where the <code class="expression">space.vars.SITENAME</code> is installed] also logs into the new host's MSSQL instance with the same credentials.
* Enter the new Host Name for MSSQL Server:

<div align="center"><img src="/files/ocyxKtaJyMUvHKTne2co" alt=""></div>

* If the Host Name input is not entered in the above step, then user will get the notification mentioned in the screen shot below. As the Host Name is a mandatory input that defines the new Host Name you want <code class="expression">space.vars.SITENAME</code> database to refer to:

<div align="center"><img src="/files/HWQAAXNIdxPuz29jWM7W" alt=""></div>

* If the new Host Name is a named instance, then there is no input required for the Port. Hence, after entering the Host Name, utility will check the connection with the new Host:

<div align="center"><img src="/files/pT9b4G9QdxOsxvMvbKtH" alt=""></div>

* If the new Host Name is a non-named instance, then enter the Port for MSSQL:

<div align="center"><img src="/files/SUrE2hwTisp6mPfHbOm9" alt=""></div>

* If the Port input is not entered in the above step, then utility will use the existing Port \[entered at the time of <code class="expression">space.vars.SITENAME</code> installation]. If that is not the case, then enter the Port here:

<div align="center"><img src="/files/DoSps0JMYgwUiBDkudNP" alt=""></div>

* Utility will check the connection with new Host Name \[In the case of SQL Authentication]:

<div align="center"><img src="/files/Ad3k6vZBPljdl4hhDcUj" alt=""></div>

* Utility will check the connection with new Host Name \[In the case of Windows Authentication]:

<div align="center"><img src="/files/z76TaOcz7XisGSuNgURl" alt=""></div>

### HostChange with PostgreSQL

* Enter the new Host Name for PostgreSQL:

<div align="center"><img src="/files/6MNzPF0Q7tDyI9OxZYay" alt=""></div>

* If the Host Name input is not entered in the above step, then user will get the notification mentioned in the screenshot below. The Host Name is a mandatory input that defines the new Host Name user wants <code class="expression">space.vars.SITENAME</code> database to refer to:

<div align="center"><img src="/files/bCUuzskz6UqrYvy89WGo" alt=""></div>

* Enter the Port for PostgreSQL:

<div align="center"><img src="/files/kwzUp0hXgbGX4BiKsA4j" alt=""></div>

* If the Port's input is not entered in the above step, then the utility will use the existing Port \[entered at the time of <code class="expression">space.vars.SITENAME</code> installation]. If that is not the case, enter the Port as shown in the screenshot below:

<div align="center"><img src="/files/GtUq1ji85ykXeMjUo7q5" alt=""></div>

* Utility will check the connection with the new Host Name:

<div align="center"><img src="/files/AA61CPJtOSAdzKeuLPkH" alt=""></div>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://opstech.gitbook.io/opstech-docs/7.223/manage/advanced-utilities/how-to-change-mssql-database-server-host.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.