Introduction
Installing Microsoft SQL Server can be quite a challenging technical task, so we have created an easy scripted installation tool to help you install it as easily as possible.
Of course, if you have any doubts at all, we recommend contacting the Broadcast Radio Support Team for advice before you start.
We can also do the installation for you, especially if you are not fully comfortable with the level of technical expertise required. Please contact [email protected] to arrange a suitable time for us to do this for you.
Please note that the installation service may be chargeable depending on your support level and account status, please contact us for more details.
Which version should I choose
For new installations for Myriad v5 or v6 products we would recommend using Microsoft SQL Server 2022 Express by default. This is the latest version available from Microsoft and has been tested for compatibility with the the Broadcast Radio v5 and v6 family of software.
We also provide a SQL Server 2019 Express installer for users with exiting SQL server installs that would like to keep the same version across machines.
Procedure
Downloading the SQL Installation file
The first step is to download our your chosen version SQL Installer zip file. This contains all the files needed to install SQL as well as several scripts that will automatically install and configure it for you, even setting up automated backup and maintenance tasks. These are based on the scripts that we actually use ourselves when we preinstall SQL onto Broadcast Radio supplied PCs and servers.
Click here to download the SQL Server 2022 ZIP file
Click here to download the SQL Server 2019 ZIP file
Both are quite a large download, so may take a few minutes depending on your internet speed.
Once it has downloaded to your PC, click the option in your browser to go to the location that the zip file has been downloaded to:
Extracting the files from the downloaded file
Right click on this file and choose "Extract All... " :
Then when asked where to extract the contents to, please enter "C:\SQLInstallation" and click Extract. This will take a few moments.
Running the Installation Script
The folder should then open automatically, and you will see a file called "Install-SQL-2022.cmd" or "InstallSQL2019.cmd". Right click on this file and choose Run As administrator:
A command prompt window will open and after a few seconds it will ask you which drive letter you want to install SQL onto. We recommend using the largest available drive letter, and if possible this should be different from your main C: drive. For example, PC's supplied by Broadcast Radio have a "D:" drive that we use for all SQL and Myriad data files. Press the letter for the drive, and the automatic process will begin:
You will see several windows with progress bars on as Microsoft SQL Server and also Microsoft SQL Server Management Studio ("SSMS") is installed. If at any point you see any error messages, please don't click anything and contact our support team for assistance completing the installation.
Once the two main installers have completed, you will then be prompted twice for the password for the currently logged in Administrator. This password is used to add Scheduled Tasks that will automatically create backups of your databases every night and also perform some basic SQL database cleanup tasks each week:
Installation Finished!
At the end of the installer script, SQL Server is installed and ready to use, and you can the proceed to install and configure Myriad.
Alternative manual installation
An older help article is available that explains how to carry out a manual install of SQL Server. It was written for Microsoft SQL Server Express 2016 but the basic procedure is the same for Microsoft SQL Server Express 2019 and 2022.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article