Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question
1  
Is this a named instance or the default instance? – Thomas Stringer Oct 6 '12 at 1:54

migrated from stackoverflow.com Oct 6 '12 at 1:19

2 Answers

up vote 0 down vote

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.

share|improve this answer
up vote 1 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.