Management Studio Connection Problem

• shohelr2003

  Hall of Fame

  Points: 3535

  More actions

  March 13, 2015 at 11:21 pm

  #302072

  Dear,

  I am facing a problem of connecting SSMS using server name. When I use IP address, it connects to Management Studio successfully. But if I use server name, it returns an error like (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

  I executed select @@ServerNameI tested by the returned name but in vain.

  Please guide me the way to solve it.

  Thanks

• Bouke Bruinsma

  SSCrazy

  Points: 2185

  More actions

  March 14, 2015 at 1:12 am

  #1784022

  Check the protocol in config manager on the server that runs the instance? Is tcp/ip enabled?

  Can you ping the server ip? Can you ping the server name? What does nslookup return?

• vincyf1

  Say Hey Kid

  Points: 696

  More actions

  March 16, 2015 at 1:39 pm

  #1784341

  Have you tried registering the SPN?