A Windows Server 2008 R2 VM with SQL Server Express 2008 R2 SP2 powered by Vagrant.
:warning: Heads up! :warning:
This was just an experiment on how to set things up for a project I worked on the past, I’m not planning to keep this project up to date with latest Vagrant / SQL Server updates or making additional improvements to it.
- Vagrant 1.6+ (tested on 1.6.3)
- VirtualBox 4.3+ (tested on 4.3.16 on an Ubuntu host)
12GBof disk space (
3GBfor base box +
~9GBfor the VM)
Base box information
- Configured with 2 CPU and 2 GB memory by default.
- No updates or services packs applied
- The box is not activated. It has been created for testing and evaluation purposes only. Use of this machine for greater than 30 days will require a full license either via MSDN or your local Microsoft Reseller.
- The box has been created with packer.io using the templates made available here.
More information can be found on the box page at Vagrant Cloud.
git clone https://github.com/fgrehm/vagrant-mssql-express.git cd vagrant-mssql-express # Download SQL Server with Tools installer wget http://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPRWT_x64_ENU.exe vagrant up # Get a coffee as it will take a while for it to finish provisioning
Then test the connection with the SQL Server using
telnet 192.168.50.4 1433
Connecting to the SQL Server instance that runs inside the VM
- IP / Host:
If you are using Rails, apart from installing tiny_tds
brew install freetds /
apt-get install freetds-* and
the activerecord-sqlserver-adapter gem,
this is what you’ll have on your
development: adapter: sqlserver database: <YOUR DB> host: 192.168.50.4 username: sa password: '#SAPassword!'
Connecting to the VM using Remote Desktop connections
If you need to perform administrative tasks like importing a DB dump or creating
new databases, you can use the
vagrant rdp command
and log in with the
vagrant user and password.
vagrant rdp command to work on Ubuntu, you’ll need to
apt-get install rdesktop
first. On Macs, you will need Microsoft Remote Desktop from the Mac App Store.
If you want to know more about how the provisioning process work, check out this blog post
This project was made possible thanks to HE:labs
Here’s some links I collected along the way while building this: