Microsoft SQL

Steps to prepare and connect to MS-SQL

Lightup account setup

Lightup needs 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. We recommend you use a role to provide sufficient privileges to the Lightup user.

Create a Lightup user

Run the following T-SQL, substituting in a password for the Lightup user.

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

Connector setting

  • Host Name - The hostname for the datasource (check the browser address bar; you want the string between // and /. Example:
  • Database Name - The name of the database you're connecting to.
  • Username - Enter lightup.
  • Password - The lightup account's password.

Schema scan frequency

You can adjust how often scans run for a datasource.

  • In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.

Query governance

Microsoft-SQL datasources support the Query history, Scheduling, Enable data storage, and Maximum backfill duration settings. For steps, see Set query governance settings for a datasource.