# Setting up MS-SQL connector

The MS-SQL Connector is set up as follows.

* To go to the Connector menu, select "Connector" under the APIs and Integration menu.

![](/files/MNtSnTIAsExsSP7ipSXM)

* In the APIs and Integration module, click \[+ Connector] to create a new connector.

![](/files/HiUWBZeK9PLu5jM0IbHT)

* The Details tab is preselected.

![](/files/wFvio4XzIkdoD3sWAjV0)

* Enter the Connector name as "Tutorial\_MSSQL". This name will be used to refer to this connector in the ETL applications.

![](/files/67nIlDDW90g2YCDJ3TKG)

* Add a description, optionally. 

![](/files/TFIjPCIg9hz9FxyIdDFU)

* Select “MsSQL” from the list of values.

![](/files/1qI3U8sfOFeBuRztxzuq)

* Add relevant details in the MsSQL Host & Login section: 
  1. “Host name”: The server details of the host. 
  2. “Port number”: The port number to connect. (By default, Langstack pre-fills it with the default MS-SQL port 1433. However, users can change the port number as needed.)
  3. “Username”: The username for the connector. 
  4. “Password”: The password for the connector. 
  5. “DB (Database) Name”: The Database name.

![](/files/jz61tED0liONsEHOxahV)

* Save the connection by clicking \[Save]. This activates the \[Test connection] button. 

![](/files/toTk6eU1GQl5AWGBezcs)

* To test the connection, click \[Test connection].


---

# 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.langstack.com/welcome/in-depth-learning/connectors/ms-sql-connector/setting-up-ms-sql-connector.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.