> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/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/bdb-documentation/data-center/data-connectors/supported-data-connectors/database-connectors/mssql.md).

# MSSQL

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

![](/files/Jq8r4WXCauwF7MX70BG2)

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

![](/files/futfol1qAQHIiwlYTsZz)

* A success message appears to confirm the connection.

![](/files/MToN8gkpy95Bpi3F4vFy)

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

![](/files/EwoLJyfW3JwOOMXP9KrO)

![](/files/bweF5ftrCHd9mEjvpgQS)

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