INFORMATICS

The Best

Przełącznik języka

BUY COFFEE

If you like the website and want to support the project!

Postaw mi kawę na buycoffee.to

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Uncategorised

useful sites

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

DNS

Antivirus program

Linux

Foto

Licznik

3.png0.png4.png1.png7.png5.png9.png
Today656
Yesterday1207
This week6641
This month16660
Total3041759

Visitor Info

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

Who Is Online

5
Online
Friday, 22 November 2024 11:36
You are here: Home MS SQL How do you specify a different port number in SQL Management Studio

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

Search