Take the 2-minute tour ×
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.

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.

share|improve this question

migrated from stackoverflow.com Feb 17 '12 at 19:51

This question came from our site for professional and enthusiast programmers.

2  
After all that, your problem is that the agent isn't started? talk about a long story and title going nowhere... –  Marc B Feb 17 '12 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 Feb 17 '12 at 5:05
    
Your SQL Server Browser service is maybe not running. See my checklist in this answer: stackoverflow.com/a/6001023/44522 –  MicSim Feb 17 '12 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 Feb 26 '12 at 13:08

2 Answers 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.

share|improve this answer
    
Does this apply to SQL Server 2008 R2 Express version also? –  Jackofall Mar 27 '12 at 17:53

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

share|improve this answer

Your Answer

 
discard

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