APP-V with database mirrored

[HMCTech]

I have set up a database mirror with the APP-V database and it all seems to work well to a point, the databases failover well enough. The management server will continue to connect to the database when I failover the database.

 

The clients however will only work when the database is on the primary. I have followed all the guides to add the registry setting which adds the failover database. I can't figure out what is going wrong as the clients are pointing at the management server, the management server has the primary SQL box as the primary database with the two registry entries for SQLFailoverServerName and SQLFailoverServerPort which have the failover SQL boxes. But the clients just dont work and I cant figure out why. If anyone else has this working do you have any tips?

[HMCTech]

Missed out setting the SPN