Przełącznik języka

This Site

CMS

Hardware

Uncategorised

useful sites

Databases

Emulators

Powershell

Storage Array

DNS

Antivirus program

Licznik

1.png6.png3.png7.png6.png1.png4.png
Today746
Yesterday769
This week3544
This month8300
Total1637614

Visitor Info

  • IP: 100.25.43.188
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

6
Online

Thursday, 14 November 2019 17:55

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

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 
How do you specify a different port number in SQL Management Studio 

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

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

to connect to sql, enter the server address and then enter the port number after the comma    SQLSERVER\InstanceName,portnumber   -    SQL\InstSQL, 1025

look for sql server processes and find port

netstat -a -b