net send address fail

Hi ,
how do i actually sent a message via net send addr in SQL server
i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
using the local system acct
i tried to put in an ip addr that i can ping to into the Fail safe Operator
but SQL complains that it fail to net send
could anyone advise ?
tks & rdgsFirst of all, make sure you can do that net send outside of SQL. Test at cm
d
prmpt. If that doesn't work, obviously you need to TShoot there first.
Second, if SQL is going to be hitting the network at all, you should start
SQL under a domain user account.
Third, try creating a simple job that does xp_cmdshell 'net send <remote
machinename> ''test'' '
Note: those are all single quotes.
Donna Lambert
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQ
L
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operato
r
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs|||Sorry, for clarification - it's SQL AGENT that needs to run under the domain
user account if you are creating and scheduling a job.
Donna
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQ
L
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operato
r
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs