XP_CMDSHELL returns "The syntax of this command is:"

Asked Oct 16 '17 at 14:09

Active Oct 16 '17 at 14:54

Viewed 806 times

I am trying to make another drive available through SQL.

exec xp_cmdshell 'net use G: \\IMAFS01\Finance'

works fine but

exec xp_cmdshell 'net use J: \\IMA-SQL01\Microsoft SQL Server 2016 /user:[XXX\xxx] /persistent:yes'

returns the message below. There is no password and I have full control of the folder.

This is what the output says:

The syntax of this command is:
NULL
NET USE
[devicename | *] [\\computername\sharename[\volume] [password | *]]
        [/USER:[domainname\]username]
        [/USER:[dotted domain name\]username]
        [/USER:[username@dotted domain name]
        [/SMARTCARD]
        [/SAVECRED]
        [[/DELETE] | [/PERSISTENT:{YES | NO}]]
NULL
NET USE {devicename | *} [password | *] /HOME
NULL
NET USE [/PERSISTENT:{YES | NO}]
NULL
NULL

edited Oct 16 '17 at 14:54

asked Oct 16 '17 at 14:09

anonymous

5

You have spaces in the folder name. Enclose the entire path in double quotes and it should work fine. – SS_DBA Oct 16 '17 at 14:10
1

Thanks, that worked. – anonymous Oct 16 '17 at 14:14
Here is the code that worked: exec xp_cmdshell 'net use J: "\\IMA-SQL01\Microsoft SQL Server 2016" /user:XXX\xxx /persistent:yes' – anonymous Oct 16 '17 at 14:44

XP_CMDSHELL returns "The syntax of this command is:"

0 Answers0