Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Failing to connect SQL Server 2005 from SAP

Former Member

‎2011 Apr 22 8:37 AM

0 Kudos
254

I'm trying to connect SQL database to write some data to an external sql table. But it's failing giving below message,

Error Message returned from "ADBC_TEST_CONNECTION" program:

Testing a Database Connection Defined in DBCON

Could not open connection EACT_MESSAGES

sql error 1- occured:

Login timeout expired

I can connect from .NET Applications using the same connection string configuration.

What could be the reason for this.

Do I need to enable some service for this in SQL server. I have enabled all possible SQL related services.

But still no luck.

1 REPLY 1

Former Member

‎2011 Apr 22 12:57 PM

0 Kudos
73

I found a solution..

Instead putting the server name, used IP address which is static. that solved the issue.