> For the complete documentation index, see [llms.txt](https://docs.langstack.com/welcome/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.langstack.com/welcome/in-depth-learning/connectors/ms-sql-connector/setting-up-ms-sql-connector.md).

# 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].