# Select a Microsoft SQL Server Image

A Microsoft (MS) SQL Server image provided by IONOS Cloud can be selected and configured just like any other public image while setting up a Block Storage. To do so, follow these steps:

1\. [<mark style="color:blue;">Add Storage to a Server or a Cube</mark>](https://docs.ionos.com/sections-test/guides/block-storage/how-tos/set-up-block-storage#add-storage-to-a-server-or-a-cube).

2\. [<mark style="color:blue;">Configure Storage</mark>](https://docs.ionos.com/sections-test/guides/block-storage/how-tos/set-up-block-storage#configure-storage).

* In the **Image**, select IONOS Cloud offered **Microsoft Images**.

![IONOS Cloud Microsoft SQL Server Image](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-fd4653676137adbe4e4a23dd0dd21028cc007e8d%2Fionos-microsoft-images.png?alt=media)

3\. [<mark style="color:blue;">Continue with Authentication</mark>](https://docs.ionos.com/sections-test/guides/block-storage/how-tos/set-up-block-storage#authentication).

4\. [<mark style="color:blue;">Add a CD-ROM drive</mark>](https://docs.ionos.com/sections-test/guides/block-storage/how-tos/set-up-block-storage#add-a-cd-rom-drive).

{% hint style="info" %}
**Note:**

* During provisioning, you can define the SQL Server administrator password and specify any necessary configuration settings. For more information, see [<mark style="color:blue;">Set Up a Block Storage</mark>](https://docs.ionos.com/sections-test/guides/storage-and-backup/block-storage/how-tos/set-up-block-storage).
* MS SQL Enterprise is only available on request. For more information, see [<mark style="color:blue;">Microsoft SQL Enterprise Server Images</mark>](https://docs.ionos.com/sections-test/guides/storage-and-backup/images-snapshots/public-images/microsoft-sql-server-images/how-tos/enterprise-server-images).
  {% endhint %}

{% hint style="success" %}
**Result:** The Block Storage setup is completed using the MS SQL Server Image.
{% endhint %}

## Next steps

To find the IP address of the newly created server after provisioning, follow these steps:

1.In the **DCD**, go to **Menu** > **Virtual Data Centers** and select the data center from **My Virtual Data Centers**.

2\. In the Inspector pane, select the data center and go to **Network** tab.

3\. Under **IPv4 Configuration**, note the **Primary IPv4** address.

{% hint style="success" %}
**Result:** The IP address of the server is successfully retrieved.
{% endhint %}

![Retrieve server IP address](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-0ed793e1d8bbf2ea81b742027825c3500119aaf0%2Fretrieve-server-ip-address.png?alt=media)