• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The Electric Toolbox Blog

The Electric Toolbox Blog

Linux, Apache, Nginx, MySQL, Javascript and PHP articles

  • Applications
  • FCKEditor
  • Apache
  • Windows
  • Contact Us
Home / Connect to a different port with SQL Server Management Studio

Connect to a different port with SQL Server Management Studio

Microsoft’s SQL Server Management Studio will connect by default to port 1433 and there’s nowhere in the connect dialog to specify a different port from the default. To connect using a different port specify the servername, a comma, and then the port number as shown in this post.

Connect using a different port using a comma

The connection dialog in the SQL Server Management Studio client is shown in the screenshot below. Normally you would just type the server name into field but to specify a different port use a comma then the port number.

The example screenshot above shows “dbname” as the database name and “port” where the port would be. If you wanted to connect to a server named e.g. sqlserver.electrictoolbox.com on port 10443 then set the server name to:

sqlserver.electrictoolbox.com,10443

Then specify the login credentials, click the connect button, and assuming everything is correct it should then connect to the SQL Server.

Check Out These Related posts:

  1. Creating an SSH port tunnel with PuTTY
  2. How to tunnel port 25 with SSH
  3. VMWare Server Console Connection Refused
  4. The user is not associated with a trusted SQL Server connection

Filed Under: Microsoft SQL Server

Primary Sidebar

Categories

  • Apache
  • Applications
  • Article
  • Case Studies
  • Email Servers
  • FCKEditor
  • HTML And CSS
  • Javascript
  • Linux/Unix/BSD
  • Microsoft SQL Server
  • Miscellaneous Postings
  • MySql
  • Networking
  • Nginx Web Server
  • Offsite Articles
  • OSX
  • PHP
  • Quick Tips
  • RFC – Request for Comments
  • SilverStripe
  • VMWare
  • VPN
  • Windows
  • WordPress

Recent Posts

  • Vim Show Line Numbers
  • Add User To Group Linux
  • Chmod 777 Tutorial
  • How to Copy Directory Linux
  • Linux create user

Copyright © 2021. ElectricToolBox. All Rights Reserved.

  • Contact Us
  • Copyright Info
  • Privacy Policy
  • Sitemap