Can't Connect to SQL 2008 R2 with server name

  • In my case I was connecting through IP ...don't know the exact reason behind this problem yet....Any suggestions from experts out there ?

  • What is the status of the issue

  • Really need further info about whether it's SQL Express for example (where you would often have to manually enable Remote Connections), Named Pipes has been enabled (The error suggests Named Pipes, so it may need enabled/configured within SQL Server Configuration Manager), whether you're missing an instance name, and whether you have tried Integrated AND SQL-based security logins to see whether ths issue is specific to one or another...

    Those are the first few things I would check.

  • Make sure that sql sever instance machine name was not changed

  • Have you tried connecting using the fully qualified domain name of the machine?

    It's possible that the default domain of your machine is different than the default domain of the server, especially since you are able to connect to it using the IP address and a reverse lookup of the IP address returns the correct server name.

Viewing 5 posts - 16 through 19 (of 19 total)

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