Microsoft SQL

BinaryNexus

Two Questions:Question 1:I know this has been discussed a little in the past but I wanted to touch base on it again just to see if something has changed. Is it possible to get osTicket to work with Microsoft SQL Server? Our company is strongly tied to SQL server and I was hoping to get this working with that.-----Question 2:Is the only way to create a ticket, without requiring a sign in, by using the API?-----Thanks in advance!

ntozier

Q: Is it possible to get osTicket to work with Microsoft SQL Server?A: We do not support Microsoft SQL Server, so I highly doubt it.Q: Is the only way to create a ticket, without requiring a sign in, by using the API?A: No. People going to the site could utilize guest mode. (Alternatively, you could also setup LDAP and SSO so that they are technically already logged in.)

hawkhead99

I know this thread is over a year old... But it may be worth noting (for those users who are holding out hope) that osTicket is moving toward a ORM model (slowly, but surely). Once that is complete, it would not be very difficult to switch to SQL Server.BTW - I have a MSSql file that has all the equivalents of MySQL if anyone wants it... Although I have never converted osTicket itself - this would save you *some* work. It also assumes you are using SQL server for PHP (https://msdn.microsoft.com/en-us/data/ff657782.aspx). The way SQL Server queries are slightly different from the MySQL driver - so this would be quite a project with osTicket the way it is in its current state. Attached is the file

[mssql.inc.zip](https://forum.osticket.com/assets/files/migrated/FileUpload/6d/b23d4c92b69a0a3e2ce1bf2f61b676.zip)