Connect to a remote instance of SQL Server
In SSMS (SQL Server Management Console - SQL Server 2005/2008/2012), a connection to a SQL Server instance on another computer fails.
- When attempting to connect in SSMS, the following error occurs: Cannot connect to MACHINENAME
- Ensure the SQL Server Browser service is started
- Ensure the "Client Protocol" in the SQL Server Configuration Manager has at least one protocol enabled, preferribly the TCP/IP protocol.
- Ensure port 1433 is not blocked by the firewall on the computer with SQL Server