Sql-server – Log-in as service account in SQL Server Management Studio

sql serverssms

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:
enter image description here

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

Best Answer

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

How To Add A Service Account To Microsoft SQL Server

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

For further your ref here and here

Related Question