windows service issue -- dotnet component services

Arvind P Rangan
1/13/2005 3:06:45 PM

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

Jo Siffert
1/14/2005 8:32:47 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet component services

dotnet component services : windows service issue