Log-in as service account in SQL Server Management Studio The stored procedure that performs a CTE in production is being executed using a service account. However, the stored procedure returns empty and I tried checking this using SSMS but I my domain account has no execute functionality in production. 

I tried logging into SQL Server Management Studio using the service account but I ran through some problems. First was resolved by following this link - The certificate chain was issued by an authority that is not trusted

However, once that is executed, it returns as if no user name was provided:
 

Question is, can I login using a service account in SQL Server Management Studio?
Question is, can I login using a service account in SQL Server
  Management Studio?


How To Add A Service Account To Microsoft SQL Server


Open SQL Management Studio using SQL Authentication SysAdmin (SA)
Account.
Open up Security then Right Click on Logins, choose “New Login”
On the new login screen choose “Search”
On the search screen ensure you are searching the Entire Directory,
type in the user name, choose Check Names, then choose ok.
After you click OK, Click Server Roles and check “sysadmin”
Click OK and you are done
Test out by logging into SQL Management studio using Windows
Authentication.


For further your ref here and here