服务应该在哪个 Windows 帐户下运行才能访问网络 sql 服务器 [英] what Windows account should a service run under to access network sql servers

问题描述

我正在考虑创建一个 Windows 服务，它会定期运行并查询网络数据库并将信息存储在本地机器上(请不要问为什么！).我希望在没有人在本地登录计算机时运行此服务.该服务应在 Localservice、Localsystem 或 Network 下运行的帐户.用户名和密码将提供给包括本地在内的所有网络数据库.

I am considering creating a windows service that would run periodically and query networked databases and store the information on the local machine (please don’t ask why!). I would like this service to run when there is no one logged on to the computer locally. What account should the service run under Localservice, Localsystem or Network. A username and password would be provided to all networked databases including the local.

推荐答案

我可能会创建一个特定的域帐户并将该权限授予 SQL Server 和您要使用的任何本地存储.如果您想使用 SQL 凭据连接到数据库，则它可以是本地帐户(可以访问本地资源)或更高权限的用户(如 LocalSystem).

I'd probably create a specific domain account and grant that rights to both SQL server and whatever local store you are going to use. If you want to use SQL credentials to connect to the DB, then it could be a local account (with access to the local resources) or a higher privileged user (like LocalSystem).

这篇关于服务应该在哪个 Windows 帐户下运行才能访问网络 sql 服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！