Below is a little document I made up after upgrading the Myriad Playout system at Hospital Radio Chelmsford (www.hrc.org.uk). It uses SQL Authentication as the method of linking to the database rather than windows authentication but this should not be a problem for station running less that 10 playout instances.

Hope you find it useful for your install.

Software Needed:-

SQL Server software (SQL 2008R2 Standard or Express recommended)
SQL Native Client software (needed for each workstation – 32bit version) sqlncli_x86.msi
Latest P Squared Full Release software i.e. Myriad Playout / Myriad Autotrack (along with relevant licensing details)

Optional:-

P Squared Bootstuff software to auto launch software on completion of set tasks i.e. server share available.
Firewall Exceptions batch file from P Squared Forum – http://forum.psquared.net/6688/SQL-Firewall-Exceptions

Prep:-

1 – Backup all of your ‘Myriad’ folder contents.

Installation:-

Server

1 – Run Windows Update to ensure server is up to date.
2 – Install SQL Server software
2.1 – Recommended practise is software installed on system (c:) drive and data directories location is set to D: drive i.e. d:\psquared\myriad.
2.2 – Create user in Management Studio with sysadmin and public rights
2.3 Run Windows update again to ensure SQL server software is up to date.

Autotrack Workstation (recommended to install Autotrack before Playout)

1 – Run Windows update to ensure machine is up to date.
2 – Install Native SQL Client software on machine
3 – Install Myriad Autotrack
4 – Connect to SQL server using SQL Authenication with user details you created on server (this allows anyone to log onto windows on the machine and it not affect the access to the Database).
5 – Once Autotrack is installed and licensed go to File – Import/Upgrade Database and choose your Autotrack Database found in the ‘Autotrck’ folder on your server. This upgrade can take some time and your system will look like it is not responding but just leave it alone!
6 – Run the user importer tool to import your current v3 users.
7 – Run the application and ensure it loads correctly and click on ‘allow’ to any firewall requests. 8 – Run the firewall exceptions batch file on workstation.

Playout Workstation

1 – Run Windows update to ensure machine is up to date.
2 – Install Native SQL Client software on machine
3 – Install Myriad Playout 4 – Connect to SQL server using SQL Authenication with user details you created on server (this allows anyone to log onto windows on the machine and it not affect the access to the Database).
4 – Run the application and ensure it loads correctly and click on ‘allow’ to any firewall requests. 5 – Run the firewall exceptions batch file on workstation.

Gotchas

1 – When entering the server details do not leave anything of the pre-existing text before /SQLExpress. If your server is on a domain you may need to enter the whole domain string rather than just server\SQLEXPRESS.

2 – Don’t forget to install the Native Client software else things just won’t work.