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

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2FWo0ewHGXxS3Nrz8QQAHb%2FConnectorMenu.png?alt=media\&token=2464a818-a021-466a-86d0-c0f95fc19371)

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

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2F4DE8bjtezh4TdF4vjRSE%2FAddConnector.png?alt=media\&token=dd6d0795-b53b-475b-896b-20611fe749bf)

* The Details tab is preselected.

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2FKuJvmPhbf9MYiku4nT2G%2FDetailsTab.png?alt=media\&token=17a60e44-b477-41a9-9c60-cb52950c2de2)

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

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2FFmHKY4ZOLhRyi8wy9xk4%2FMSSQLconn_Name.png?alt=media\&token=2b83db62-70e1-4c97-b7ed-24994ca41fce)

* Add a description, optionally. 

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2FVi5Xl7LsBNWazqgY4KGC%2FMSSQLconn_Desc.png?alt=media\&token=3ec7080e-9840-49e4-9163-4c8bd9fe4ad9)

* Select “MsSQL” from the list of values.

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2FSNcB1YlvbqYC1kBHleb3%2FMSSQL_selected.png?alt=media\&token=bfc038c3-bcac-4146-9664-bddaabbb9490)

* 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.

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2FLWUgAS0qvCWnENEOyf48%2FMSSQLHostDetails.png?alt=media\&token=9481fba9-5e1e-417a-87da-a7b9ed079009)

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

![](https://2351945889-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVoxOh7gdjWdmqooFdYBY%2Fuploads%2FFmzlB7AQy3ojHdjYli1Y%2FSaveMSSQLHostDetails.png?alt=media\&token=abc3f414-a37a-48bc-84b1-05b4748134eb)

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