title: How to connect to remote SQL Server using SSMS?
body: <p>First, the config....<br>
  -- Running SQL 2012 Developer (default instance MSSQLServer only) on Vista Home Premium<br>
  -- SQL/Vista box (HomeOfficePC) connects to home router via wireless<br>
  -- HomeOfficePC has a fixed ip assigned on the router<br>
  -- HomeOfficePC is running (on auto) SQL engine(tcp 1433), ReportServer (tcp 80), Analysis Svcs<br>
  -- HomeOfficePC is not running (on manual) Browser or Agent<br>
  -- HomeOfficePC firewall has TCP 1433, TCP 80 and UDP 1434 ports open for inbound<br>
  -- HomeOfficePC firewall TCP 1433 is pointed to sqlservr.exe<br>
  -- HomeOfficePC firewall UDP 1434 is open, but not pointed.<br>
  -- Router (2Wire from AT&amp;T) is pinholed to forward TCP 1433 to HomeOfficePC fixed ip<br>
  -- Router is pinholed to forward UDP 1434 to HomeOfficePC fixed ip<br>
  -- Router is pinholed to forward TCP 80 to HomeOfficePC fixed ip<br></p>
  
  <p>Second, the successes....<br>
  -- I can remotely connect+qry to HomeOffice\MSSQLSERVER via SSMS (shared mem) from laptop while at home<br>
  -- I can remotely connect+qry to HomeOfficePC\MSSQLSERVER via Android Galaxy S2 (my cell phone) SQL client app<br>
  -- I can connect to Report Server locally and remotely from any domain<br></p>
  
  <p>Now, the failures...<br>
  -- I cannot remotely connect to HomeOffice\MSSQLSERVER via SSMS from any other remote location (work, Starbucks, etc.) ... And yes, I made sure the SSMS client is running tcp/ip.<br></p>
  
  <p>So my questions are:<br>
  -- Is it syntax? How exactly do i connect to a remote SQL server ip using SSMS?<br></p>