Sample Header Ad - 728x90

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