Post reply

Management Studio Connection Problem

  • 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

  • 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?

  • March 16, 2015 at 1:39 pm

    #1784341

    Have you tried registering the SPN?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply