using encrypted password in xp_cmdshell command
1
vote
1
answer
915
views
Dears ,
i am trying to make the mapped drive visible to SQL server and as a security requirement, I need to use user name and encrypted password because this will be saved on the logs if it is plain text.
EXEC xp_cmdshell 'NET USE F: \\DefinitelyNotMyLaptop\SQLBackups/ user:SqlUser P@$$w0rd'
i tried to declare a variable and save the .txt password on it but it did not work
any ideas?
- SQL server enterprise edition ,2019
Asked by Tala
(51 rep)
Jan 1, 2023, 08:05 AM
Last activity: Jan 2, 2023, 10:38 PM
Last activity: Jan 2, 2023, 10:38 PM