Which user account is running SQLCMD in T-SQL Script without -U and -P option?

Question

I am using sqlcmd in a T-SQl script to write a text file to a network location. However SQLCMD is failing to write to that location due to access permission to the network folder. SP is being run under my user account which has access to the network folder.

Could you please help me under which account sqlcmd will run if I do not specify -U and -P option in TSQL Script?

Answer 1

If you don't provide credentials with -u/-p it will try to use windows authentication; i.e the windows account of whomever is running it.

I often just use Process Monitor to look at what account is being used and what the permission error is.