I had the same problem when trying to configure mirroring.

Instead of using SQL commands I tried using the wizard under "MyDatabase" -> Tasks -> Mirroring and it worked.

That...