Documentation / SQL Server XRAY / Getting Started

Getting Started — SQL Server XRAY

First scan: connect → pick a Baseline / Best Practices profile → run against a non-prod instance → open Findings sorted by Critical → fix the top items → re-scan to confirm green.

Getting Started

  1. Download DBLenseSQLServerXRAY-*.exe from dblense.com/download.html (sign in required) and run it. No installer is required.
  2. On first launch, a 14-day full-feature trial starts automatically. Enter a license key anytime from Settings → License.
  3. Create a connection profile with server name, authentication, and optional database.
  4. Click Detect Platform, then run a Quick Health or Full Scan profile.
  5. Review the dashboard, open Detailed Findings, and export or email a report.

Trial & Licensing

  • 14-day trial includes all features — no credit card required.
  • After the trial expires, activate a paid or Suite key to continue.
  • Each individual key activates on one machine.
  • Suite keys unlock QueryStore Analyzer, Script Runner, Log Reader, and SQL Server XRAY.
  • Manage activation from Settings → License, or buy/renew at and My Account.
  • License cache lives under %LOCALAPPDATA%\DBLenseSQLServerXRAY\.

Connections & Authentication

Connection profiles store server details and credentials for reusable scans.

FieldDescription
Server NameInstance name, FQDN, or Azure endpoint
DatabaseOptional target database (instance scans often use master)
AuthenticationWindows Auth, SQL Login, or Microsoft Entra ID
Trust Server CertificateUseful for lab/self-signed TLS scenarios

Passwords are encrypted with Windows DPAPI and stored only for the same Windows user on the same machine. Profile file: %LOCALAPPDATA%\DBLenseSQLServerXRAY\profiles.json.

XRAY detects the platform (on-premises, Azure SQL MI, Azure SQL Database) and suppresses checks that do not apply.

Optional: Worker Service (unattended schedules)

The desktop app is enough for interactive scans. Download the worker only if schedules should keep running when nobody is logged into the UI.

Download Worker 1.0.0

  1. Install and configure the desktop app first. Create connection profiles and enable at least one schedule.
  2. In XRAY Settings, set scheduler ownership to Worker Service.
  3. Download DBLenseSQLServerXRAY.Worker-1.0.0.zip and extract it to a permanent folder (for example C:\Program Files\DBLense\SQLServerXRAY.Worker).
  4. Right-click Install-WorkerService.exe and choose Run as administrator.
  5. Confirm Windows service DBLenseSQLServerXRAY is running. Logs: %ProgramData%\DBLenseSQLServerXRAY\logs.

To remove the worker, run Uninstall-WorkerService.cmd as administrator. This package is not listed on the main Downloads page.