Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2010-09-23 : 09:02:18
|
| Hi All,I am unable to connect SQL Server 2008 server from my client machine(2008).TCP/IP and named pipes are enabled.What would be the reason?TIA. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-23 : 09:38:24
|
| Firewall settings? Is the server you're trying to connect to in another building? Have you talked to your network admins? What's the exact error you're getting? |
 |
|
|
learntsql
524 Posts |
Posted - 2010-09-23 : 09:40:18
|
| Thanks for ur reply.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-23 : 09:48:37
|
| If the server you're trying to connect to is within your Windows domain, talk to your network people and find out if there is a network outage, firewall restriction, or some other problem between your machine and that one. They'll need to open TCP port 1433 for SQL Server to respond (unless it's been configured to use a different port).I assume this is a web or desktop application that's having the problem. Have you tried connecting using Management Studio? |
|
|
|
learntsql
524 Posts |
Posted - 2010-09-23 : 09:49:49
|
| Thankx guys,It was firewall issue; resolved now. |
|
|
|
|
|
|
Unable to connect from Client.