21 - 09 - 2019
Przełącznik języka
Tools
This Site
Security
CMS
Hardware
Backup
Uncategorised
useful sites
Databases
Emulators
Powershell
Storage Array
Active Directory
SEO
DNS
Guides
Antivirus program
Linux
Foto
Licznik
1.png6.png0.png3.png9.png7.png7.png
Today214
Yesterday651
This week4447
This month11842
Total1603977

Visitor Info

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

Who Is Online

2
Online

Saturday, 21 September 2019 09:20
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