NetTalk Central

The Rest Of NetTalk => The Rest - Ask For Help => Topic started by: rupertvz on May 09, 2016, 02:46:28 AM

Title: SelfService and MS-SQL
Post by: rupertvz on May 09, 2016, 02:46:28 AM

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?

Title: Re: SelfService and MS-SQL
Post by: Bruce on May 09, 2016, 10:41:53 PM

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