Lianja sql server authentication

[deepakrjx]

I am able to connect to the Lianja SQL Server using the connection string:
lcDSNLess="DRIVER=Lianja ODBC Driver;SERVER=?;DATABASE=southwind;Uid=?;Pwd=?"

The connection fails if I try :
lcDSNLess="DRIVER=Lianja ODBC Driver;SERVER=?;DATABASE=southwind;Uid=admin;Pwd=a dmin"

Also I tried adding records into the system!syroles table but that also did not work
lcDSNLess="DRIVER=Lianja ODBC Driver;SERVER=?;DATABASE=southwind;Uid=myname;Pwd= mypwd"


How and where do I add users into the LSQL server ?

I need to connect to remote LSQL server with UID+PWD authentication from other applications written in VFP / Excel / Python.

[yvonne.milne]

Hi deepakrjx,

The Lianja SQL Server uses the operating system user authentication/permissions. Specify a valid username and password for the server's host OS. You can also deny/allow connections based on ranges of or individual IP addresses in the Security settings of the Lianja Server Manager.

Regards,

Yvonne

[deepakrjx]

Thanks Yvonne. Connections work with username & password on the server's host OS.

Regards,

Deepak