windows service issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arvind P Rangan - 13 Jan 2005 09:36 GMT

Hi all,

We are writing a service which tries to access two database server on
different network.

while connecting to one of the database it give error saying 'EXECUTE
permission denied on object 'sp_sdidebug', database 'master', owner 'dbo''.

But if we are trying to connect to the same Database with any web or windows
application it does not raise any error and we are able to connect to that
DB.

We have also written the same service in VB6 which is working fine.

Thanks for your help
Arvind

Reply to this Message

Jo Siffert - 14 Jan 2005 19:32 GMT

Hi,

Windows Services run as LocalSystem by default - and LocalSystem uses
the computer account for its network credentials. By default, these
credentials are rejected by SQL Server.
Thus either grant access to the computer account in SQL Server, or -
better - create a new user in the AD for your service (with 'run as
service'-privilege), configure SCM to use this user and grant this user
access to the database.

/Jo

> Hi all,
>
[quoted text clipped - 12 lines]
> Thanks for your help
> Arvind

Reply to this Message

Rate this thread:

windows service issue

Free Magazines