Sql server : Time out expired.

Question

Sql server : Time out expired.

karthimca07

Mr or Mrs. 500

Points: 578
More actions
June 27, 2009 at 1:33 am

#93761

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

karthimca07 (6/27/2009)
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?

Pradeep Singh

ps. One Orange Chip Points: 29422 More actions · Answer 2

Also you can try to increase the login timeout.

sp_configure 'remote login timeout', 60

go

reconfigure with override

go

This will set the login timeout value to 60 seconds

Pradeep Singh

karthimca07 Mr or Mrs. 500 Points: 578 More actions · Answer 3

When i'm trying to connect to the remote server i'm getting this error. Not in Enterprise manager. In My application i wrote a code to connect.(Vb.net + Sql Server 2000).