hi guys, i am sure this might be a common issue, i am running on sql 2000, i have two databases, i occasionally get a timeout when trying to connect, but i can physically go the machine and it would work fine, please help..it give me a error there was a server timeout, they are both on the same lan, can ping my hostname fine...also, i may need to upgrade to service pack 1, this might be a issue, how do i check what service pack for sql i am running, on windows 2000..its on sp 2..please help, thanks in advace
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
timeout on sql 2000
- Thread starter ccnet101
- Start date
I'm not sure how are you connecting but I'm guessing you're connecting it from a computer which has sql client on it. Try look at your client network configuration from the computer you're connecting from and see if it has the same protocol as the server. I always put NamePipes on the top.
Andel
andel@barroga.net
Andel
andel@barroga.net
- Thread starter
- #3
actually, i should said this i forgot, i am just trying to connect throught the em, enterprise manager, my clients can connect to the database fine, inface, this issue just started occuring all of a sudden, it was working fin last week..please help
- Status
Similar threads
- Locked
- Question
- Locked
- Question