Page 1 of 1

How to access user list in a Database SQL Centralized

Posted: Tue Dec 11, 2012 6:48 am
by andrea
Hello,

we need to read and get the list of user/login from an external centralized database on a server Microsoft SQL Server and use it in iX.
How is it possible? And the better method?

Thank you

Andrea

Re: How to access user list in a Database SQL Centralized

Posted: Tue Dec 11, 2012 9:11 am
by mark.monroe
This forum post has a project that adds users to the security system on the HMI.

If you are using a PC based HMI, then you should be able to use a C# SQL connection library to connect to your remote SQL server. If it is a Windows CE unit, you will have to do more digging and see if you can find a C# library that allows you to remotely connect to your SQL server.

Re: How to access user list in a Database SQL Centralized

Posted: Tue Dec 11, 2012 10:13 am
by andrea
The better thing should be to be able to syncronize user defined inside iX (installed on more machines) with a table of users managed on SQL Server.
is that possible?
We would like to continue to use the user management offered by iX but with data of user and password updated on the server.

Thank you

Re: How to access user list in a Database SQL Centralized

Posted: Mon Dec 17, 2012 9:41 am
by mark.monroe
Passwords are hashed in iX Developer and you can not just send a password directly to iX Developer. You first have to hash it.

What you want to do is possible, but you would have to write all the C# code yourself.