PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds
- From: archanapatelwhite@xxxxxxxxxxxxxx
- Date: 22 Mar 2007 17:00:28 -0700
Hi,
I am remotely accessing SQL Server 2005 using an import manager,
through a windows authentication login.
I start the loading, it connects perfectly at first but at the 100
second mark I get the error
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does
not exist or access denied" it then reconnects and continues to load
but really slowly. So it looks like a timeout is occuring at 100
seconds
I have tried to change the connection timeout, the execution timeout
and the remote login timeout, nothing stops this happening.
The version of sql I am using is a SQL Server 2005 Evaluation edition.
Can anyone help?
Thanks
Archana
.
- Follow-Ups:
- Re: PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds
- From: William \(Bill\) Vaughn
- Re: PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds
- Prev by Date: Re: Connection refusals
- Next by Date: Re: Connection refusals
- Previous by thread: Re: Connection refusals
- Next by thread: Re: PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds
- Index(es):
Relevant Pages
|
