File transfer from Application server to Db Server without a shared folder access but using Service Account
There is a general lack of understanding here.  I suspect your company doesn't understand your "requirement" and the Server team has provided something that either won't do the job or your team don't know how to make it work.  

You say that you "need" to get a file onto a Database server - my first question would be - "why"? 

What's in this file that you need to put it anywhere near the Database server? 

Your company has a Policy against doing this through file shares on the Database server.  [Being a DBA] I completely understand (and agree) with this Policy.  

On its own, a Service Account isn't going to be much use to you.
You might be able to use it with some File Transfer utility to copy the file but, again, why do you want to do this? 

Take a step back and describe the "Big Picture" problem that you're trying to solve here.