Cannot Connect to database in service application

pithakse · Post by **pithakse** » Fri 13 Aug 2010 11:13

Hi,

I have problem on connect to sql-server in service application.
The error are time-out.

But if I try with the same code in IDE it work fine.

My Delphi is v 6.02
and dbexpress driver Version 4.45.18 (04-Sep-2009)

Please advise

Thank you in advance

Dimon · Post by **Dimon** » Fri 13 Aug 2010 12:31

To solve the problem try to set the TSQLConnection.LoginPrompt property to False.

pithakse · Post by **pithakse** » Sat 14 Aug 2010 04:54

Thank you for your reply.
May be my bad luck, the problem stll unsolve.

Dimon · Post by **Dimon** » Mon 16 Aug 2010 09:33

Please specify the exact error message that arises in your application.

pithakse · Post by **pithakse** » Wed 18 Aug 2010 11:56

Very sorry for late reply. Now I am on the way traveling.
When I back to office I will give you more detail.

Thank you
Best regards
Pithakse

martin · Post by **martin** » Fri 07 Jan 2011 22:42

Make sure you are not using Windows Logon Authentication in SQL Server but use SQL Server Authentication. Windows Services often run under very restricted Accounts and therefore it is possible that your Account does not have the credentials to access the SQL Server by Windows Authentication.

We are using dbExpressin our Services with no problems, well at least no Logon problems..