SQL SP and SNA CLIENT Problem

[güven]

Dear All,

We use Sna4.0 Sp4 Client and Server for messaging between
Mainframe and Sql Server.Sna Client is installed on the
Sql Server.When the request comes to the Sql server, Sql
server calls Sql2Dbos.dll via Sql SP. Sql2Dbos.dll sends
the messages to Sna Clinet.Sna Client sends the messages
to Sna Server.
Sometimes our users can not send messages to
Mainframe.When this problem occurs I examine the Sql
Server Application event log.I do not see any "Appc Tp
started locally" event log.Normaly I have seen this type
of events .

Event id:70
APPC TP started locally:
TP_ID = 02000000A013E700
TP name = E3F2E8D3E3C5E2E3


Event id:72
APPC conversation started locally:

TP_ID = 02000000A013E700
Conv_ID = 00E71490
Dest TP name = E3F2C4D9
LU alias = TRPHX
PLU alias = CICSPHXX
Mode name = D4F6F2C1D7D7C340

Event id:74
APPC conversation ended:

TP_ID = 02000000A013E700
Conv_ID = 00E71490

Event id:71
APPC TP ended:

TP_ID = 02000000A013E700



We handle the problem by stopping and starting the Sna
Client Snabase services. SQL server crashes when we stop
the Snabase services on SQL server.We restart the Sql
server services manually.
I think,problem is arise Sql SP call and receive
Sql2Dbos.dll.Why SQL server is crashing when we stop the
Snabase services?

thanx,

[Mike Smith[MSFT]]

What does the event log post when the SQL Service crashes? What happens if
you do not restart the SNABase serice and let it sit for a few minutes to
recover? Usually it is better to get some idea of what happens when it
works then look at a failure. THis one could be rather complicated so
unless you are up to tracing you may wish to open a support case.

Michael Smith
MCSE
SNA Server/Host Integration Server 2000 Support
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[a***@discussions.microsoft.com]

ok. thanx

-----Original Message-----
What does the event log post when the SQL Service

crashes? What happens if

you do not restart the SNABase serice and let it sit for

a few minutes to

recover? Usually it is better to get some idea of what

happens when it

works then look at a failure. THis one could be rather

complicated so

unless you are up to tracing you may wish to open a

support case.

Michael Smith
MCSE
SNA Server/Host Integration Server 2000 Support
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and

confers no rights.

Use of any included samples are subject to the terms

specified at

http://www.microsoft.com/info/cpyright.htm
.