SelfService and MS-SQL

[rupertvz]

Hi Guys,

I have a little app accessing / synchronising data to a MS-SQL database.
When I run the EXE manually, all is working fine.

I am trying to generate a service by adding the SelfService template, but it doesn't seem to work.
I have a log file reporting the connection activity.

When running as a service the application just stalls.  IOW no recurring connection attemps.

Could this be some problem with a Windows service trying to authenticate to MS-SQL multiple times?

[Bruce]

Hi Rupert,

Have you set a dependancy so that your service is depenat on msSql starting first?

Also make sure you don't do any Sql access before the server "starts". Recently there was someone who tried to get settings from SQL for the service itself and that seems not to work.

I'd also recommend debugging how far the application gets before it stalls. Perhaps you have some
code in your startup code which is failing when running in service mode.

Cheers
Bruce