• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

Service Application

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
HotRod40
Asked:
HotRod40
  • 3
  • 2
1 Solution
 
TheRealLokiSenior DeveloperCommented:
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
 
MikProgCommented:
Any action in windows have result. What error code do you recieve if app does not started?
0
 
HotRod40Author Commented:
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
HotRod40Author Commented:
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
 
TheRealLokiSenior DeveloperCommented:
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
 
TheRealLokiSenior DeveloperCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now