TCP Provider: A connection attempt failed

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

TCP Provider: A connection attempt failed

Author

Topic

sura
Starting Member

10 Posts

Posted - 2011-08-30 : 02:30:07

Hello All

I got a new Windows 2008 R2 Server and I am running a sqlcmd utility to trigger a SQL Server procedure, using batch file to loop it for 100 times (Sample test).

OS: Windows 2008 R2 64 bit Server- Firewall is off
SQL Client: SQL Server 2008 R2

SQL SERVER Installed in a different server:
OS:Windows 2008 R2 64 bit
SQL SERVER 2008 64 bit

All the 1 (one) are successful run and all of the sudden got the below error.

1
1
1
1
1
1
1
HResult 0x274C, Level 16, State 1
TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time,
or established connection failed because connected host has failed to respond.

Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while
establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and
if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

This batch file is triggered from the client installed server box.

This is not a new procedure and it is running for a while!!

SUCCESSFUL ENVIRONMENT

Env1
OS: Windows 2003 Server (Different Server) - 32 bit
SQL Client: SQL Server 2008

Env2
OS: Windows XP local desk top PC - 32 bit
SQL Client: SQL Server 2008 R2

Both Env1 &2 connecting the same SQL SERVER server box mentioned above.

The same batch file , SQL procedure running without any issues.

I am not sure where the issue is?

Any help is appreciated.

Thanks,
SQL User

orgswami
Starting Member

2 Posts

Posted - 2013-10-27 : 19:44:18

Was there any resolution to this? Currently deal with the same issue.

waterduck
Aged Yak Warrior

982 Posts

Posted - 2013-10-27 : 21:18:57

hi, is there any chances that the user login expire?

orgswami
Starting Member

2 Posts

Posted - 2013-10-28 : 09:54:11

If sura's issue is anything like mine (and it sounds like it) the login info is not expired. In my case, it happens only once out of 2-300 tests using ANY user.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources