---
title: "Microsoft SQL Server Connector"
slug: "microsoft-sql-server-connector"
description: "Use the Microsoft SQL Server connector in Lansweeper Flow Builder to query an MSSQL relational database from your automated workflows."
updated: 2026-07-17T15:46:01Z
published: 2026-06-12T15:00:39Z
canonical: "docs.lansweeper.com/microsoft-sql-server-connector"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lansweeper.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft SQL Server Connector

Note on third‑party tools

              

We aim to provide accurate and helpful details about third‑party tools, but we can’t guarantee that this information is always complete or up to date. If you notice any discrepancies, feel free to share them in the feedback section below. For the most reliable information, please always refer to the third‑party tool’s official documentation.

[Microsoft SQL Server](https://www.microsoft.com/en-us/sql-server) (MSSQL) is a popular relational database system. This component allows you to query an MSSQL database.

## Connections

### MS SQL Server Connection

Authenticate requests to a Microsoft SQL Server.

The MS SQL Server **username** and **password** can be put directly into a connection, alongside the database host, port, and database name.

| Input | Comments | Default |
| --- | --- | --- |
| Host | Provide a string value for the address that your database server is hosted on. |  |
| Port | Provide a string value of the port your database server is exposing. | 1433 |
| Database | Provide a string value for the name of the database. |  |
| Connection Timeout | The number of milliseconds before the attempt to connect is considered failed. | 15000 |
| Username |  |  |
| Password |  |  |

## Actions

### Execute Stored Procedure

Execute a stored procedure on a Microsoft SQL Server Database

| Input | Comments | Default |
| --- | --- | --- |
| Stored Procedure | The name of the stored procedure to execute. |  |
| Timeout | The number of milliseconds to wait for a response from the server. If the timeout expires before the server responds, an error will be thrown. | 60000 |
| Connection |  |  |

### Query

Interact with a Microsoft SQL Server Database

| Input | Comments | Default |
| --- | --- | --- |
| Query | Provide a string containing a query that will be executed by the Microsoft SQL-Server database. You can pass in optional named parameters using the '@variable' operator. | SELECT * FROM Customers WHERE customerId = @id |
| Parameters | Optional parameters to insert into a query. |  |
| Parameters Object | Optional parameters to insert into a query. This should be a key-value object. Values from this object will be merged with Parameters inputs. |  |
| Timeout | The number of milliseconds to wait for a response from the server. If the timeout expires before the server responds, an error will be thrown. | 60000 |
| Connection |  |  |