Login Failed For User 'nt Authority\anonymous Logon' In Sql Server 2008

I am executing a script by using file like below: EXEC master.dbo.xp_cmdshell 'sqlcmd -d TE07 -S ServerName -i D:\TE07.sql' When executing the above line I am getting the below err

Solution 1:

We have to use username and password also while executing the sql file using cmdshell:

EXEC master.dbo.xp_cmdshell ‘sqlcmd -D db_name -S server_name -U username -P password -i sqlfile’

Use the above format