> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/7.6/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/7.6/data-center/data-connectors/supported-data-connectors/database-connectors/mssql.md).

# MSSQL

Provide the following information to create an MSSQL Data Connector.<br>

![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FpEBCFBbbo0M3oMFLQzbd%2Fimage.png?alt=media\&token=8d573d2f-a6c7-4dd3-a51a-67e103f7d0bc)

* **Data Connector Name**: Provide a user-defined name to identify the data connector.
* **Description**: Provide connection details (Optional)
* **Username:** Enter a Username (It should be the same as given in the connection server).
* **Password**: Enter the Password (It should be the same as provided in the connection server).
* **IP/Host:** Enter database server details (from where the user wants to fetch data).
* **Port:** Provide the server port number.
* **Database Name:** Name of the database where you wish to store data.
* Click the **‘Save’** option.

![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FmbfG4z28BBY5kyXs462J%2Fimage.png?alt=media\&token=0e6bf164-9529-4fb2-becb-2ce136ce528c)

* A success message appears to confirm the connection.

![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FDcQbVdZTJmqrNuhqvLyt%2Fimage.png?alt=media\&token=737691a3-81db-4d59-9b63-c856bde036aa)

* Another success message appears to assure the creation of the new MSSQL Data Connector
* The newly created MSSQL data connector gets added to the Data Connectors list.

![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FHncPFrebDgeExtdq1lSI%2Fimage.png?alt=media\&token=acb03d42-839b-4236-84d2-0935826272fb)

![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FKSf2TyjZUvlemGgGLd28%2Fimage.png?alt=media\&token=28764cd6-12a9-48ef-884f-8bc1b7cf023f)

Note: The user can use the following Environment Variables instead of the actual Username and Password to create the MSSQL Data Connectors.

* Username: @ENV.MSSQLUSERNAME
* Password: @ENV.MSSQLPASSWORD