How do you specify a different port number in SQL Management Studio?

sql-server sql-server-2005 ssms
Brettski picture Brettski · Sep 18, 2008 · Viewed 332.2k times · Source

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?

Answer

Nescio picture Nescio · Sep 18, 2008

127.0.0.1,6283

Add a comma between the ip and port

Related questions

How can I change my default database in SQL Server without using MS SQL Server Management Studio?

I dropped a database from SQL Server, however it turns out that my login was set to use the dropped database as its default. I can connect to SQL Server Management Studio by using the 'options' button in the connection …

Read More
Convert SSMS .rpt output file to .txt/.csv

I want to export my big SSMS (SQL Server Management Studio) query result (2.5m lines, 9 fields) as .csv or comma-delimited .txt (with headings). (MS SQL Server 2005 Management Studio.) So that I can then either read it line-by-line into VBA program (…

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More