How to change the port in sql server management express (ssms)

I chased my tail around for awhile on this before finally coming across a post on google… those crazy folks at Microsoft decided that rather than using the standard IPAddress:port with a colon, they would use a comma instead! So… when you’re using SSMS to connect to a Sql Server on a non-standard port… this is the format:

IPAddress,port

Hope that saves someone else some time!

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Pownce
  • Technorati
  • TwitThis
  • De.lirio.us
  • E-mail this story to a friend!
  • Fark
  • LinkedIn
  • Slashdot
  • Socialogs
  • StumbleUpon

Leave a Reply

You must be logged in to post a comment.