SEC.01

The playbook

The run starts read-only: the recon probes decide what happens next. The steps that follow are adapted to the distribution and state found — a real machine is rarely clean.

1. 01recondoes a SQL Server instance already exist? (MSSQLSERVER = default, MSSQL$SQLEXPRESS = Express)
2. 02reconWindows edition and build (ProductType 1 = workstation, 2 = DC, 3 = server), RAM
3. 03reconavailable package managers: winget (real path, often off PATH under SYSTEM), choco, and the account running commands
4. 04recon≥ 6 GB free and ≥ 4 GB RAM; port 1433 already taken?
5. 05actInstall SQL Server ${edition}verify
6. 06actGrant sysadmin to local Administratorsverify
7. 07actCheck the connectionverify

SEC.02

What it verifies

Each step ships its own check. The run only moves on when the check passes, so what the recipe reports as done is what is actually on the server.

1. 01verifyInstall SQL Server ${edition}Verified byGet-Service -Name 'MSSQLSERVER','MSSQL$SQLEXPRESS' -ErrorAction SilentlyContinue | Select-Object Name,Status
2. 02verifyGrant sysadmin to local AdministratorsVerified by$g = (New-Object Security.Principal.SecurityIdentifier 'S-1-5-32-544').Translate([Security.Principal.NTAccount]).Value; $c = New-Object System.Data.SqlClient.SqlConnection 'Server=localhost;Integrated Security=True'; $c.Open(); $q = $c.CreateCommand(); $q.CommandText = "SELECT IS_SRVROLEMEMBER('sysadmin', N'$g')"; $q.ExecuteScalar(); $c.Close()
3. 03verifyCheck the connectionVerified by$c = New-Object System.Data.SqlClient.SqlConnection 'Server=localhost;Integrated Security=True'; $c.Open(); $c.ServerVersion; $c.Close()

SEC.03

Guardrails

Non-negotiable instructions the run must respect, whatever it finds on the server.

SEC.04

Variables

What you choose before launching — the recipe fills in the rest.

SEC.05

How a recipe runs in Servor

Servor is zero-knowledge: the platform cannot execute anything on its own. When you launch this recipe, a run reads the reconnaissance, plans the steps and asks for your approval. Each approved command is signed by your browser — with a key the server never sees — then relayed verbatim to the agent, which verifies the signature locally before executing.

SEC.06

Deploy on Servor button

Maintain SQL Server or a project that needs it? Put this button in your README or on your site: one click and your users install it on their own server.

SEC.07

More database recipes

1. 01PostgreSQLPostgreSQL (major version of your choice) from the official PGDG repository, initialized and verified.
2. 02MySQLMySQL Server, secured, bound to localhost, started and verified.
3. 03MariaDBMariaDB, secured, bound to localhost, started and verified.
4. 04MongoDBMongoDB Community 9.0, local, with authentication enabled and verified.
5. 05RabbitMQRabbitMQ broker (official repository) with management, local and a dedicated admin account.