Remote Server Problem

[Christian Weiß]

Hello,

we are using ASE12 under NT and we trying to get a connection to a remote
server(SQL Server). We have a correct
interface and we are able to connect using isql to the server WELLSQL2.

If we try to insert a remote table we got the following error message in the
log.

01:00000:00012:2000/11/15 16:15:13.46 server Error: 7235, Severity: 17,
State: 0

01:00000:00012:2000/11/15 16:15:13.46 server No other query entry found for
the remote server WELLSQL2 - site WELLSQL2. Aborting this site handler, as
no remote server responded. Please make sure the remote server is accepting
connections.

00:00000:00013:2000/11/15 16:21:34.23 kernel 01:00000:00012:2000/11/15
16:15:13.46 server Failed to connect to remote server WELLSQL2 nlmsnmp ether
NT operating system error 5 in module
'e:\rel120\porttree\svr\sql\generic\ksource\strmio\n_winsock.c' at line
3710: Zugriff wurde verweigert.

Whats wrong ?

Christian Weiss, cwe...@tycoint.com

[Anthony Mandic]

"Christian Weiß" wrote:

> If we try to insert a remote table we got the following error message in the
> log.
>
> 01:00000:00012:2000/11/15 16:15:13.46 server Error: 7235, Severity: 17,
> State: 0
>
> 01:00000:00012:2000/11/15 16:15:13.46 server No other query entry found for
> the remote server WELLSQL2 - site WELLSQL2. Aborting this site handler, as
> no remote server responded. Please make sure the remote server is accepting
> connections.
>
> 00:00000:00013:2000/11/15 16:21:34.23 kernel 01:00000:00012:2000/11/15
> 16:15:13.46 server Failed to connect to remote server WELLSQL2 nlmsnmp ether
> NT operating system error 5 in module
> 'e:\rel120\porttree\svr\sql\generic\ksource\strmio\n_winsock.c' at line
> 3710: Zugriff wurde verweigert.
>
> Whats wrong ?

Does the remote server have an entry in the local server?
Check with sp_helpserver. Is the remote server configured to
allow remote connections?

-am