Start the SQL Server Enterprise Manager. Expand your server, and look at Management--> Current activity --> Process Info. All current connections are listed. If you right click a connection, you can select Kill process to kill the process. Of course you need the proper privileges for this.