Application/computer sometimes cannot access sql server in LAN, others in the LAN can

Hi,
I have an web project in asp.net in one of my computers which are connected internally through LAN. The database is in Sql Server kept in another computer. The LAN is connected well. There is no connection error in my programming also. But sometimes in this particular system the page is taking long time to be open, sometime it is showing some exceptions(not everytime again and again). What can be the problem? How can it be solved?
The same project is running good in other computers as well.
My network seems ok, as I can acccess the computer hosting SQL server.
sdugarAsked:
Who is Participating?
 
Jim P.Commented:
Do you have Named Pipes enabled?

On the server side -- Disable all named pipes options and restart the SQL Services.

On the client side specify TCP/IP with cliconfg.exe
0
 
David ToddSenior DBACommented:
Hi,

A couple of additional thoughts: Is there a firewall in the path?

How do you know that there isn't a physical issue with this servers nics/ the hub or switch etc?

HTH
  David
0
 
sdugarAuthor Commented:
thanks ...its still not solved completely. May be virus problem...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.