Add XP Special Accounts Network Service and Local Service to sqlserver

Add XP Special Accounts Network Service and Local Service to sqlserver

From XP, Windows provides two special accounts, "Network Service" and "local service", dedicated to starting services. The former has lower permissions than the common "Local System" account, the latter. If a service needs to access sqlserver, it usually uses the NT integration verification to log on to the database, which requires creating the corresponding nt account in sqlserver.
It is not advisable to add a network server account to the Administrators group, because administrators is the DBO of all SQL Server databases and has excessive permissions. In most of my (almost all) applications, the account that logs on to sqlserver has only the public permission (usually assigned to it the permission to execute the stored procedure, but not the permission to directly execute the SQL statement ).
To add a network server account as the login of sqlserver, you cannot use sp_grantlogin or Enterprise Manager (at least in sql7). In fact, the solution is very simple, directly create an NT user group (such as NetworkService), add the network service account to the group, and then use sp_grantlogin (or enterprise manager.

This article from the csdn blog, reproduced please indicate the source: http://blog.csdn.net/seawave/archive/2006/02/07/594013.aspx