What authentication method should I use in SQL server connection string?

Question

I have a question regarding the credentials used in SQL server connection string. Basically I create a windows service to handle my SQL database procedures (Insert, Select, Delete and Update etc.), this service is logged on as a special windows user I create with sufficient database permissions, it doesn't log on as Local System. Other windows accounts don't have SQL server permission.

So what do I use in my connection string?

Do I use Integrated Security= true ? Or do I use my special user credentials?

Thank you for reading

If the service is running as the special user, then just Integrated Security=true should work. — Blorgbeard
– Blorgbeard, Commented Mar 30, 2016 at 0:36

Cole W · Accepted Answer · 2016-04-01 18:18:25Z

1

Use Integrated Security=true if you want the same user that your windows service is running under to access the database.

answered Apr 1, 2016 at 18:18

Cole W

15.4k7 gold badges56 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What authentication method should I use in SQL server connection string?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related