Connect SQL Server Management Studio Express To Alternate TCP Port

Want to help support this blog? Try out Oh Dear, the best all-in-one monitoring tool for your entire website, co-founded by me (the guy that wrote this blogpost). Start with a 10-day trial, no strings attached.

We offer uptime monitoring, SSL checks, broken links checking, performance & cronjob monitoring, branded status pages & so much more. Try us out today!

Profile image of Mattias Geniar

Mattias Geniar, March 11, 2009

Follow me on Twitter as @mattiasgeniar

Since I didn’t find it right away, here’s the solution. The default notation “server:port” doesn’t work here (for God knows what reason). You need to seperate the hostname and port with a comma. Here’s an example.

 

SQL Server Alternate Port

SQL Server Alternate Port

What ever happened to the default point seperation? :-(



Want to subscribe to the cron.weekly newsletter?

I write a weekly-ish newsletter on Linux, open source & webdevelopment called cron.weekly.

It features the latest news, guides & tutorials and new open source projects. You can sign up via email below.

No spam. Just some good, practical Linux & open source content.