# How to set up web-based SQL server on OpenStack instance using SQL image?

**Pre-requisites:**

* SQL Window server
* Window console
* Good internet connection

**Follow the below steps:**

**Step 1:** Go to **Run** and type **mstsc** and hit **OK.**

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/703_2023-01-04-17_15_01-.png" alt=""><figcaption></figcaption></figure>

**Step 2:** Enter your IP address and select **Show Options**.

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/694_2023-01-04-15_41_00-.png" alt=""><figcaption></figcaption></figure>

**Step 3:** Enter **Administrator** in the username and hit **Connect.**

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/695_2023-01-04-15_43_25-.png" alt=""><figcaption></figcaption></figure>

**Step 4:** Enter the **password** field and hit **OK.**

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/696_2023-01-04-15_48_40-.png" alt=""><figcaption></figcaption></figure>

**Step 5:** Click **Yes** on the certificate prompt.

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/697_2023-01-04-15_57_17-.png" alt=""><figcaption></figcaption></figure>

**Step 6:** Go to the **Start** button and select **Microsoft Server Tools.**

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/698_Img-1.png" alt=""><figcaption></figcaption></figure>

**Step 7:** Select **SQL Server Management Studio.**

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/699_Img-2.png" alt=""><figcaption></figcaption></figure>

**Step 8:** Select **SQL Server Authentication** as the Authentication type, enter **SQL** in Login, **Admin\@321** in **the** password for SQL Server, and hit **Connect.**

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/700_Img-3.png" alt=""><figcaption></figcaption></figure>

You are now logged into the server.

You can also change your password. Follow the below steps:

**Step 1:** Select **Security,** then choose **Logins** and select **SQL.**

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/701_Img-5.png" alt=""><figcaption></figcaption></figure>

**Step 2:** Enter the password, confirm the password and old password, and hit **OK.**&#x20;

<figure><img src="http://customer.acecloudhosting.com/index.php?rp=/images/kb/702_Img-4.png" alt=""><figcaption></figcaption></figure>

Your password has now been changed successfully. Enter your new password to log in again.
