SQL Server 2008 R2 Remote Connection issue

Question

I have installed SQL Server 2008 R2 in mixed mode, but currently issue is I can't use SQL through ip nor ip with port, even I have enabled TCP/IP and open port in firewall too.

I tried to telnet 127.0.0.1 1433 to check whether its working or not but its not connecting I tried almost every possible things but failed in each.

How do I get this to work?

Answer 1

By default Sql server may not be listening for TCP/IP connections.

Did you check this stackoverflow question?

Also check start the "sql server agent" service is started.

Answer 2

Are you using a named instance or a default one?

Did you enabled a remote connection on that instance?

Right click on the server and in the Server Properties dialog under the Connections tab check the Allow remote connections to this server option

In the TCP/IP Properties -> IP Addresses -> IPAII:

For a named instance you should set set the TCP Dynamic Ports to blank and port 1434, for a default instance you use port 1433 (this is a default instance that SQL Server uses). After this step you should restart the SQL Server service for changes to take effect.

In the Programs -> Administrative Tools -> Windows Firewall with Advanced Security select the Inbound rules and New Rule:

1. For a default instance:

In the Protocols and Ports window: Select the TCP option, and in the Specific local ports text box enter the 1433 port

1. For a named instance:

Select the UDP option, and in the Specific local ports text box enter the 1434 port

Make sure that your SQL Browser is running if you use post 1434.

If you're trying to connect with an Windows Authentication you may also encounter an error that you're connecting to an untrusted domain.

Also it would be helpful if you'll give the exact error you're getting

Hope this helps

Answer 3

Odds are that the Windows Firewall is enabled and blocking port 1433. I would check that and set a rule to allow TCP/IP traffic over that port.