Monday, March 3, 2014

Obtaining Port Number for SQL Server Database Connection

Two simple ways of obtaining your port number for Connection String usage.

-- From start, right click on computer then click on Manage.
-- Click on Services and Applications
     |
     --SQL Server configuration manager
           |
 **      --SQL Server <year> Network configuration       
                   |
                    --Protocols for <Server type>
--Right click on TCP/IP then, select/click_on properties.
--Select the IP Address tab, look for TCP port; DONE!!!

          OR

-- From start 
     |
     -- All Programs
           |
           --Server configuration manager
           |
            --Microsoft SQL Server <year> 
                   |
                   --SQL Server <year> configuration manager
                 
 Continue from ** above

No comments: