[sql-server] How do you specify a different port number in SQL Management Studio?

I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a different port number when connecting to the server using SQL Management Studio?

This question is related to sql-server sql-server-2005 ssms

The answer is,6283

Add a comma between the ip and port

If you're connecting to a named instance and UDP is not available when connecting to it, then you may need to specify the protocol as well.

Example: tcp:\SQL2K5,1443

Another way is to setup an alias in Config Manager. Then simply type that alias name when you want to connect. This makes it much easier and is more prefereable when you have to manage several servers/instances and/or servers on multiple ports and/or multiple protocols. Give them friendly names and it becomes much easier to remember them.

You'll need the SQL Server Configuration Manager. Go to Sql Native Client Configuration, Select Client Protocols, Right Click on TCP/IP and set your default port there.

Using the client manager affects all connections or sets a client machine specific alias.

Use the comma as above: this can be used in an app.config too

It's probably needed if you have firewalls between you and the server too...

On Windows plattform with server execute command:

netstat -a -b

look for sql server processes and find port f.e 49198

Or easier. Connect with dbvisualizer, run netstat -a -b find dbvis.exe process and get port.

Questions with sql-server tag:

Passing multiple values for same variable in stored procedure SQL permissions for roles Count the Number of Tables in a SQL Server Database Visual Studio 2017 does not have Business Intelligence Integration Services/Projects ALTER TABLE DROP COLUMN failed because one or more objects access this column Create Local SQL Server database How to create temp table using Create statement in SQL Server? SQL Query Where Date = Today Minus 7 Days How do I pass a list as a parameter in a stored procedure? SQL Server date format yyyymmdd SQL Server IF EXISTS THEN 1 ELSE 2 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) How to add a boolean datatype column to an existing table in sql? How to import an Excel file into SQL Server? How to use the COLLATE in a JOIN in SQL Server? Change Date Format(DD/MM/YYYY) in SQL SELECT Statement Stored procedure with default parameters Drop view if exists Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object How to update large table with millions of rows in SQL Server? Could not find server 'server name' in sys.servers. SQL Server 2014 How to create a Date in SQL Server given the Day, Month and Year as Integers Select Rows with id having even number A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233) SQL Server: Error converting data type nvarchar to numeric How to add LocalDB to Visual Studio 2015 Community's SQL Server Object Explorer? Using DISTINCT along with GROUP BY in SQL Server Rebuild all indexes in a Database How to generate Entity Relationship (ER) Diagram of a database using Microsoft SQL Server Management Studio? The target principal name is incorrect. Cannot generate SSPI context How Stuff and 'For Xml Path' work in SQL Server? How to view the roles and permissions granted to any database user in Azure SQL server instance? How do I create a local database inside of Microsoft SQL Server 2014? Format number as percent in MS SQL Server MSSQL Regular expression How to select all the columns of a table except one column? SQL count rows in a table EXEC sp_executesql with multiple parameters SQL Server : How to test if a string has only digit characters Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query Remove decimal values using SQL query How to drop all tables from a database with one SQL query? How to get last 7 days data from current datetime to last 7 days in sql server Get last 30 day records from today date in SQL Server Using Excel VBA to run SQL query No process is on the other end of the pipe (SQL Server 2012) How to subtract 30 days from the current date using SQL Server Calculate time difference in minutes in SQL Server How to join two tables by multiple columns in SQL? The database cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported

Questions with sql-server-2005 tag:

