BCP [SQL Server Native Client 11.0]Unable to open BCP host data-file

[robert030975]

Hi trying to send a file to a folder and having a few issues !

SQL2012

Error = [Microsoft][SQL Server Native Client 11.0]Unable to open BCP host data-file

Exec master..xp_cmdshell 'bcp "select name from sysobjects" queryout "\\SERVERNAME\FileDrop\out.txt" -c -T -S'

I have also tried the path \\SERVERNAME\C$\FileDrop\out.txt


EXEC xp_cmdshell 'ECHO %USERDOMAIN%\%USERNAME%'

NT Service\MSSQLSERVER


Any help would be great

 

[robert030975]

As a fix I Created a SQLAdmin account as admin and assigned the SQL service to it and hey presto it now works.