# Microsoft SQL server

MSSQL connectors are used to connect a Microsoft SQL server reports.

Connection string: The connection string to your SQL Database.

Connector Server Aliases: Used to fully inform NodeGraph of the different ways of referring to the data source.

Test: Performs a control of the connection string and verifies the ability to connect to SQL.

[](https://help.qlik.com/en-US/nodegraph/Content/NodeGraph/Documentation/Using_NodeGraph/NodeGraph_Connectors/Microsoft_SQL_server.htm)

#### Full list of connector fields

Add a MSSQL connector

| Field | Default Input |
| --- | --- |
| SYSTEM ID | Id |
| SYSTEM NAME | Name |
| DESCRIPTION | Description (optional) |
| CONNECTOR TAGS | Tag1; Tag2; ... |
| CONNECTION STRING | data source=localhost; initial catalog =AdventureWorks;Integrated Security=SSPI; |
| SERVER NAME | mssql01-prod |
| FULLY QUALIFIED DOMAIN NAME | mssql01-prod.company.com |
| IP | 123.456.789.123 |
| DNS NAME | mssql01-prod.company.com;mssql02-prod.company.com; |