How to find the port for MS SQL Server 2008?

by

Click on Start button in Windows.

Go to All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager

Click on SQL Native Client 10.0 Configuration -> Client Protocols -> TCP/IP
double click ( Right click select Properties ) on TCP/IP.

You will find Default Port 1433.

Depending on connection, the port number may vary.

More Related Contents:

  1. Using merge..output to get mapping between source.id and target.id
  2. SQL Server, How to set auto increment after creating a table without data loss?
  3. How can I truncate a datetime in SQL Server?
  4. Using RegEx in SQL Server
  5. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  6. How to add Active Directory user group as login in SQL Server
  7. Why use the INCLUDE clause when creating an index?
  8. SqlServer: Login failed for user
  9. How to set a default value for an existing column
  10. An attempt was made to access a socket in a way forbidden by its access permissions
  11. SQL Server Query: Fast with Literal but Slow with Variable
  12. How do I find a stored procedure containing ?
  13. An attempt to login using SQL authentication failed
  14. SQL Server, the misleading XLOCK & optimizations
  15. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  16. How to find SQL Server running port?
  17. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  18. Changing SQL Server collation to case insensitive from case sensitive?
  19. Sort Bullets in Database
  20. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  21. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  22. Database design: Calculating the Account Balance
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. INFORMATION_SCHEMA vs sysobjects
  25. Merge multiple rows into a single row
  26. What are row, page and table locks? And when they are acquired?
  27. Error converting data types when importing from Excel to SQL Server 2008
  28. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  29. SQL Server 2008 Spatial: find a point in polygon
  30. Implementing one-to-zero-or-one relation in SQL Server

Leave a Comment