Using Network Service Account to remote SQL Server with WSS
Date: Fri, 18 Feb 2005 08:34:21 -0000
seems like a good idea and kb below has some detail on how to grant
permissions in SQL Server by using Domain\Computername$
http://support.microsoft.com/default.aspx?scid=kb;en-us;832769
Saves manaully creating service account and having a password that should be
reset periodically therefore less of a security risk.
Is this good practice / any probs experienced with this ?
cheers,
Andy.
Relevant Pages
- Re: Error 22039 trying to add SQL 2K to AD
... "permissions that matter but rather the permissions of the SQL Server ... What do I lose by not having SQL server registered with AD? ... > of the SQL Server service account. ...
(microsoft.public.sqlserver.setup) - Re: Detailed User Access Rights
... Sysadmin role members have full SQL Server permissions and OS permissions ... > 2) Now that my customers can create their own views etc, ... GRANT SELECT ON MyTableFunction TO CustomerUser ...
(microsoft.public.sqlserver.security) - Re: xp_cmdshell right for non sysadmin
... You can get the error when the SQL Server service account ... does not have the necessary permissions to change security ...
(microsoft.public.sqlserver.server) - Re: xp_cmdshell failed to execute because current security context
... The permissions needed are outlined in the KB that Uri posted. ... When you install SQL Server, you get a bunch of groups, one for each service for that instance. ... So you need to make sure that your service account is a member of this group. ... > ontario, canada ...
(microsoft.public.sqlserver.server) - Re: Permission to Insert records for DB USERS
... You could use the GRANT command to grant INSERT permissions to users. ... See SQL Server Books Online for more information. ... > for the permissions on the database. ...
(microsoft.public.sqlserver.security) |
|
