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 cmd
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 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 & 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 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 & rdgs