title: Sql Server 2008 remote access problem
body: <p>I have problem with connecting to Sql Server from my local machine.</p>
  
  <p>Seems like I did everything I could, but still I'm unable to connect to it.</p>
  
  <p>This is what I did:</p>
  
  <p>1) Right click on Sql Server in Sql Management Studio (SMS) -> Connections -> Allow remote connections</p>
  
  <p>2) Right click on Sql Server in Sql Management Studio (SMS) -> Security -> Allow remote connections -> Set Auth mode to Win and Sql auth mode (i.e. mixed mode)</p>
  
  <p>3) Disabled firewall</p>
  
  <p>4) Sql Server Configuration Manager -> Network Configuration -> Protocols -> Enable Shared memory, Named pipes, TCP/IP</p>
  
  <p>5) Sql Server Configuration Manager -> Network Configuration -> Protocols -> TCP/IP -> Properties -> Set TCP Port to 1433, Set TCP Dynamic  Port to 0. After that I restarted MainSql service in "services.msc"</p>
  
  <p>6) I ran "EXEC xp_readerrorlog 1" in SMS, found this:</p>
  
  <p>Server is listening on [ 'any'  1433].
  Server is listening on [ 'any'  1433].
  Server local connection provider is ready to accept connection on [  \.\pipe\SQLLocal\MAINSQL ].
  Server named pipe provider is ready to accept connection on [  \.\pipe\MSSQL$MAINSQL\sql\query ].
  Server is listening on [ ::1  64825].
  Server is listening on [ 127.0.0.1  64825].</p>
  
  <p>7) Tried to telnet [myip] 1433 from my home machine. Result: connecting To [myip]...Could not open connection to the host, on port 1433
   : Connect failed</p>
  
  <p>8) Tried to telnet [myip] 1433 from server - it worked!</p>
  
  <p>Seems like this is some kind of a network issue. I have another server with Sql Server installed, I did the same on it and I was able to connect to it from my home machine, but not this one! I tried to connect to this server from the second one and it didn't work too.</p>
  
  <p>Please help me, I don't know what to do. I did everything I could but it still doesn't work.</p>
  
  <p><strong>Update:</strong>
  Sql Server Browser service is started on the server machine. The server is a dedicated server at a hosting, I'm trying to connect to it from my home machine and from another server witch is a dedicated server as well, from another country.</p>