Connect to Microsoft SQL

Steps to prepare and connect to MS-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.

Run the following T-SQL:

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.