Unable to connect to the instance through SSMS

• Chitown

  Hall of Fame

  Points: 3239

  More actions

  February 25, 2016 at 10:38 am

  #325068

  I am wondering if I can get some help. I am able to login to an instance using SSMS when I m in the server but when I use client, I am not able to. I get this error "A network related error occurred while establishing the connection .........................Access is denied"

  I did change the port number (Just used a random number and didn't know which port to use). Before that it was using default port (1433)

  Any help!

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 25, 2016 at 10:51 am

  #1861175

  This is a great place to start:

  https://blogs.msdn.microsoft.com/sql_protocols/2008/04/30/steps-to-troubleshoot-sql-connectivity-issues/

  -- Gianluca Sartori

• Chitown

  Hall of Fame

  Points: 3239

  More actions

  February 25, 2016 at 11:08 am

  #1861183

  Enabling the named pipe did the trick.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 25, 2016 at 11:12 am

  #1861185

  Do you have permissions to Remote Desktop into the Server?

  Then try connecting to SSMS.

  The run sp_who3 and identify what is going on. http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3"> http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/