Hi All,

I have a nsrsqlsv command that works if I run it via command shell but does not 
work if I run the same command and syntax via xp_cmdshell in SQL.

Here is the command:  
C:\Progra~1\Legato\nsr\bin\nsrsqlsv.exe -s networker_server_name -b Default 
-N DB_Full "DB_Name" -a "Virtual_Server_Name" -v

The command above works if I run it via command shell... but if I run the below 
command from Query editor,  I get the error described after:

xp_cmdshell 'C:\Progra~1\Legato\nsr\bin\nsrsqlsv.exe -s 
networker_server_name -b Default -N DB_Full "DB_Name" -a "Virtual_Server_Name" 
-v'

ERROR:
43708:nsrsqlsv:Start time: Mon Feb 16 07:24:03 2009
43621:nsrsqlsv:Computer Name: Virtual_Server_Name    
 User Name: some_user
29085:nsrsqlsv:Microsoft SQL Server Provider error:
38006:nsrsqlsv:Named Pipes Provider: Could not open a connection to 
SQL Server [2]. .
38006:nsrsqlsv:An error has occurred while establishing a connection to 
the server. When connecting to SQL Server 2005, this failure may be caused by 
the fact that under the default settings SQL Server does not allow remote 
connections..
38006:nsrsqlsv:Login timeout expired.
37955:nsrsqlsv:
Cannot login to SQL Server null.
43709:nsrsqlsv:Stop time: Mon Feb 16 07:24:15 2009
NULL
NULL

Any ideas, dear experts?

Thanks!
Lhot

+----------------------------------------------------------------------
|This was sent by lhotgalisteo AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER