Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql server : Time out expired. Expand / Collapse
Author
Message
Posted Saturday, June 27, 2009 1:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 28, 2014 5:14 AM
Points: 15, Visits: 145

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
Post #743083
Posted Saturday, June 27, 2009 3:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
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
Post #743094
Posted Saturday, June 27, 2009 3:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
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
Post #743096
Posted Sunday, June 28, 2009 10:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 28, 2014 5:14 AM
Points: 15, Visits: 145


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).
Post #743341
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse