Skip to content

Instantly share code, notes, and snippets.

@npotier

npotier/provision-sqlserver.ps1

Last active August 29, 2015 14:05
Show Gist options
  • Save npotier/d24fc138da7ce233b1da to your computer and use it in GitHub Desktop.
Save npotier/d24fc138da7ce233b1da to your computer and use it in GitHub Desktop.
Download ZIP
PowerShell Install SQL Server
Raw
provision-sqlserver.ps1
iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))
choco install MsSqlServer2012ExpressAdv -force
sqlcmd -S VAGRANT-2012-R2 -E -Q "CREATE DATABASE {{YOUR_DATABASE_NAME}};"
sqlcmd -S VAGRANT-2012-R2 -E -Q "USE {{YOUR_DATABASE_NAME}};CREATE LOGIN {{YOUR_DATABASE_USER}} WITH PASSWORD = '{{YOUR_DATABASE_PASSWORD}}'"
sqlcmd -S VAGRANT-2012-R2 -E -Q "USE {{YOUR_DATABASE_NAME}};CREATE USE {{YOUR_DATABASE_USER}} FOR LOGIN {{YOUR_DATABASE_USER}};"
sqlcmd -S VAGRANT-2012-R2 -E -Q "USE {{YOUR_DATABASE_NAME}};GRANT ALTER To {{YOUR_DATABASE_NAME}};"
sqlcmd -S VAGRANT-2012-R2 -E -Q "USE {{YOUR_DATABASE_NAME}};GRANT CONTROL To {{YOUR_DATABASE_NAME}};"
sqlcmd -S VAGRANT-2012-R2 -E -Q "USE {{YOUR_DATABASE_NAME}};EXEC sp_addrolemember 'db_owner', '{{YOUR_DATABASE_USER}}'"
sqlcmd -S VAGRANT-2012-R2 -E -Q "USE {{YOUR_DATABASE_NAME}};EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment