title: What port is my SQL2008 instance running on?
body: <p>Check out this pic  of my SQL 2008 Management Configuration screen for TCP: <img src="https://content.screencast.com/users/Dokmanc/folders/Jing/media/377bd6b7-2932-48f5-b85f-f2d3d91b09d8/2010-05-22_1607.png" alt="alt text"></p>
  
  <p>I need to know what port I am running on. Based on <a href="https://stackoverflow.com/questions/2888985/cant-see-all-databases-in-a-remote-sql-server-instance">this previous post</a>, I don't believe that it is 1433, which I guess is the default. </p>
  
  <p>When I check my port number in SQL Config Mgr., it is blank. Does this suggest a default port? Note that I have multiple SQL Server instances on the db server. One 2000 instance and two 2008 instances. I want to know the port of the 2008b instance.</p>
  
  <p>The first display is for TCP. I'm not sure what VIA is, but check it out:</p>
  
  <p><img src="https://content.screencast.com/users/Dokmanc/folders/Jing/media/16906ba3-04f0-47f5-ada2-1a7328f7adea/2010-05-22_1659.png" alt="alt text"></p>
  
  <p>Can you help?</p>
  
  <p><strong>Update</strong></p>
  
  <p>I restarted my sql2008b instance and checked the log to look for a msg that indicated the port that it was using. It showed this:</p>
  
  <pre><code>2010-05-22 20:06:29.27 Server      A self-generated certificate was successfully loaded for encryption.
  2010-05-22 20:06:29.27 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQL2008B ].
  2010-05-22 20:06:29.27 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQL2008B\sql\query ].
  2010-05-22 20:06:29.32 Server      Server is listening on [ 127.0.0.1 &lt;ipv4&gt; 5786].
  2010-05-22 20:06:29.32 Server      Dedicated admin connection support was established for listening locally on port 5786.
  </code></pre>
  
  <p>Yet, when I tried to log on using the following as the server name:</p>
  
  <p>(local)\sql2008b,5786</p>
  
  <p>I still was unable to connect, while logged onto the remote box (hence using "local".)</p>
  
  <p>A suggstion was made below to set the port myself. This occurred to me to try but there are a couple of things that are botehring me:
  1) Why can I connect to  my SQL 2000 instance without monkeying with anything to get it to work (but not my 2008 instance)?
  2) The IP addresses shown in TCP1 and 2 don't appear correct. The one I blacnked out, presumably theIP address of my router and the one needed to make my server visible on the Internet, was not correct. Also , the local 192.168.1.100 was not correct. The db server server's IP adress end in a different number. perhaps I sh</p>