It is the sql server service account but you have to pass those credentials explicitly to the web server:

[Microsoft.SqlServer.Server.SqlProcedure()]

public static void usp_HelloServer()

...