Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rudy Panigas SQL Server Port Number Identifier RE: SQL Server Port Number Identifier

  • February 16, 2011 at 12:23 pm

    #1287868

    anand13685 (2/16/2011)

    If you have access to SQL server error logs...which any DBA would....just check the time when the SQL server was last started, and in the startup parameters, it gives the port that the instance is listening on.

    or open sql server configuration manager, and click on the tcp properties where you can set the port on which SQL should listen.

    Good point. I was doing that before and thought that there must be an easier way. So I worked on some T-SQL code and that's how this code was created.

    Thanks

    Rudy