Skip to main content

MSSQL Database Connector

MSSQL (Microsoft SQL Server) is a relational database management system developed by Microsoft, designed to store and retrieve data for various applications. It supports a wide range of data types, transactions, and analytics, making it suitable for enterprise-level database needs.

info

For the common steps on adding connectors in Unstract, see Working with Connectors.

Getting started with MSSQL

  1. Sign up or Sign in for an Azure account.

  2. Search for SQL Databases in the global search and click on the search result and click on create.

    img mssql create project img mssql create project

  3. Now click on create new button below server field to create a new database server.

    img mssql create project

  4. Enter the Server Name, Location, and choose the SQL authentication as login type and finish the form.

    img mssql create project

  5. Now choose the Database Name and choose Environment as Production and submit it. For more customization click on next pages before submitting.

    img mssql create project

  6. Wait for the database to get deployed.

Adding MSSQL Connector in Unstract

When configuring the MSSQL connector, you'll need to provide the following connection details:

Required Configuration Fields

  • Name of the connector: Enter a descriptive name for your MSSQL connector
  • Server: Enter your MSSQL server hostname or IP address (for Azure SQL Database, use the format server-name.database.windows.net)
  • Port: The port number (default is 1433 for MSSQL)
  • Database: The name of the database you want to connect to
  • User: Your database username
  • Password: Your database password

MSSQL Connector Configuration

Need a hand?

Talk to us on Slack! We're here to help :)