Add a row number to result set of a SQL query SQL Server : Transpose rows to columns Select info from table where row has max date How to query for Xml values and attributes from table in SQL Server? How to restore SQL Server 2014 backup in SQL Server 2008 SQL Server 2005 Using CHARINDEX() To split a string Is it necessary to use # for creating temp tables in SQL server? SQL Query to find the last day of the month JDBC connection to MSSQL server in windows authentication mode How to convert the system date format to dd/mm/yy in SQL Server 2008 R2? How to rollback or commit a transaction in SQL Server Is the LIKE operator case-sensitive with MSSQL Server? How to query values from xml nodes? SQL Server Pivot Table with multiple column aggregates SQL Server stored procedure creating temp table and inserting value Drop primary key using script in SQL Server database How to install SQL Server 2005 Express in Windows 8 How to use the divide function in the query? Alter a SQL server function to accept new optional parameter Get the list of stored procedures created and / or modified on a particular date? SQL Server 100% CPU Utilization - One database shows high CPU usage than others How do check if a parameter is empty or null in Sql Server stored procedure in IF statement? "Prevent saving changes that require the table to be re-created" negative effects How do I get row id of a row in sql server Measure the time it takes to execute a t-sql query How to Convert Datetime to Date in dd/MM/yyyy format Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio How to get calendar Quarter from a date in TSQL What is the maximum characters for the NVARCHAR(MAX)? How do I fetch multiple columns for use in a cursor loop? How to find sum of multiple columns in a table in SQL Server 2005? How to upsert (update or insert) in SQL Server 2005 Export table data from one SQL Server to another How do I use an INSERT statement's OUTPUT clause to get the identity value? SQL Server Error : String or binary data would be truncated Date / Timestamp to record when a record was added to the table? Received an invalid column length from the bcp client for colid 6 SQL query, store result of SELECT in local variable How to parse string into date? SQL Server ON DELETE Trigger How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'? Convert NULL to empty string - Conversion failed when converting from a character string to uniqueidentifier Find duplicate records in a table using SQL Server How to combine GROUP BY and ROW_NUMBER? List rows after specific date How to compare two dates to find time difference in SQL Server 2005, date manipulation how to increment integer Columns value by 1 in SQL Real life example, when to use OUTER / CROSS APPLY in SQL Calling stored procedure from another stored procedure SQL Server Rounding SQL DateTime to midnight

Questions with ssms tag:

The backend version is not supported to design database diagrams or tables How to export all data from table to an insertable sql format? Insert Data Into Temp Table with Query Incorrect syntax near '' How to find server name of SQL Server Management Studio Recover unsaved SQL query scripts SQL query, if value is null then return 1 How to connect to LocalDb How do you view ALL text from an ntext or nvarchar(max) in SSMS? How to install SQL Server Management Studio 2012 (SSMS) Express? Saving results with headers in Sql Server Management Studio Where is SQL Server Management Studio 2012? How do I grant myself admin access to a local SQL Server instance? How to view the stored procedure code in SQL Server Management Studio How to drop all tables in a SQL Server database? SQL Server Management Studio, how to get execution time down to milliseconds Why can't I find SQL Server Management Studio after installation? Sql Server 'Saving changes is not permitted' error ? Prevent saving changes that require table re-creation How do I grant read access for a user to a database in SQL Server? SQL Server Management Studio missing How to see query history in SQL Server Management Studio How can I generate an INSERT script for an existing SQL Server table that includes all stored rows? ALTER DATABASE failed because a lock could not be placed on database How to edit data in result grid in SQL Server Management Studio Converting Select results into Insert script - SQL Server SQL Server: Importing database from .mdf? SQL Server 2008: how do I grant privileges to a username? Find stored procedure by name mssql '5 (Access is denied.)' error during restoring database Unique constraint on multiple columns Auto-increment primary key in SQL tables How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio? SQL Server copy all rows from one table into another i.e duplicate table How do I view executed queries within SQL Server Management Studio? Restrict varchar() column to specific values? What is the use of GO in SQL Server Management Studio & Transact SQL? How to alter SQL in "Edit Top 200 Rows" in SSMS 2008 Saving changes after table edit in SQL Server Management Studio How to see the values of a table variable at debug time in T-SQL? How to edit one specific row in Microsoft SQL Server Management Studio 2008? SQL Server 2008 can't login with newly created user The request failed or the service did not respond in a timely fashion? How do I make a composite key with SQL Server Management Studio? How to quickly edit values in table in SQL Server Management Studio? How do I create a SQL table under a different schema? sql server invalid object name - but tables are listed in SSMS tables list Changing the CommandTimeout in SQL Management studio Import / Export database with SQL Server Server Management Studio How to remove "Server name" items from history of SQL Server Management Studio How to type a new line character in SQL Server Management Studio