Microsoft SQL Server 2017 compatibility?

[chadwatson]

Hi all,

Our DBA is in the process of moving our databases over to a SQL Server 2017 server. He set them up in compatibility mode. However, while it appears like I can connect to the database, I have not been able to get it to load the data without errors. I have not changed any of the SQL in the load script, just the data connection which works against our databases sitting on SQL Server 2016. Has anyone else had this issue, or do you know if support for SQL Server 2017 will be coming soon? (Currently running QS Server April 2018)

Thanks!

[chadwatson · Accepted solution]

After some research we found that our service account did not have rights to all of the databases that it needed rights to. Once we fixed that we had no issues connecting to SQL Server 2017.