# Microsoft SQL Server

Apica Ascent lets you connect to the Microsoft SQL Server which is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence, and analytics applications in corporate IT environments.

With Apica Ascent you can easily query, monitor, and visualize the MS SQL Server data

### Adding MS SQL Server to Apica Ascent

The first step is to create and add MS SQL Server to Apica Ascent and add fill out the below fields and save

* **Name**: Name the data source
* **User**: A user of the MS SQL Server which is in the form: `user@server-name`
* **Password**: The password for the above user
* **Server**: This is your server address without the `.database-windows.net` suffix
* **Port**: The port of the MS SQL Server
* **TDS Version:** TDS Version of your MS SQL Server
* **Character Set:** Character encoding of your MS SQL Server
* **Database name**: The name of the database of the MS SQL Server

Also make sure to Check out [Microsoft’s documentation](https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/create-data-warehouse-portal#create-a-server-level-firewall-rule) for instructions to whitelist your Apica Ascent IP address when connecting to Synapse.

![Configuring MS SQL Server](/files/ohuIQuYcLhAFXei5gUgD)

That's all, now navigate to the Query Editor to query your data


---

# 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.apica.io/data-sources/sql-data-sources/microsoft-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.