# Login to the SQL Server

{% hint style="info" %}
**Prerequisites:** Make sure you are logged in to the Windows Server using the **Remote Console** in the DCD. For more information, see [<mark style="color:blue;">Connect via Remote Console</mark>](https://docs.ionos.com/cloud/compute-services/cubes/dcd-how-tos/connect-remote-console). Alternatively, you can access the server using Remote Desktop Protocol (RDP) when connected to the internet.
{% endhint %}

## Start SQL Server Management Studio

You can start the **SQL Server Management Studio** using one of the following options:

**Option 1:**

* Start the **SQL Server Management Studio** from the taskbar.

![Start SQL Server Management Studio from the taskbar](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-a7483cfed269f581eb68478a36e08f0b63a824a6%2Fstart-sql-server-management-studio.png?alt=media)

**Option 2:**

* Type SSMS in the search box and start the program.

![Start SQL Server Management Studio from search box](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-7ddcd49c747d5eb962e9dacdbe50d48cab00cccc%2Fssms-start-sql-server-management-studio.png?alt=media)

**Option 3:**

1\. Press the Windows key + R. 2. Type **SSMS** in the next dialog box. 3. Click **Enter**.

{% hint style="success" %}
**Result:** You have successfully started the **SQL Server Management Studio**.
{% endhint %}

## Connect to Microsoft SQL Server

* Once the login window is started, select **Windows Authentication** and adjust the **Encryption** to **Optional** to be able to connect to the SQL Server.

**Note:** The **Optional** encryption setting lets you connect to the SQL Server instance immediately without encryption. Alternatively, you need a valid certificate from trusted certificate authority.

![SQL Server encryption type](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-dd85d894b880e8827024ab8c44153bc958701adc%2Fconnect-sql-server.png?alt=media)

{% hint style="success" %}
**Result:** You have successfully connected to the SQL Server.
{% endhint %}

{% hint style="info" %}
**Note:** By default, the local server's hostname is the **Server name**. All members of the **Local Administrators** group have system administrator rights to the SQL Server.
{% endhint %}

![Microsoft SQL Server Management Studio (Administrator)](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-58b0531318177a396f82853addc83765e4de22d4%2Fmicrosoft-sql-server-management-studio.png?alt=media)


---

# 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://docs.ionos.com/cloud/backup-and-storage/images-snapshots/public-images/microsoft-sql-server-images/how-tos/log-in-sql-server.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.