Cannot connect to SQL Server from remote machine?

Check each of these…

  • Make sure SQL Server is running on the target machine (SQL Server Configuration)
  • Ensure TCP/IP is enabled (SQL Server Configuration)
  • Ensure “Allow remote connections to this server” is enabled (SSMS server properties)
    • Note default setting:  2005=disabled, 2008=Enabled
  • Check Port 1433 is open across network (Firewall at both ends but particularly the server)
  • If using dynamic ports then check SQL Server Browser Service is started and not blocked by firewall (at server)
  • Make sure the IP address is correct. i.e. Ping the server and see if the IP address is what you think it should be. If not then…
    • Check aliases in SQL Server Configuration
    • See if there is an invalid entry in Window hosts file on the machine you are connecting from
    • See if there is an invalid entry in Network DNS
Advertisements

About davidbridge

I am a contractor for David Bridge Technology Limited specialising in database design and Web development using Microsoft technologies such as c#, MVC .net and SQL Server (full stack)
This entry was posted in Developer stuff, SQL Stuff and tagged , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s