Solved

Service Application

Posted on 2004-08-04
9
170 Views
Last Modified: 2010-04-05
I have created a Service Application that will call an executable inside a timer event.
My problem is that when the timer fires, the function to open the executable is made but the exe doesnt open.
When I try this on three other PC's all of different Operating Systems the Service works OK.
I know my problem is due to security on the offending PC but how and where do you look to configure security options to allow a Service access?

The PC that the Service doesnt work on is a Windows Server 2003. However I have tested the service on another Server 2003 PC and XP and 2000 and all work OK so it is the first Window Server 2003 that is the problem.

I know the code works as I have taken the Service code and placed it into a regular windows application and using a button click executed the code. And the program works.

Any help would be appreciated,
Thanks
0
Comment
Question by:HotRod40
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
9 Comments
 
LVL 17

Accepted Solution

by:
TheRealLoki earned 125 total points
ID: 11719828
I'm at a loss to know why it would work on 1 windows 2003 server, and not another.
I assume you are logging the service on as local system - interactive?
If so, and your service does not really have any visual aspecty, you might like to try the following
set up a user specifically for the service, and put it in an appropriate group to have the permissions you need.
For a "test" you could try logging your service on as an administrator. (property on the service settings)
If that works, then either
a) leave it like that
b) find out what policy / user rights settings differ between the 2 server 2003's
c) make a new user specifically for your service

What I tend to do is make a new group with nearly the same access as administrator, but the inability to logon as a user, i then make a user for that group, and tell my service to log on as that user
e.g. MyServiceGroup  - MyServiceUser

If, on the other hand, you can query the security policy settings, and user rights and see the difference between the 2 server 2003's then you wont have to do this.

hth, Loki
0
 
LVL 3

Expert Comment

by:MikProg
ID: 11723220
Any action in windows have result. What error code do you recieve if app does not started?
0
 

Author Comment

by:HotRod40
ID: 11723958
Thankyou for your suggestions.

I have tried logging the service on as the admin account but I receive a message showing:

   'MyAdmin has been granted the logon as a Service right'

MyAdmin being an administrator account.  What does this message mean?

In the mean time I will try to setup a specific account for the Service

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:HotRod40
ID: 11724428
Hi,

I now have my Service login correct by creating a specific account.
My problem now is that this service performs a sql query on a SQL Server database, counts the number of records and writes to a text file.
As my code reaches the open statement of the query, the Service restarts.
Why cant I run this query? I have placed the same code in a regular exe and there is no problem so I believe it is something to do with Services.

Thanks
0
 
LVL 17

Expert Comment

by:TheRealLoki
ID: 11729827
So are you saying that the service is working now, but you have a different problem now?
I mean, does this SQL work in the service on the other server 2003? or is this new?

do  you have a try-except around your code, so you can catch any errors and log them (the event log might be a good place)
A common mistake I make when writing sql is I leave the database component connected at design time, and it then causes an error when I run it (trying to connect when already connected, or can not find the default database, etc)
make sure you have set any connected properties to false before you compile. Aside from that, I'll need a little more information. sSee if you can get an error message
try
...
except on e:exception do
 " save error" E.Message
end;
0
 
LVL 17

Expert Comment

by:TheRealLoki
ID: 13341605
my suggestions appear to have resolved his first issue, but then he has a subsequent sql related issue which I asked for more information, and made some suggestions for. I have not heard back from him about this
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question