Mirroring in fabric

I've been trying to do this using an Azure Service Principle this morning. 
A couple of failures but once I adjusted the Db I wanted to mirror to use the appiropriate compute, got it working. 

The issues I had were on the source db side. 

Here's my script --> Hope it helps someone. 

/********************************************************************** 

* Steps to mirror a DB into Fabric using an Azure Service Principle * 

*    

* 

* create LOGIN [ <ServicePrincipleName> ] FROM EXTERNAL PROVIDER; 

* 

* ALTER SERVER ROLE [##MS_ServerStateReader##] ADD MEMBER [<ServicePrincipleName>]; 

*-------------------------------------------------------------------------------------- 

* 

* Now  switch to the db to be mirrored  

* 

* CREATE USER [<ServicePrincipleName>] FOR LOGIN [<ServicePrincipleName>]; 

* GRANT CONTROL TO [<ServicePrincipleName>]; 

* 

**************************************************************************/ 

The Nick

If the post helps please give a thumbs up || If it solves your issue, please accept it as the solution to help the other members find it more quickly.

If it's the biggest heap of stinky smelly stuff then I'm sorry .