# 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](https://2948796384-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmzGprckLqwd5v6bs6m%2Fuploads%2FciLPadagRnWRDD2DwB3A%2FScreenshot%20from%202022-06-29%2021-17-37.png?alt=media\&token=89d331fa-b2e3-4c92-a859-4f440fd6dc08)

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