---
description: Steps to prepare and connect to MS-SQL
---

# Connect to Microsoft SQL

## Lightup account setup: MS-SQL

You'll need a user account that can query data and metadata for all tables you want to monitor. You might already have a user set up that will work, or you might need to create one.&#x20;

Run the following T-SQL:&#x20;

```
CREATE LOGIN lightup WITH PASSWORD = '********';
GO
CREATE USER lightup FOR LOGIN lightup;
GO 
CREATE ROLE lightup_role;
GO
GRANT SELECT ON SCHEMA :: [SELECT SCHEMA_NAME(schema_id) AS schema_name FROM sys.objects]  TO lightup_role;
GO
GRANT ROLE lightup_role TO lightup;
GO
```

## Connector settings

* **Host Name** - The hostname for the datasource (check the browser address bar; you want the string between **//** and **/**. Example: `https://`**`host.na.me`**`/`
* **Database Name** - The name of the database you're connecting to.
* **Username** - Enter _**lightup**_.
* **Password** - The lightup account's password.&#x20;
