Microsoft SQL Server is a powerful relational database management system (RDBMS) with amazing development and management tools. It comes in multiple editions fitting a wide range of requirements. SQL Server Express is the free edition, but don’t let the name fool you: it includes most of the tools available in other editions and unless you have large workloads and scalability requirements it fits the bill very well.
This charm is also freely available!
juju deploy cs:~cloudbaseit/win2012r2/mssql-express
version – Choose the SQL Server Express version to be deployed. Supported versions: 2012, 2014. The installer specific to the version is downloaded from the Internet, checked for integrity with SHA1 checksum and then installed.
sa-password – Password used by the System Administrator special login.
installer-url – If provided, it overrides the default download url for the MSSQL installer. This should be provided, for example, when the MSSQL installer is found somewhere on a local web server.
sha1-checksum – Corresponds to the installer provided by the download url set by the user.
NOTE: Version, installer-url and sha1-checksum won’t change anything in the charm if dynamically changed. This values are used only in the install hook, when service is installed.
SA password can be dynamically changed by:
juju set mssql-express sa-password=Password123
NOTE: sa-password must respect the minimum complexity policy enforced by Microsoft. More details on this page at the section Password Complexity.
|sa-password||Password used by the SA login. System administrator (SA) is a special login assigned to the ‘sysadmin’ fixed server role and cannot be changed.||string||Passw0rd|
|version||Microsoft SQL Server Express version to be installed by the charm. The installer specific to this version is downloaded and installed unless “installer-url” config option is specified. Supported versions are: 2012, 2014.||int||2014|
|sha1-checksum||SHA1 checksum for the MSSQL installer provided in the “installer-url” config option. It is used to check the file integrity after it is downloaded.||string|
|installer-url||This option overrides the default value for download link when selecting MSSQL version. If provided, this value will be used regardless of selected version of MSSQL in the “version” config option.||string|
Please fill out the form below for pricing information and for a free trial: