Service Accounts

SQL Server Administration
1

I have created a REST API in Visual Studio and currently, it calls a SP in our database using my windows authentication. I am avoiding SQL Authentication to store user name and password.

Once I publish this API on the Application server, I will be using a Service Account to call the SP. Should I ask our Network Admin to create a new Service Account or use an existing built in one (which one if built in)?

2
  1. don't reuse svc accounts. have new one created (knowing you deal with HIPPA stuff)
  2. make sure svc account has only the perms it needs.
1 Like
3

Thanks for remmebering about the HIPPA stuff.

Should I ask the Network Admin to create it then, rather than using a SQL Authentication account?

4

I see you ask great questions all the time. Would be great to see you share the vast knowledge you are acquiring by sharing the experience you have gained here?

5

Will do!

6

yep create a bonified windows ad service account. always collaborate with sys admins

7

have you looked at express.js (https://expressjs.com/) a nodejs api module. visual studio api seems so cumbersome and fat and just yucky to me...

8

I used to do ASP and front-end as my main function. I am glad that I left it behind and stuck with reporting. It is not fun to keep learning a new framework every 4 years when I am aging.