XP_cmdShell Error

From: Nik (anonymous_at_discussions.microsoft.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 04:14:11 -0700

Dear All
I am trying to below script on BOX1

Declare @Sql varchar(8000)
Set @Sql = 'OSQL -SBOX2 -E -dmaster -q"Select 1"'
Exec master.dbo.xp_cmdshell @Sql

But it is Blowing with below error.
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL
Server connection.

It used to work fine till y'day night but all of a sudden
things started blowing.

The i am running the script under SA rights and trying to
connect to another Box in different domain.

Please advise ASAP

Thanks in advance.

Relevant Pages

  • Efficiency
    ... I wrote a script that built the SQL to examine text fields using a LIKE ... but for some reason or other I couldn't get it to work. ...
    (microsoft.public.access.queries)
  • Loging Script
    ... It seems there is something wrong with my script for the reason that ... it always returns, UserName NOT found. ... $sql = check; ...
    (comp.lang.php)
  • Re: Pagination II
    ... the categories have enough entries to fill multiple pages. ... script runs and always goes to page 2 for some reason. ... Start with your SQL, once it's correct, then print it ...
    (comp.lang.perl.misc)
  • Re: Pagination II
    ... script runs and always goes to page 2 for some reason. ... Can anyone spot the problem? ... print $sql; ...
    (comp.lang.perl.misc)
  • Re: Vista hosting XPe tools/db
    ... Are you running this script on the machine that actually has the SQL server ... machine hosting the database. ... i don't know if you can install a second instance of SQL ...
    (microsoft.public.windowsxp.embedded)