I am just working on migrating a clients site from a third party provider over to our servers and I thought I could use SQL Management Studio and DTS to move the database. Should be easy right? connect to third party server, right click database, copy et voila! Not so, the other server is running on a non standard port, not the regular port 1433. So I thought well, I could connect with TCP/IP as per instructions and login. There isn’t anything in the Connection panel to allow you to specify a port. So I tried servername:portnumber but it didnt work.
Thankyou Google I found this article by Scott Strolz that indicated I should try servername,portnumber huh? OK – go figure it works like a charm. Why is it that Microsoft love to break conventions and standards?