Server A: Database Server
Server B: App Server
1.Installed SQL Server 2017 RTM on Windows 2016 Server
2.SQL Server service running with default account "NT Service\MSSQLSERVER"
4.Trying to rename the file(which is on Server B another applicaiton server) using below command(with SSMS in Server A) and getting error "ACCESS IS DENIED"
Command: exec xp_cmdshell 'RENAME \\ServerB\Test\file1.txt File2.txt'
Note: Executing this command with SYSAdmin privileges on SQL Server.
5.If we run from Server A using command line(DOS) prompt, its working and not working with SSMS.
(DOS: RENAME \\ServerB\Test\file1.txt File2.txt )
Any suggestion and advise on this "ACCESS IS DENIED" issue?
[I know if we create with separate service account for SQL Server service then it will work after granting the permissions on share, but client do not want separate id, want to go with default "NT Service\MSSQLSERVER" service account]