B4J Question NSSM/Webserver app/SQL Server connect

[Jones Hone]

I have a web server app.
Use jtds-1.3.1-a.jar to connect to MS sql server.
Everything is OK.

In the same APP, on the same computer, in the same directory.
I use "NSSM" to make the app a windows service.
It can be made into a service and web server starts correctly.
But only SQL SERVER connection fails!
It returns the following message:
"java.sql.SQLException: Unable to open database "TESTDB" requested for login. Login failed."

I switched back to running it with java.exe -jar myapp.jar and it all worked fine again.

Has anyone encountered this problem?
Or is "JDTS" not able to be executed in then service mode?

 

[aeric]

Try find jtds 1.3.2.jar see if it helps?

 

[Jones Hone]

Ah! Version 1.3.2 still doesn't work! Thank you.

 

[aeric]

A related thread

jRDC2 & NSSM

Hi guys. I'm using jRDC2 on a remote server (Windows 2016) so I can connect to a MS SQL Server via B4A app. It all works OK except jRDC2 exits after a short period. It was suggested that jRDC2 be run as a service. Am trying NSSM but I get this message when starting the service - "Unexpected...

www.b4x.com

 

[Jones Hone]

I have referred to this! Still no solution!

 

[Isaacc]

Could be a permission issue. Set the service to run as a user with SQL access or grant NT AUTHORITY\SYSTEM access in SQL Server.

 

[aeric]

I am not familiar with running services on Windows.
Maybe you need to use Windows server edition or configure it to run more like a server, like disabling power saving mode or sleep.

Ask AI for advice.

 

[JohnF76]

I have a web server app.
Use jtds-1.3.1-a.jar to connect to MS sql server.
Everything is OK.

In the same APP, on the same computer, in the same directory.
I use "NSSM" to make the app a windows service.
It can be made into a service and web server starts correctly.
But only SQL SERVER connection fails!
It returns the following message:
"java.sql.SQLException: Unable to open database "TESTDB" requested for login. Login failed."

I switched back to running it with java.exe -jar myapp.jar and it all worked fine again.

Has anyone encountered this problem?
Or is "JDTS" not able to be executed in then service mode?

The Windows SYSTEM account doesn't have access to network resources.
Try running your serveice as the same user that you run the JAVA program.
You should run this sevice as an account that has the required network resources with the password set to NOT expire.
This account should NOT be an account with administrator authority.

 

[Jones Hone]

Thank you all.
After many days of research, I still haven't solved it.
Abandon the "SERVICE" mode for now.
I can only wait until I have time to study it.