September 18, 2006 at 1:42 am
Hi,
I have the following problem.
I have 10 systems connected through LAN, among which one is a SERVER contains WIndows SERVER 2003 Enterprise Edition(no SP1). The client systems have Windows XP SP2. In the server SQL Server 2000 Server Edition Installed and in clients SQL Server client version installed. All the client system have Microsoft Visual Studio.Net 2005. When connecting to Server's SQL Server through SQLCLient in .Net it woprks fine.
But the problem occurred when i install 2003 SP1 in server. in this case when connecting to server through Query analyzer(client PC) its ok. or when connecting to server through OLEDB in .Net it also works fine. BUT WHEN CONNECTING TO SERVER DATABASE THROUGH SQL-CLIENT IN .NET IT GIVES A ERROR "Time out Error". But after uninstall the service pack from server it again works fine.
Plz send me the reason & solution if anyone can.
Thanks
Damodar
September 21, 2006 at 12:52 pm
Hi,
You might want to check the firewall configuration on the 2003 server - SP1 installs and enables it, another tack might be to run the profiler on the sql server to investigate whether the VS2005 user can actually reach the sql server when SP1 is there. ADO.NET will probably be talking TCP/IP - Perhaps SP1 is blcking TCP/IP access but allowing another protocol (Named Pipes? I think its still useable in 2003)
I hope its been worth your while reading this...just a few pointers
Tony
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply