sqlserver-express

This repository contains the core SQL Server Express server.

Administrator login defaults for server:
Username: sa
Password: password1

Default Settings:
Port: 1433

This repository does not contain any tools for management, such as SQL Server Management Studio. If you need to manage the database, you may want to see sqlserver/ssms.

Getting started

Simple steps to get started:

# Run SQL Server on a clean computer
turbo run sqlserver/sqlserver-express

If you already have SQL Server installed, you will have to use a different port:

# Run SQL Server on a different port
turbo run sqlserver/sqlserver-express --route-add=8080:1433

If you are testing with SQL Server, you may want to run multiple instances at the same time:

# Run SQL Server with isolated tcp and udp protocols
turbo run sqlserver/sqlserver-express -d --route-block=tcp,udp -n=sql1

# Run a second SQL Server with isolated tcp and udp protocols
turbo run sqlserver/sqlserver-express -d --route-block=tcp,udp -n=sql2

# Run SSMS tools with a link to both containers
turbo run sqlserver/ssms --link=sql1:sqltest1 --link=sql2:sqltest2

# On the 'Connect to Server' window, enter sqltest1 or sqltest2 for Server name.