Re: Machine account access

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 07/28/05


Date: Wed, 27 Jul 2005 18:35:15 -0600

Local system does not have access to network resources.

-Sue

On Wed, 27 Jul 2005 09:17:06 -0700, "lleonard"
<lleonard@discussions.microsoft.com> wrote:

>Hi everyone,
>
>I'm trying to access SQL Server from an application that is a service
>running under the "Local System" account in a computer which is not the same
>as the one running SQL Server. The service must run under this account, and
>still should have access to an SQL Server database.
>
>I've given permissions to the computer account in SQL Server, as both
>computers are in Active Directory, but the service still does not connect
>(due to permissions).
>
>Is it possible to have this scenary running? Any idea on how to make it work?
>
>Thanks in advance,
>Lleonard.



Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... functionality using our WinForm app and read-only functionality using ... SQL Server permissions are not application-aware. ... App1 contains CRUD functionality using stored procs (EXEC perms on ...
    (microsoft.public.sqlserver.security)
  • Re: bitewise and
    ... with applciation functions to which they do not have permissions. ... application that used the SQL Server groups for granting permissions adding ... permissions and the SQL Server groups. ... If you are using a database system that actually creates an SQL Server ...
    (microsoft.public.sqlserver.programming)