Re: XP_cmdShell Error
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 06/01/04
- Next message: Konstantinos Michas: "Re: User rights"
- Previous message: Nik: "XP_cmdShell Error"
- In reply to: Nik: "XP_cmdShell Error"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: XP_cmdShell Error"
- Reply: anonymous_at_discussions.microsoft.com: "Re: XP_cmdShell Error"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Jun 2004 12:19:56 +0100
What account is your SQL Server service running under? Has it been changed
recently?
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ Is .NET important for a database professional? http://vyaskn.tripod.com/poll.htm "Nik" <anonymous@discussions.microsoft.com> wrote in message news:1608b01c447c9$907853e0$a601280a@phx.gbl... 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.
- Next message: Konstantinos Michas: "Re: User rights"
- Previous message: Nik: "XP_cmdShell Error"
- In reply to: Nik: "XP_cmdShell Error"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: XP_cmdShell Error"
- Reply: anonymous_at_discussions.microsoft.com: "Re: XP_cmdShell Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
