RPC Problem & SQL not Shutting Down

[Vedanth]

Hi All,

I am currently facing two problems. Any help will be appreciated. We are using MSSQL SErver 65 , sp5a.

Problem 1: RPC Error....

Has anyone rcvd. the following message & how do we resolve this. ?

Unexpected end-of-message encountered in RPC response
from site 'SGPINT'. (Message 7224)

Problem 2: Shutting SQL Server

We shutdown SQL Server every day by running a dos script with the following command

net stop SQLExecutive & net stop MSSQLServer.

This has been working fine till a few days back. Currently, the SQLExecutive service is shutting down & SQL Service does not shutdown. There are no entries in the errorlog or event logs. The SQL Server hangs & then no-one can connect to it.

Any help will be appreciated.

Thanks !!!!!

Vedanth

[Jennifer Mathews]

I don't know anything about your rpc errors, but we do a very similar MSQ SQL reboot where I work, but we have have both commands in a script, but between the two net stops there is a sleep command for 60 seconds. Maybe this would help.

Jennifer


------------
Vedanth at 5/25/00 3:23:13 AM

Hi All,

I am currently facing two problems. Any help will be appreciated. We are using MSSQL SErver 65 , sp5a.

Problem 1: RPC Error....

Has anyone rcvd. the following message & how do we resolve this. ?

Unexpected end-of-message encountered in RPC response
from site 'SGPINT'. (Message 7224)

Problem 2: Shutting SQL Server

We shutdown SQL Server every day by running a dos script with the following command

net stop SQLExecutive & net stop MSSQLServer.

This has been working fine till a few days back. Currently, the SQLExecutive service is shutting down & SQL Service does not shutdown. There are no entries in the errorlog or event logs. The SQL Server hangs & then no-one can connect to it.

Any help will be appreciated.

Thanks !!!!!

Vedanth