How to find SQL Server running port?

by

Try this:

USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on' 
GO

http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/

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. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  5. How to add Active Directory user group as login in SQL Server
  6. Why use the INCLUDE clause when creating an index?
  7. How to set a default value for an existing column
  8. An attempt was made to access a socket in a way forbidden by its access permissions
  9. SQL Server: combining multiple rows into one row
  10. SQL Server Query: Fast with Literal but Slow with Variable
  11. How do I find a stored procedure containing ?
  12. Should every User Table have a Clustered Index?
  13. An attempt to login using SQL authentication failed
  14. How to set monday as first day of week in SQL Server
  15. SQL Server, the misleading XLOCK & optimizations
  16. Drop primary key using script in SQL Server database [duplicate]
  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. In SQL Server, how can I find everywhere a column is referenced?
  27. ‘Incorrect SET Options’ Error When Building Database Project
  28. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  29. Why insert-select to variable table from XML variable so slow?
  30. Generate MD5 hash string with T-SQL

Leave a Comment