I got stuck for about a day and half with this.

A client had a server with two instances of SQL installed – the default being SQL 2000 and the named instance being SQL2005. I needed to connect through SQL Management Studio remotely.

The default configuration was that the SQL2005 instance was using dynamic ports – no good to us as their firewall restrictions were particularly strict. Read the rest of this entry »