Gerrit Lokhorst

For several reasons it’s very handy that a certain instance is running on a static port. In this article I describe how to do the different steps

1. Start the SQL Server Configuration Manager
2. Click open the SQL Server Network Configuration and click on the rule Protocols for <instancename>
3. On the right pane you see a list of protocols. Double click ‘TCP/IP” and go the tab “IP-addresses”.
4. Delete by every IP-addresses the zero by TCP Dynamic Ports see pictures below
5. 

   TCP Dynamic Ports

    

6. 

   TCP Dynamic Ports

7. Delete by IPALL also the portnumber by TCP Dynamic Ports
8. Change by IPALL the portnumber by TCP Port into the number you like
9. Click Apply and close the screen.
10. Click in the SQL Server Connection Manager below SQL Server Configuration Manager (Local) on SQL Server Services.
11. Do a right click on the instance which you modified in the earlier steps and click on restart.
12. To Check if the instance is running at the specific port take the following steps
13. Login with a domain or sa account on the SQL server
14. Start the Microsoft SQL Management Studio
15. Login to the instance you will change
16. Start a new query and past the following SQL-query
17. Past only the text between the brackets
    [[[
    USE master
    GO xp_readerrorlog 0, 1, N’Server is listening on’, ‘any’, NULL, NULL, N’asc’
    GO]]]

18. Execute the query. The results likes 
    

19. Finally I rebooted the server and check the port again.