I'm having sql server in win xp with sp 3. while connecting to remote sql server 2000 i'm getting time out expired(sql exception.) plz help me in this issue
It may be because of many issues, like network traffic issues, server too busy on resources that it's unable to accept any connection.
Are you getting this error while connecting or while running a query?
Do you have a linked server or u're trying to connect via enterprise manager?