How 2 Configure Site Authentication to use Microsoft SQL DB
Posted: Fri Jan 17, 2020 4:53 pm
I tried to find the answer for this generally online by googling "Does MySQL and Microsoft SQL work interchangeably", but based on that search it doesn't appear they work in the same way. My organization uses Microsoft SQL and I can quickly and easily create an SQL database for WingFTP to use when storing usernames and passwords.
So my question is, can a WingFTP site be configured to connect to a Microsoft SQL server Database using the existing MySQL Settings tab that appears on the Site Authentication settings page, or can only strictly MySQL be used?
If it's possible to use a Microsoft SQL Database for authentication, is there a utility or feature that reads what is already stored in XML files, and converts them or imports data from each into the Microsoft SQL Database? Or would we need to manually create new accounts and passwords if we converted a site from using XML Files for authentication to the Microsoft SQL database for authentication?
Hope my need makes sense. Thanks for any help you can give!
So my question is, can a WingFTP site be configured to connect to a Microsoft SQL server Database using the existing MySQL Settings tab that appears on the Site Authentication settings page, or can only strictly MySQL be used?
If it's possible to use a Microsoft SQL Database for authentication, is there a utility or feature that reads what is already stored in XML files, and converts them or imports data from each into the Microsoft SQL Database? Or would we need to manually create new accounts and passwords if we converted a site from using XML Files for authentication to the Microsoft SQL database for authentication?
Hope my need makes sense. Thanks for any help you can give!