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 |
|
vsrakesh
Starting Member
2 Posts |
 Posted - 2007-05-04 : 15:35:45
|
| Hi,I have a connectivity problem in accessing SQL server 2000 using dotnet provider(SQL client). I tried connecting using visual web developer 2005.1) I can connect to SQL server using OLEDB provider but dotnet provider(SQL client) is failing with exception "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"2) I can connect to other SQL servers without any problem.So I guess the problem is related to this particular SQL server. I wonder any extra configuration setting should be required in SQL server to communicate with Dot net provider.Any help is greatly appreciated.Thanks,Rakesh |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-04 : 17:52:32
|
| failing when?and after how long?is it behind a firewall? you must have port 1443 opened._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
vsrakesh
Starting Member
2 Posts |
Posted - 2007-05-07 : 10:51:31
|
| Hi,I tried connecting using "Data configuration wizard" of Visual Web developer 2005. If I select .NET data provider for OLEDB I am able to connect, but .NET data provider for SQL Server (Standard SQLClient) is failing.After 20 seconds I am getting the exception.Port 1443 is already opened in firewall.Thanks,Rakesh |
|
|
|
|
|
|
Dotnet data provider for SQL server issue