Ario.Paxaz Posted August 29, 2017 Share Posted August 29, 2017 Hi What is the best way for communicate with SQL Sever in uni Application?. Login with SA or windows authentication. Best Regards. Quote Link to comment Share on other sites More sharing options...
mhmda Posted August 29, 2017 Share Posted August 29, 2017 You question not clear: is it about connection OR security? For connection you may use Devart UNIDAC. Quote Link to comment Share on other sites More sharing options...
zemorango Posted August 30, 2017 Share Posted August 30, 2017 To login to a sql server never use the SA user, create a user that can work in the database you want to use, login with SA user is a big security issue. Quote Link to comment Share on other sites More sharing options...
asapltda Posted August 31, 2017 Share Posted August 31, 2017 Hi What is the best way for communicate with SQL Sever in uni Application?. Login with SA or windows authentication. Which is better to use? Define database users or define users on windows operating system? Could be the interpretation to the question sent Best Regards. Quote Link to comment Share on other sites More sharing options...
Jean-Marc Kiener Posted August 31, 2017 Share Posted August 31, 2017 Depends on your environment. If you use windows operating system user then keep behind that your unigui module uses the User in which the dll runs for log in to the db server/db. If you use apache then i think its the user the apache service start with. On IIS you can define the user in the application pool. If you define a user in sql server then you are on the easier side. But then you have to set the password in your unigui module what could be a security issue. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.