Vagrant SQL Server 2017 on Ubuntu Linux
Vagrant configuration to provide users with virtual environment for hassle-free fun with SQL Server 2017.
Looking for SQL Server 2017 on Windows VM? Check https://github.com/mloskot/vagrant-sqlserver-windows
Looking for SQL Server on Windows VM? Check https://github.com/msabramo/vagrant_sql_server_express
Features
- Ubuntu 16.04
- SQL Server 2017 on Linux (official packages by Microsoft)
- SQL Server command-line tools on Linux
- Pre-configured with
- Vagrant default user:
vagrant
with passwordvagrant
- Port forwarding from host
2433
to guest1433
(default). - Database user
sa
with passwordPassword123
. - Database
master
. - Set SQL Server edition to
Developer
withMSSQL_PID="Developer
. - Other of configuration Environment variable set to default.
- Vagrant default user:
Requirements
- VirtualBox installed.
- Vagrant installed.
Installation
git clone
this repository or download ZIP.cd vagrant-sqlserver
- Follow the Usage section.
Usage
Vagrant VM
-
vagrant up
to create and boot the guest virtual machine. First time run, this may take quite a while as the base box image is downloaded and provisioned, packages installed. -
vagrant ssh
to get direct access to the guest shell via SSH. You'll be connected as the vagrant user. You can get root access withsudo
command. -
vagrant halt
to shutdown the guest machine. -
vagrant destroy
to wipe out the guest machine completely. You can re-create it and start over withvagrant up
.
SQL Server
Using sqlcmd:
- Connect to SQL Server instance from inside the guest VM
vagrant ssh
sqlcmd -S localhost -U SA -P 'Password123' -Q "SELECT @@version;"
sqlcmd -S localhost -U SA -P 'Password123' -Q "SELECT name FROM sys.databases;"
- Connect to SQL Server instance from host
sqlcmd -S localhost,2433 -U SA -P 'Password123' -Q "SELECT name FROM sys.databases;"