Date: Thu, 28 Mar 2024 11:27:51 +0000 (GMT) Message-ID: <1603040861.397.1711625271726@ip-172-31-38-4.eu-west-1.compute.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_396_1352789725.1711625271702" ------=_Part_396_1352789725.1711625271702 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
As mentioned in this article on Continuous Integration, we recommend that you use = a local instance of SQL Server with gated deployment. This ensures that the= re are no collisions between build agents (i.e. if you are running multiple= simultaneous builds on different build agents).
Installing SQL Server can be quite a long and tedious task, so inst= ead of doing this manually, an alternative is to use Chocolatey. = The package that is available from Chocolatey is pre-configured with a set = of common default settings.
To install SQL Server 2012 Express Edition using Chocolatey, open a command prompt in administrator mode and = run the following (not that this will also retrieve Chocolatey if you don't= already have it installed):
@powers= hell -NoProfile -ExecutionPolicy unrestricted -Command "iex ((new-object ne= t.webclient).DownloadString('http://chocolatey.org/install.ps1'))" &&am= p; SET PATH=3D%PATH%;%systemdrive%\chocolatey\bin CALL cinst MsSqlServer2012Express @ECHO Adding [BUILTIN\Users] to sysadmin role on local SQL instance "%ProgramFiles%\Microsoft SQL Server\110\Tools\Binn\sqlcmd.exe" -S . -E -Q = "ALTER SERVER ROLE [sysadmin] ADD MEMBER [BUILTIN\Users];"
These commands will take a while to run, but you shouldn't have to = intervene or confirm any dialog boxes, and a restart should not be required= .
Microsoft Licensing Terms
ALTER SERVER ROLE
=