1

I initially installed SQL Server 2008 R2 with Windows authentication mode and have successfully changed it to mixed mode (per http://msdn.microsoft.com/en-us/library/ms188670.aspx).

After this I am able to log in to my SQL Server with SQL Server authentication. But from another computer which is on my network, I am not able to connect my server.

Improve this question
4
  • 2
    After all that, your problem is that the agent isn't started? talk about a long story and title going nowhere...
    – Marc B
    Commented Feb 17, 2012 at 4:41
  • 5
    I don't think it matters if SQL Server Agent is running, have you enabled TCP/IP Connections? You really should cut all the irrelevant material out of your question and rename your question. Plus this should probably be moved to db admins
    – J Cooper
    Commented Feb 17, 2012 at 5:05
  • Your SQL Server Browser service is maybe not running. See my checklist in this answer: stackoverflow.com/a/6001023/44522
    – MicSim
    Commented Feb 17, 2012 at 8:32
  • 1
    It would be very helpful if you explain what "not able to connect" means. Do you get an error message? If so, what is it? Did you check the state in the SQL Server error log?
    – Aaron Bertrand
    Commented Feb 26, 2012 at 13:08

2 Answers 2

Reset to default
2

For security reasons SQL Server 2008 no longer opens TCP port 1433 upon installation. You will need to create a firewall rule that allows communication over TCP port 1433 (and UDP port 1434 if you wish to use the browser service) to allow applications to communicate with SQL Server.

Improve this answer
1
  • Does this apply to SQL Server 2008 R2 Express version also?
    – TheTechGuy
    Commented Mar 27, 2012 at 17:53
0

I really don't think that the problem is with your SQL Server Agent, as this is just to perform tasks related to Backup, Replication ... etc.

I have written an article which has an idea of what your problem could be:

Cannot Login to SQL Server from Network

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.